Filters








60,805 Hits in 2.8 sec

Towards data warehouse design

Franck Ravat, Olivier Teste, Giles Zurfluh
1999 Proceedings of the eighth international conference on Information and knowledge management - CIKM '99  
Moreover, we introduce constraints which configure the data warehouse behaviour and these various parts. To validate our propositions, we describe a prototype dedicated to the data warehouse design.  ...  This paper focuses on data warehouse modelling.  ...  The warehouses are generated in the O2 (4.6 version) OODBMS. CONCLUSION In this paper, we present a solution to design data warehouses in a medical context.  ... 
doi:10.1145/319950.320028 dblp:conf/cikm/RavatTZ99 fatcat:tfr7hmvvdnenbcvf4dk4xrasta

Towards Data Warehouse Quality Metrics

Coral Calero, Mario Piattini, Carolina Pascual, Manuel A. Serrano
2001 Design and Management of Data Warehouses  
It is essential that we can assure the information quality of the data warehouse, as it became the main tool for strategic decisions.  ...  Information quality depends on presentation quality and the data warehouse quality. This last includes the multidimensional model quality.  ...  We have presented some metrics for measuring the data warehouse star design.  ... 
dblp:conf/dmdw/CaleroPPS01 fatcat:ou2gmycmlnfuffvkugzuve3zzm

Towards Designing Conceptual Data Models for Big Data Warehouses: The Genomics Case

João Galvão, Ana León, Carlos Costa, Maribel Yasmina Santos, Oscar Pastor López
2020 European, Mediterranean and Middle Eastern Conference on Information Systems  
This work contributes to the process of designing conceptual data models for Big Data Warehouses proposing a method based on rules and design patterns, which aims to gather the information of a certain  ...  In the demonstration case presented here, a genomics relational model is merged with the proposed Big Data Warehouse Conceptual Metamodel to obtain the Big Genome Warehouse Conceptual Model, showing that  ...  a method that includes patterns and rules to guide practitioners from the BDWCMT to the design of a specific Big Data Warehouse Conceptual Model (BDWCM).  ... 
doi:10.1007/978-3-030-63396-7_1 dblp:conf/emcis/GalvaoL0SL20 fatcat:az5bz4qtyfhnvkponnlcheht2a

Focusing the customer: a critical approach towards design and use of data warehousing in corporate CRM

Martin Schwartz, Oliver Schliebs, Boris Wyssusek
2002 Design and Management of Data Warehouses  
and takes a critical position concerning the roles which technology vs. design, implementation and use play in applying a CRM philosophy in corporate business.  ...  We will thereby focus on the Data Warehousingrelated analytical part of CRM, although the experiences we are going to present are not limited to this field.  ...  "Design" of a CRM Data Warehouse consists mainly of selecting and commonly agreeing on appropriate content to satisfy the interests of the users, while "Management" of a CRM system has to be understood  ... 
dblp:conf/dmdw/SchwartzSW02 fatcat:rfnwlsqbbjendp4k25ttor3y2a

Towards the Automation of Data Warehouse Logical Design: a Rule-Based Approach

Verónika Peralta, Alvaro Illarze, Raúl Ruggia
2003 International Conference on Advanced Information Systems Engineering  
Data Warehouse logical design involves the definition of structures that enable an efficient access to information.  ...  Existing work in this area has mainly focused on aspects like data models, data structures specifically designed for DWs, and criteria for defining table partitions and indexes.  ...  This framework has been prototyped [14] in a CASE environment for DW design.  ... 
dblp:conf/caise/PeraltaIR03a fatcat:lzcmr7y4qzeofc4hno5zzcaypu

Merge of X-ETL and XCube towards a Standard Hybrid Method for Designing Data Warehouses

Nawfal El Moukhi, Ikram El, Abdelaaziz Mouloudi, Abdelali Elmounadi
2019 International Journal of Advanced Computer Science and Applications  
In this paper, the authors try to identify and analyze the different hybrid methods developed for building data warehouses.  ...  There is no doubt that the hybrid approach is the best paradigm for designing effective multidimensional schemas.  ...  Thus, several studies have recently been conducted to develop hybrid methods for designing data warehouses.  ... 
doi:10.14569/ijacsa.2019.0101019 fatcat:rxy5bxmtvbdspbzbw6w4vche5e

Towards a Formal Modelling of Data Warehouse Systems Design

2020 SETWM-20, ACBES-20 & EEHSS-20 Nov. 16-17, 2020 Johannesburg (SA)   unpublished
The star-and snowflake structures are two prominent approaches for specifying data marts of a data warehouse schema, resulting from a UML design.  ...  Some research works have proposed a hybrid-driven approach that combines the data-driven approach and the requirements-driven approach to address specifically the design of static aspects around data warehouse  ...  the class diagram for data-warehouse design at the conceptual level.  ... 
doi:10.17758/eares10.eap1120288 fatcat:owkkmfiysvadnaeuemeurrf5jy

Pervasive SAS Techniques for Designing a Data Warehouse for an Integrated Enterprise: An Approach towards Business Process

Ardhendu Tripathy, Kaberi Das, Tripti Swarnkar
unpublished
SAS can very quickly be adapted for uses by relative beginners in novel ways to exploit its strengths as a data extraction and manipulation tool.  ...  The key to data warehousing is data design. In this paper we are going to describe how SAS tool will help us to design a data warehouse for an integrated enterprise.  ...  However, the quantity of data in data warehouses requires attention to performance and efficiency in their design. E.  ... 
fatcat:6pihtfybmfcanhp3mxyl4wycuq

Improving OLTP data quality using data warehouse mechanisms

Matthias Jarke, Christoph Quix, Guido Blees, Dirk Lehmann, Gunter Michalk, Stefan Stierl
1999 SIGMOD record  
Based on the observation that decision support clients are often closely linked to operational data entry, we have addressed the problem of mapping the data warehouse data quality techniques back to data  ...  However, considering total information supply chain management, the capture of poor operational data, to be cleaned later in the data warehouse, appears sub-optimal.  ...  Conclusions Data warehouse research has contributed significantly towards improved data quality for decision makers [JJQV99] , cleaning data as they flow from sources towards clients.  ... 
doi:10.1145/304181.304568 fatcat:slbva225ufclfkqywhywh6z52y

Improving OLTP data quality using data warehouse mechanisms

Matthias Jarke, Christoph Quix, Guido Blees, Dirk Lehmann, Gunter Michalk, Stefan Stierl
1999 Proceedings of the 1999 ACM SIGMOD international conference on Management of data - SIGMOD '99  
Based on the observation that decision support clients are often closely linked to operational data entry, we have addressed the problem of mapping the data warehouse data quality techniques back to data  ...  However, considering total information supply chain management, the capture of poor operational data, to be cleaned later in the data warehouse, appears sub-optimal.  ...  Conclusions Data warehouse research has contributed significantly towards improved data quality for decision makers [JJQV99] , cleaning data as they flow from sources towards clients.  ... 
doi:10.1145/304182.304568 dblp:conf/sigmod/JarkeQBLMS99 fatcat:bbk2h5vbsbcxjenl4gflv2iomq

Enhanced Security Framework to Develop Secure Data Warehouse

Anshuman Kumar Saurabh, Bharti Nagpal
2011 International Journal of Communication Networks and Security  
In this paper, a framework is proposed to prevent the data from unauthorized access and thereby increases the security of data warehouse.  ...  The data warehouse can be easily accessed by an authorized user or by an unauthorized user through unfair means.  ...  A lot of research is done in the internal security of data warehouse at the time of data warehouse design.  ... 
doi:10.47893/ijcns.2011.1021 fatcat:vdbkfrdhufbwrbfpqyhza5kone

Data Warehouse Metadata [chapter]

Panos Vassiliadis
2016 Encyclopedia of Database Systems  
that access the data warehouse in various ways.  ...  Data warehouse metadata are pieces of information stored in one or more special-purpose metadata repositories that include (a) information on the contents of the data warehouse, their location and their  ...  KEY APPLICATIONS Data Warehouse Design.  ... 
doi:10.1007/978-1-4899-7993-3_912-2 fatcat:3hm3haf5xvdx5ccawyo2rxh5fu

Data Warehouse as a Generic Approach a Review
English

Shahid Bashir Dar, As hish Sharma
2015 International Journal of Innovative Research in Computer and Communication Engineering  
But least research has been done to develop a generic tool that can create a warehouse irrespective of enterprise and data.  ...  These efforts resulted in the development of data warehousing as a solution for data integration and data analytics.  ...  design optimal structure of data warehouse. ii.  ... 
doi:10.15680/ijircce.2015.0307018 fatcat:hxdhacdlmjd7tay2tgmnle6way

XML Warehousing and OLAP [article]

Hadj Mahboubi, Jérôme Darmont
2017 arXiv   pre-print
We also discuss the issues and future trends in this area and illustrate this topic by presenting the design of a unified, XML data warehouse architecture and a set of XOLAP operators expressed in an XML  ...  The aim of this article is to present an overview of the major XML warehousing approaches from the literature, as well as the existing approaches for performing OLAP analyses over XML data (which is termed  ...  All these studies more or less converge toward a unified XML warehouse model.  ... 
arXiv:1701.08612v1 fatcat:ne65xezff5hltdo2sbdwlr6lay

Flexible Data Warehouse Parameters: Toward Building an Integrated Architecture

Mustafa Musa Jaber, Mohd Khanapi Abd Ghani, Nanna Suryana, Mohammed Aal Mohammed, Thamir Abbas
2015 Journal of clean energy technologies  
The aim of is project is to find the parameters of medical data warehouse which will be able to construct a flexible framework by analyze the approaches of data warehouse architectures and compare them  ...  The proposed parameters may assist in achieving continual access to the common data warehouse.  ...  The processes of data warehousing is used to design and develop data warehouses for exposure and to effective DSS, data warehouse design and development, has already paying attention of several researchers  ... 
doi:10.7763/ijcte.2015.v7.984 fatcat:neq5myse5ngurimjlnibstfmpy
« Previous Showing results 1 — 15 out of 60,805 results