Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems

In recent years the construction of large scale data schemes for operational systems has been the major problem of conceptual data modeling for business needs. Multidimensional data structures used for decision support applications in data warehouses have rather different requirements to data modeling techniques. In case of operational systems the data models are created from application specific requirements. The data models in data warehouses base on the analytical requirements of the users. Furthermore, the development of data warehouse structures implicates the consideration of user-defined information requirements as well as the underlying operational source systems. In this paper we show that the conceptual data models of the underlying operational information systems can support the construction of multidimensional structures. We would like to point out that the special features of the Structured Entity Relationship Model (SERM) are not only useful for the development of big operational systems but can also help with the derivation of data warehouse structures. The SERM is an extension of the conventional Entity Relationship Model (ERM) and the conceptual basis of the data modeling technique used by the SAP Corporation. To illustrate the usefulness of this approach we explain the derivation of the warehouse structures from the conceptual data model of a flight reservation system.

[1]  Alan Ewert,et al.  A New Dimension , 1986 .

[2]  Ralph Kimball,et al.  The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .

[3]  Jan Holthuis,et al.  Der Aufbau von Data-warehouse-Systemen: Konzeption - Datenmodellierung - Vorgehen , 1999 .

[4]  Wolfgang Behme,et al.  Führungsinformationssysteme: Geschichtliche Entwicklung, Aufgaben und Leistungsmerkmale , 1993 .

[5]  Elmar J. Sinz.  Das Strukturierte Entity-Relationship-Modell (SER-Modell) , 1988, Angew. Inform..

[6]  Dennis Murray,et al.  Data warehousing in the real world - a practical guide for building decision support systems , 1997 .

[7]  ChenPeter Pin-Shan.  The entity-relationship modeltoward a unified view of data , 1976 .

[8]  Goran Velinov,et al.  Physical Database Design for Data Warehouses , 2001 .

[9]  Roland Gabriel,et al.  Semantische Modellierungstechniken für multidimensionale Datenstrukturen , 1997, HMD Prax. Wirtsch..

[10]  Laurian M. Chirica,et al.  The entity-relationship model: toward a unified view of data , 1975, SIGF.

[11]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

[12]  Wilburt Labio,et al.  Physical database design for data warehouses , 1997, Proceedings 13th International Conference on Data Engineering.

[13]  W. H. Inmon,et al.  Building the data warehouse (2nd ed.) , 1996 .

[14]  Stephen Peterson,et al.  Stars: a pattern language for query-optimized schemas , 1995 .

[15]  Elmar J. Sinz,et al.  The structures entity-relationship model (SERM) , 1988 .

[16]  Ralph Kimball,et al.  A dimensional modeling manifesto , 1997 .

[17]  Michael Hahne,et al.  Logische Datenmodellierung für das Data Warehouse , 1999 .

[18]  Arie Shoshani,et al.  Statistical Databases: Characteristics, Problems, and some Solutions , 1982, VLDB.

[19]  W. H. Inmon,et al.  Building the data warehouse , 1992 .