• Corpus ID: 1419691

A Comprehensive Method for Data Warehouse Design

  title={A Comprehensive Method for Data Warehouse Design},
  author={Sergio Luj{\'a}n-Mora and Juan Trujillo},
  booktitle={Design and Management of Data Warehouses},
This paper has been supported by a grant from the State Secretary of Education and Universities (Spanish Ministry of Education, Culture and Sport). 

Figures and Tables from this paper


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.


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

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

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

  • Sonal SharmaRajni Jain
  • Economics
    2014 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

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

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

Multidimensional Design by Examples

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

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.



Designing Data Warehouses with OO Conceptual Models

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

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

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

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

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

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

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

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

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

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.