ACM SIGMOD Anthology ACM SIGMOD dblp.uni-trier.de

Deriving Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems.

Michael Böhnlein, Achim Ulbrich-vom Ende: Deriving Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems. DOLAP 1999: 15-21
@inproceedings{DBLP:conf/dolap/BoehnleinE99,
  author    = {Michael B{\"o}hnlein and
               Achim Ulbrich-vom Ende},
  title     = {Deriving Initial Data Warehouse Structures from the Conceptual
               Data Models of the Underlying Operational Information Systems},
  booktitle = {DOLAP '99, ACM Second International Workshop on Data Warehousing
               and OLAP, November 6, 1999, Kansas City, Missouri, USA, Proceedings},
  publisher = {ACM},
  year      = {1999},
  pages     = {15-21},
  ee        = {db/conf/dolap/BoehnleinE99.html, http://doi.acm.org/10.1145/319757.319780},
  crossref  = {DBLP:conf/dolap/99},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

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.

Copyright © 1999 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 2 Issue 4, CIKM, DOLAP, GIS, SIGFIDET, ..." and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

DOLAP '99, ACM Second International Workshop on Data Warehousing and OLAP, November 6, 1999, Kansas City, Missouri, USA, Proceedings. ACM 1999
Contents BibTeX

Online Edition

Citation Page BibTeX

References

[1]
...
[2]
...
[3]
...
[4]
Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX
[5]
...
[6]
...
[7]
...
[8]
...
[9]
...
[10]
...
[11]
W. H. Inmon: The Data Warehouse and Data Mining. Commun. ACM 39(11): 49-50(1996) BibTeX
[12]
...
[13]
...
[14]
...
[15]
Wilburt Labio, Dallan Quass, Brad Adelberg: Physical Database Design for Data Warehouses. ICDE 1997: 277-288 BibTeX
[16]
...
[17]
...
[18]
...
[19]
...
[20]
Arie Shoshani: Statistical Databases: Characteristics, Problems, and some Solutions. VLDB 1982: 208-222 BibTeX
[21]
...
[22]
...
[23]
...
[24]
...
[25]
...
BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
DOLAP 1999 Proceedings, ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:07:20 2009