Design of a Multidimensional Model Using Object Oriented Features in UML

A data warehouse is a single repository of data which includes data generated from various operational systems. Conceptual modeling is an important concept in the successful design of a data warehouse. The Unified Modeling Language (UML) has become a standard for object modeling during analysis and design steps of software system development. The paper proposes an object oriented approach to model the process of data warehouse design. The hierarchies of each data element can be explicitly defined, thus highlighting the data granularity. We propose a UML multidimensional model using various data sources based on UML schemas. We present a conceptual-level integration framework on diverse UML data sources on which OLAP operations can be performed. Our integration framework takes into account the benefits of UML (its concepts, relationships and extended features) which is more close to the real world and can model even the complex problems easily and accurately. Two steps are involved in our integration framework. The first one is to convert UML schemas into UML class diagrams. The second is to build a multidimensional model from the UML class diagrams. The white-paper focuses on the transformations used in the second step. We describe how to represent a multidimensional model using a UML star or snowflake diagram with the help of a case study. To the best of our knowledge, we are the first people to represent a UML snowflake diagram that integrates heterogeneous UML data sources.

[1]  Hu Xuanzi,et al.  Application of Data Warehouse Technology in Data Center Design , 2008, 2008 International Conference on Computational Intelligence and Security.

[2]  Matteo Golfarelli,et al.  The Dimensional Fact Model: A Conceptual Model for Data Warehouses , 1998, Int. J. Cooperative Inf. Syst..

[3]  Swapan Bhattacharya,et al.  Conceptual Level Design of Object Oriented Data Warehouse: Graph Semantic Based Model , 2009 .

[4]  Veronika Stefanov,et al.  A UML Profile for Modeling Data Warehouse Usage , 2007, ER Workshops.

[5]  Daniel L. Moody,et al.  From enterprise models to dimensional models: a methodology for data warehouse and data mart design , 2000, DMDW.

[6]  Barbara Dinter,et al.  Extending the E/R Model for the Multidimensional Paradigm , 1998, ER Workshops.

[7]  Walid G. Aref,et al.  Digital government security infrastructure design challenges , 2001 .

[8]  Ivar Jacobson,et al.  The Unified Modeling Language User Guide , 1998, J. Database Manag..

[9]  José Samos,et al.  A Framework for the Classification and Description of Multidimensional Data Models , 2001, DEXA.

[10]  Nectaria Tryfona,et al.  starER: a conceptual model for data warehouse design , 1999, DOLAP '99.

[11]  Kamal Alaskar,et al.  Object Oriented Data Modeling for Data Warehousing (An Extension of UML approach to study Hajj pilgrim's private tour as a Case Study) , 2009, Int. Arab. J. e Technol..

[12]  Richard D. Hackathorn,et al.  Using the Data Warehouse , 1994 .

[13]  Mario Piattini,et al.  A UML 2.0/OCL Extension for Designing Secure Data Warehouses , 2005, J. Res. Pract. Inf. Technol..

[14]  Reda Alhajj,et al.  Data warehouse architecture and design , 2008, 2008 IEEE International Conference on Information Reuse and Integration.