A Comprehensive Method for Data Warehouse Design
@inproceedings{LujnMora2003ACM, title={A Comprehensive Method for Data Warehouse Design}, author={Sergio Luj{\'a}n-Mora and Juan Trujillo}, booktitle={Design and Management of Data Warehouses}, year={2003} }
This paper has been supported by a grant from the State Secretary of Education and Universities (Spanish Ministry of Education, Culture and Sport).
71 Citations
COMPARATIVE STUDY OF DATA WAREHOUSE DESIGN APPROACHES : A SURVEY
- Computer Science
- 2012
This paper surveyed and evaluated the literature related to the various data warehouse design approaches on the basis of design criteria and proposes a generalized object oriented conceptual design framework based on UML that meets all types of user needs.
DATA WAREHOUSE: CONCEPTUAL AND LOGICAL SCHEMA -SURVEY-
- Computer Science
- 2012
This work contains a presentation of the conceptual design models and the different logical schemas that exist in the Data Warehouse and their impact on the quality of DW projects.
Methoden und Modelle für den Entwurf von Data Warehouses
- Engineering
- 2004
Data Warehouses sind Datenbanken, die Unternehmensdaten fur interaktive und automatische Datenanalysen verwalten. Der Beitrag behandelt die zentralen Phasen im Entwurf von Data Warehouses sowie die…
A Step towards Centralized Data Warehousing Process : A Quality Aware Data Warehouse Architecture
- Computer Science
- 2009
A new DW architecture has been proposed by integrating those similar processes and this new architecture concentrates mainly on the quality of the DW, as it is one of the critical aspects of DW.
Modeling ETL Process for Data Warehouse: An Exploratory Study
- Economics2014 Fourth International Conference on Advanced Computing & Communication Technologies
- 2014
This paper has focused on the working of Extraction, Transformation and Loading, and the focus has also been laid on the data quality problem which in result leads to falsification of analysis based on that data.
Requirements Specification and Conceptual Modeling for Spatial Data Warehouses
- Computer ScienceOTM Workshops
- 2006
This paper proposes three different approaches for requirements specifications that lead to the creation of conceptual schemas for SDW applications.
Modern Software Engineering Methodologies Meet Data Warehouse Design: 4WD
- Computer ScienceDaWaK
- 2011
4WD is proposed, a design methodology that couples the main principles emerging from these methodologies to the peculiarities of data warehouse projects and the principles underlying 4WD are risk-based iteration, evolutionary and incremental prototyping, user involvement, component reuse, formal and light documentation, and automated schema transformation.
A proposed model for data warehouse ETL processes
- Computer ScienceJ. King Saud Univ. Comput. Inf. Sci.
- 2011
Multidimensional Design by Examples
- Computer ScienceDaWaK
- 2006
This approach automatically generates and proposes the set of multidimensional schemas satisfying the user requirements, from the organizational operational schemas, if no multiddimensional schema is generated for a query.
Goal-oriented requirement analysis for data warehouse design
- Computer ScienceDOLAP '05
- 2005
This paper proposes a goal-oriented approach to requirement analysis for data warehouses, based on the Tropos methodology, which can be employed within both a demand-driven and a mixed supply/demand-driven design framework.
References
SHOWING 1-10 OF 31 REFERENCES
Designing Data Warehouses with OO Conceptual Models
- Computer Science
- 2001
The authors propose an approach that provides a theoretical foundation for the use of object-oriented databases and object-relational databases in data warehouse, multidimensional database, and onl...
X-META: A methodology for data warehouse design with metadata management
- Computer ScienceDMDW
- 2002
A strategy for creating and managing metadata in an integrated way to the DW development process is proposed, in order to capture the organizational knowledge and minimize the problems which can be caused by the mobility of employees within and between organizations.
Building the data warehouse
- EducationCACM
- 1998
Y the authors' company decides to build a data warehouse and you are designated the project manager, and you have specific questions that need specific answers, and building a data Warehouse is an extremely complex process.
A methodological framework for data warehouse design
- Computer ScienceDOLAP '98
- 1998
This paper outlines a general methodological framework for data warehouse design, based on the Dimensional Fact Model (DFM), which suggests that conceptual design is carried out semi-automatically starting from the operational database scheme.
Designing the Data Warehouse
- Education
- 1995
This course provides students with the skills necessary to design a successful data warehouse. It is based on the following Ralph Kimball book: The Data Warehouse Toolkit: The Definitive Guide to…
From enterprise models to dimensional models: a methodology for data warehouse and data mart design
- Computer ScienceDMDW
- 2000
A method for developing dimensional models from traditional Entity Relationship models, which can be used to design data warehouses and data marts based on enterprise data models is described.
A UML Based Approach for Modeling ETL Processes in Data Warehouses
- Computer ScienceER
- 2003
This paper provides the necessary mechanisms for an easy and quick specification of the common operations defined in these ETL processes such as, the integration of different data sources, the transformation between source and target attributes, the generation of surrogate keys and so on.
Designing Data Warehouses with OO Conceptual Models
- Computer ScienceComputer
- 2001
This approach introduces a set of minimal constraints and extensions to UML 1 for representing multidimensional modeling properties for these applications and believes that this innovative approach provides a theoretical foundation for the use of OO databases and object-relational databases in data warehouses, MDB, and OLAP applications.
starER: a conceptual model for data warehouse design
- Computer ScienceDOLAP '99
- 1999
This paper argues that, in order to accurately reflect the users requirements into an error-free, understandable, and easily extendable data warehouse schema, special attention should be paid at the conceptual modeling phase.
YAM/sup 2/ (yet another multidimensional model): an extension of UML
- Computer ScienceProceedings International Database Engineering and Applications Symposium
- 2002
YAM/sup 2/ allows the representation of several semantically related star schemas, as well as summarizability and identification constraints, and its structures, integrity constraints and query operations.