Advertisement

Extending the UML for Multidimensional Modeling

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

Abstract

Multidimensional (MD) modeling is the foundation of data warehouses, MD databases, and On-Line Analytical Processing (OLAP) applications. In the past few years, there have been some proposals for representing the main MD properties at the conceptual level providing their own notations. In this paper, we present an extension of the Unified Modeling Language (UML), by means of stereotypes, to elegantly represent main structural and dynamic MD properties at the conceptual level. We make use of the Object Constraint Language (OCL) to specify the constraints attached to the defined stereotypes, thereby avoiding an arbitrary use of these stereotypes. The main advantage of our proposal is that it is based on a well-known standard modeling language, thereby designers can avoid learning a new specific notation or language for MD systems. Finally, we show how to use these stereotypes in Rational Rose 2000 for MD modeling.

Keywords

UML UML extensions multidimensional modeling OCL Rational Rose 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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). (1998) 3–9Google Scholar
  2. 2.
    Sapia, C., Blaschka, M., Höfling, G., Dinter, B.: 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). (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 DataWarehouses (DMDW’00), Stockholm, Sweden (2000)Google Scholar
  5. 5.
    Trujillo, J., Palomar, M., Gómez, J., Song, I.Y.: Designing Data Warehouses with OO Conceptual Models. IEEE Computer, special issue on Data Warehouses 34 (2001) 66–75Google Scholar
  6. 6.
    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
  7. 7.
    Booch, G., Rumbaugh, J., Jacobson, I.: The Unified Modeling Language: User Guide. Object Technology Series. Addison-Wesley (1999)Google Scholar
  8. 8.
    Object Management Group (OMG): Unified Modeling Language Specification 1.4. Internet: http://www.omg.org/cgi-bin/doc?formal/01-09-67 (2001)
  9. 9.
    Conallen, J.: Building Web Applications with UML. Object Technology Series. Addison-Wesley (2000)Google Scholar
  10. 10.
    Naiburg, E., Maksimchuk, R.: UML for Database Design. Object Technology Series. Addison-Wesley (2001)Google Scholar
  11. 11.
    Ambler, S.: Persistence Modeling in the UML. Software Development Online. Internet: http://www.sdmagazine.com/documents/s=755/sdm9908q/ (1999)
  12. 12.
    Rational Software Corporation: The UML and Data Modeling. Internet: http://www.rational.com/media/whitepapers/Tp180.PDF (2000)
  13. 13.
    Marcos, E., Vela, B., Cavero, J.M.: Extending UML for Object-Relational Database Design. In: Proc. of the 4th Intl. Conference UML 2001. Volume 2185 of LNCS., Springer-Verlag (2001) 225–239Google 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 warehousing toolkit. 2 edn. John Wiley (1996)Google Scholar
  16. 16.
    Warmer, J., Kleppe, A.: The Object Constraint Language. Precise Modeling with UML. Object Technology Series. Addison-Wesley (1998)Google Scholar
  17. 17.
    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