A UML Profile for Representing Business Object States in a Data Warehouse

  • Veronika Stefanov
  • Beate List
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4654)


Data Warehouse (DWH) systems allow to analyze business objects relevant to an enterprise organization (e.g., orders or customers).

Analysts are interested in the states of these business objects: A customer is either a potential customer, a first time customer, a regular customer or a past customer; purchase orders may be pending or fullfilled.

Business objects and their states can be distributed over many parts of the DWH, and appear in measures, dimension attributes, levels, etc.

Surprisingly, this knowledge – how business objects and their states are represented in the DWH – is not made explicit in existing conceptual models. We identify a need to make this relationship more accessible.

We introduce the UML Profile for Representing Business Object States in a DWH. It makes the relationship between the business objects and the DWH conceptually visible. The UML Profile is applied to an example.


State Machine Data Warehouse Object Constraint Language Business Object Object Management Group 
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.
    Rumbaugh, J., Jacobson, I., Booch, G.: The Unified Modeling Language Reference Manual. Addison-Wesley, Reading (2004)Google Scholar
  2. 2.
    Stefanov, V., List, B., Korherr, B.: Extending UML 2 Activity Diagrams with Business Intelligence Objects. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2005. LNCS, vol. 3589, pp. 53–63. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  3. 3.
    Kimball, R.: Fundamental Grains. Intelligent Enterprise 2(5) (1999)Google Scholar
  4. 4.
    Object Management Group, Inc.: UML 2.0 Superstructure (2005),
  5. 5.
    Object Management Group, Inc.: UML 2.0 Object Constraint Language (OCL) Specification (2005),
  6. 6.
    Object Management Group, Inc.: Model Driven Architecture (MDA) (2004),
  7. 7.
    Luján-Mora, S., Trujillo, J.: A Data Warehouse Engineering Process. In: Yakhno, T. (ed.) ADVIS 2004. LNCS, vol. 3261, pp. 14–23. Springer, Heidelberg (2004)Google Scholar
  8. 8.
    Trujillo, J., Luján-Mora, S.: A UML Based Approach for Modeling ETL Processes in Data Warehouses. In: Song, I.-Y., Liddle, S.W., Ling, T.-W., Scheuermann, P. (eds.) ER 2003. LNCS, vol. 2813, pp. 307–320. Springer, Heidelberg (2003)Google Scholar
  9. 9.
    Luján-Mora, S., Trujillo, J.: Physical modeling of data warehouses using UML. In: DOLAP 2004, Proceedings, pp. 48–57. ACM Press, New York (2004)CrossRefGoogle Scholar
  10. 10.
    Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59(3), 725–769 (2006)CrossRefGoogle Scholar
  11. 11.
    Fernández-Medina, E., Trujillo, J., Villarroel, R., Piattini, M.: Extending UML for Designing Secure Data Warehouses. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, pp. 217–230. Springer, Heidelberg (2004)Google Scholar
  12. 12.
    Mazon, J.N., Trujillo, J., Serrano, M., Piattini, M.: Applying MDA to the development of data warehouses. In: Proceedings DOLAP 2005, pp. 57–66. ACM Press, New York, NY, USA (2005)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2007

Authors and Affiliations

  • Veronika Stefanov
    • 1
  • Beate List
    • 1
  1. 1.Women’s Postgraduate College for Internet Technologies, Vienna University of Technology 

Personalised recommendations