Multidimensional Modeling with UML Package Diagrams

  • Sergio Luján-Mora
  • Juan Trujillo
  • Il -Yeol Song
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2503)


The Unified Modeling Language (UML) has become the de facto standard for object-oriented analysis and design, providing different diagrams for modeling different aspects of a system. In this paper, we present the development of multidimensional (MD) models for dataware-houses (DW) using UML package diagrams. In this way, when modeling complex and large DW systems, we are not restricted to use flat UML class diagrams. We present design guidelines and illustrate them with various examples. We show that the correct use of the package diagrams using our design guidelines will produce a very simple yet powerful design of MD models. Furthermore, we provide a UML extension by means of stereotypes of the particular package items we use. Finally, we show how to use these stereotypes in Rational Rose 2000 for MD modeling.


UML multidimensional modeling data warehouses UML extension UML packages 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    Golfarelli, M., Rizzi, S.: A methodological Framework for Data Warehouse Design. In: Proc. of the ACM 1st Intl. Workshop on Data warehousing and OLAP (DOLAP’98), Washington D.C., USA (1998) 3–9Google Scholar
  2. [2]
    Sapia, C., Blaschka, M., Höfling, G., Dinter, Extending the E/R Model for the Multidimensional Paradigm. In: Proc. of the 1st Intl. Workshop on Data Warehouse and Data Mining (DWDM’98). Volume 1552 of LNCS., Springer-Verlag (1998) 105–116Google Scholar
  3. [3]
    Tryfona, N., Busborg, F., Christiansen, J.: starER: A Conceptual Model for Data Warehouse Design. In: Proc. of the ACM 2nd Intl. Workshop on Data warehousing and OLAP (DOLAP’99), Kansas City, Missouri, USA (1999)Google Scholar
  4. [4]
    Husemann, B. Lechtenborger, J., Vossen, G.: Conceptual Data Warehouse Design. In: Proc. of the 2nd. Intl. Workshop on Design and Management of Data Warehouses (DMDW’2000), Stockholm, Sweden (2000) 3–9Google Scholar
  5. [5]
    Abelló, A., Samos, J., Saltor, F.: A Framework for the Classification and Description of Multidimensional Data Models. In: Proc. of the 12th Intl. Conference on Database and Expert Systems Applications (DEXA’01), Munich, Germany (2001) 668–677Google Scholar
  6. [6]
    Object Management Group (OMG): Unified Modeling Language Specification 1.4. Internet: (2001)
  7. [7]
    Trujillo, J., Palomar, M., Gómez, J., Song, I.: Designing Data Warehouses with OO Conceptual Models. IEEE Computer, special issue on Data Warehouses 34 (2001) 66–75Google Scholar
  8. [8]
    Feldman, P., Miller, D.: Entity Model Clustering: Structuring a Data Model by Abstraction. The Computer Journal 29 (1986) 348–360CrossRefGoogle Scholar
  9. [9]
    Teorey, T., Wei, G., Bolton, D., Koenig, J.: ER Model Clustering as an Aid for User Communication and Documentation in Database Design. Communications of ACM 32 (1989) 975–987CrossRefGoogle Scholar
  10. [10]
    Gandhi, M., Robertson, E., Gucht, D.V.: Leveled Entity Relationship Model. In: Proc. of the 13th Intl. Conference on Entity-Relationship Approach (ER’94). Volume 881 of LNCS., Springer-Verlag (1994) 420–436Google Scholar
  11. [11]
    Siau, K., Cao, Q.: Unified Modeling Language (UML)-A Complexity Analysis. Journal of Database Management 12 (2001) 26–34Google Scholar
  12. [12]
    Fowler, M.: UML Distilled. Applying the Standard Object Modeling Language. Object Technology Series. Addison-Wesley (1998)Google Scholar
  13. [13]
    Conallen, J.: Building Web Applications with UML. Object Technology Series. Addison-Wesley (2000)Google Scholar
  14. [14]
    Giovinazzo, W.: Object-Oriented Data Warehouse Design. Building a star schema. Prentice-Hall, New Jersey, USA (2000)Google Scholar
  15. [15]
    Kimball, R.: The Data Warehouse Toolkit. 2 edn. John Wiley & Sons (1996)Google Scholar
  16. [16]
    Rational Software Corporation: Using the Rose Extensibility Interface. Rational Software Corporation (2001)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2002

Authors and Affiliations

  • Sergio Luján-Mora
    • 1
  • Juan Trujillo
    • 1
  • Il -Yeol Song
    • 2
  1. 1.Dept. de Lenguajes y Sistemas InformàticosUniversidad de AlicanteSpain
  2. 2.College of Information Science and TechnologyDrexel UniversityUSA

Personalised recommendations