Data Warehouse Schema Design
The deployment of data warehouses, which are integrated databases to support decision making, has become current practice in modern information technology landscapes, and the methodical design process for such databases has been advanced significantly in recent years. In this context we are investigating questions concerning the automatic design and quality of data warehouse schemata.
We proposed multidimensional normal forms to measure and algorithmically enforce schema quality during conceptual design. These normal forms formalize correctness and completeness of data warehouse schemata with respect to the underlying operational databases, avoidance of redundancies, and context sensitive summarizability in the presence of null values. Our tool Data Warehouse Detective enables the design of data warehouse schemata based on multidimensional normal forms.
In view of complex dimension hierarchies we are investigating rich conceptual modeling approaches, their impact on summarizability, and automatic transformation approaches to implement rich conceptual models based on standard relational database technology.
Publications related to this project
- J.-N. Mazón, J. Lechtenbörger, J. Trujillo: A model-driven approach for enforcing summarizability in multidimensional modeling (1st International Workshop on Modeling and Reasoning for Business Intelligence (MoRE-BI, ER 2011 Workshop), LNCS 6999), 2011
- David Fekete: Optimierungstechniken in Column Stores, 2010
- Florian Blenkle: Aggregation korrelierender Maße im Data-Warehouse-Umfeld, 2009
- J.-N. Mazón, J. Lechtenbörger, J. Trujillo: A survey on summarizability issues in multidimensional modeling (Data & Knowledge Engineering, 68 (12), 1452-1469, 2009), 2009 (Abstract)
- J.-N. Mazón, J. Lechtenbörger, J. Trujillo: Solving Summarizability Problems in Fact-Dimension Relationships for Multidimensional Models (Proc. 11th ACM International Workshop on Data Warehousing and OLAP (DOLAP)), 2008 (Abstract)
- Ph. Dopjans: Optimierung datenintensiver OLAP-Anwendungen am Beispiel Mondrian, 2008
- J.-N. Mazón, J. Trujillo, J. Lechtenbörger: Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms (Data & Knowledge Engineering, 63 (3), 725-751, 2007), 2007 (Abstract)
- E. Dombrowski: Modellgetriebene Techniken zur Implementierung semantisch reichhaltiger Data-Warehouse-Schemata, 2007
- M. Mzyk: Techniken und Konzepte für den logischen Data-Warehouse-Entwurf, 2006
- S. Rizzi, A. Abelló, J. Lechtenbörger, J. Trujillo: Research in Data Warehouse Modeling and Design: Dead or Alive? (Proc. 9th ACM International Workshop on Data Warehousing and OLAP (DOLAP)), 2006 (Abstract)
- J.-N. Mazón, J. Trujillo, J. Lechtenbörger: A Set of QVT Relations to Assure the Correctness of Data Warehouses by Using Multidimensional Normal Forms (Proc. 25th International Conference on Conceptual Modeling (ER)), 2006 (Abstract)
- J. Lechtenbörger: Keynote: My Favorite Issues in Data Warehouse Modeling (Abstract) (Proc. 8th ACM International Workshop on Data Warehousing and OLAP (DOLAP), p. 87), 2005
- E. Dombrowski, J. Lechtenbörger: Evaluation objektorientierter Ansätze zur Data-Warehouse-Modellierung (Datenbank-Spektrum 15), 2005
- J. Lechtenbörger, G. Vossen: Qualitätsorientierter Schemaentwurf für Datenlager (it - Information Technology 45 (2003) 4, 190-195), 2003 (Abstract)
- J. Lechtenbörger, G. Vossen: Multidimensional Normal Forms for Data Warehouse Design (Information Systems 28 (5), 415-434), 2003 (Abstract)
- J. Lechtenbörger: Data Warehouse Schema Design (Proc. 10th BTW 2003, pp. 513-522 (dissertation award)), 2003 (Download)
- Jens Lechtenbörger: Data Warehouse Schema Design (Dissertationen zu Datenbanken und Informationssystemen - Band 79, Infix), 2001 (Abstract)
- B. Hüsemann, J. Lechtenbörger, G. Vossen: Conceptual Data Warehouse Design (Proc. 2nd International Workshop on Design and Management of Data Warehouses (DMDW) 2000, Stockholm; Report 25, Swiss Life IT Research and Development Zürich, 6.1-6.11), 2000 (Abstract)
Datenmodelle, Datenbanksprachen und Datenbank- managementsysteme by Gottfried Vossen
Unleashing Web 2.0 by Gottfried Vossen and Stephan Hagemann
