Extending the E/R Model for the Multidimensional Paradigm

  • Carsten Sapia
  • Markus Blaschka
  • Gabriele Höfling
  • Barbara Dinter
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1552)


Multidimensional data modeling plays a key role in the design of a data warehouse. We argue that the Entity Relationship Model is not suited for multidimensional conceptual modeling because the semantics of the main characteristics of the paradigm cannot be adequately represented. Consequently, we present a specialization of the E/R model — called Multidimensional Entity Relationship (ME/R) Model. In order to express the multidimensional structure of the data we define two specialized relationship sets and a specialized entity set. The resulting ME/R model allows the adequate conceptual representation of the multidimensional data view inherent to OLAP, namely the separation of qualifying and quantifying data and the complex structure of dimensions. We demonstrate the usability of the ME/R model by an example taken from an actual project dealing with the analysis of vehicle repairs.


Data Warehouse Dimension Level Meta Model Multidimensional Data Graphical Notation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    A, Bauer, W. Lehner: The Cube-Query-Language (CQL) for Multidimensional Statistical and Scientific Database Systems, Proc. of the 5th CIKM, Melbourne 1997.CrossRefGoogle Scholar
  2. [2]
    M. Blaschka, C. Sapia, G. Höfling, B. Dinter: Finding Your Way through Multidimensional Data Models, DWDOT Workshop (DEXA 98), ViennaGoogle Scholar
  3. [3]
    S. Chaudhuri, U. Dayal: An Overview of Data Warehousing and OLAP Technology. SIG-MOD Records 26(1), 1997Google Scholar
  4. [4]
    P.P-S. Chen: The Entity Relationship Model — Towards a Unified View of Data. ACM TODS Vol. 1, No. 1, 1976Google Scholar
  5. [5]
    E. F. Codd: Extending the Database Relational Model to Capture More meaning. ACM TODS Vol. 4, No. 4 (December 1979)Google Scholar
  6. [6]
    L. Cabibbo, R. Torlone: A Logical Approach to Multidimensional Databases. EDBT 1998.CrossRefGoogle Scholar
  7. [7]
    S. Dekeyser, B. Kuijpers, J. Paredaens, J. Wijsen: The nested datacube model for OLAP in Advances in Database Technology, LNCS, Springer VerlagGoogle Scholar
  8. [8]
    M. Golfarelli, D. Maio, S. Rizzi, Conceptual design of data warehouses from FIR schemes, Proc. 31st Hawaii Intl. Conf. on System Sciences, 1998.Google Scholar
  9. [9]
    V. Harinarayan, A. Rajaraman, J. D. Ullman: Implementing Data Cubes Efficiently. Proc. SIGMOD Conference, Montreal, Canada, 1996CrossRefGoogle Scholar
  10. [10]
    G. Höfling, M. Blaschka, B. Dinter, P. Spiegel, T. Ringel: Data Warehouse Technology for the Management of Diagnosis Data (in German), in Dittrich, Geppert (eds.): Datenbanksysteme in Büro, Technik und Wissenschaft (BTW), Springer, 1997.Google Scholar
  11. [11]
    W. H. Inmon: Building the Data Warehouse, 2nd edition, John Wiley andSons, 1996Google Scholar
  12. [12]
    IRDS Framework ISO/IEC IS 10027, 1990Google Scholar
  13. [13]
    R. Kimball: A Dimensional Modeling Manifesto, DBMS Magazine, August 1997Google Scholar
  14. [14]
    W. Lehner, T. Ruf, M. Teschke: CROSS-DB: A Feature-Extended Multidimensional Data Model for Statistical and Scientific Databases, Proc. of the CIKM’96, Maryland.Google Scholar
  15. [15]
    Micro Strategy Inc.: The Case For Relational OLAP, White Paper. 1995Google Scholar
  16. [16]
    M. Rafanelli, A. Shoshani: STORM: A Statistical Object Representation, SSDBM 90Google Scholar
  17. [17]
    S.Y.W. Su: SAM*: A Semantic Association Model for Corporate and Scientific-Statistical Databases, in: Journal of Information Sciences 29, 1983Google Scholar
  18. [18]
    T.J. Teorey: Database Modeling and Design, 2nd edition, Morgan Kaufmann 1994Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1999

Authors and Affiliations

  • Carsten Sapia
    • 1
  • Markus Blaschka
    • 1
  • Gabriele Höfling
    • 1
  • Barbara Dinter
    • 1
  1. 1.Bavarian Research Center for Knowledge-Based SystemsFORWISSMunichGermany

Personalised recommendations