Design of a Multidimensional Model Using Object Oriented Features in UML

Authors

  • Payal Pahwa Bhagwan Parshuram Institute of Technology, New Delhi – India
  • Shweta Taneja Delhi Technological University, New Delhi – India
  • Shalini Jain Maharaja Surajmal Institute of Technology, New Delhi, India

DOI:

https://doi.org/10.51611/iars.irj.v1i1.2011.6

Keywords:

Data warehouse, Multidimensional modelling, Object Oriented Paradigm, Unified Modelling Language

Abstract

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.

Downloads

Download data is not yet available.

Author Biography

  • Payal Pahwa, Bhagwan Parshuram Institute of Technology, New Delhi – India

    Principal,
    Bhagwan Parshuram Institute of Technology,
    New Delhi – India

References

1. Abelló A, Samos J., and. Saltor F. “A Framework for the Classification and Description of Multidimensional Data Models”. 12th Intl. Conference on Database and Expert Systems Applications (DEXA'01), pages 668_677, Munich, Germany,in September 2001.,
2. Alaskar, K. and Shaikh, A.” Object Oriented Data Modeling for Data Warehousing (An Extension of UML approach to study Hajj pilgrim’s private tour as a Case Study” Bharati Vidyapeeth University, Institute of Management Kolhapur, India IEEE in 2009.
3. Booch,G.,Rumbaugh,J.,and Jacobson,I”The Unified Modelling Language User Guide,”Addison-Wesley Longman, p.482 in 1999.
4. Golfarelli, M., Maio, D., and Rizzi, S.”The Dimensional Fact Model: A Conceptual Model for Data Warehouses.” Int. Journal of Cooperative Information Systems (IJCIS).7.(2-3): 215-247in 1998.
5. Inmon W., Hackathorn, R. “Using the data warehouse”. Wiley-QED Publishing, Somerset,NJ, USA in 1994.
6. Moody, D.L., Kortink, M.A.R. “From Enterprise Models to Dimensional Models : A Methodology for Data Warehouse and Data Mart Design”, 2nd International Workshop on Design and Management of Data Warehouses (DMDW 2000), Stockholm,Sweden in June 2000.
7. Rifaiea, M. , Kianmehrb, K. , Alhajjb, R “Data Warehouse Architecture and Design,” 978-1-4244-2660-7/08/$25.00 ©2008 IEEE
8. Sapia, C., Blaschka, M., Höfling, G., and Dinter, ”Extending the E/R Model for the Multidimensional Paradigm. “ 1st Int. Workshop on Data Warehouse and Data Mining DWDM'98).Singapore: Springer-Verlag LNCS 1998.
9. Sarkar,A.,Choudhury,S.,chaki,N.,bhattacharya S.”Conceptual Level Design of Object Oriented Data Warehouse: Graph Semantic Based Model, “ National Institute of Technology, Durgapur, West Bengal,India
10. Stefanov, V. and List, B.,” A UML Profile for Modeling Data Warehouse Usage”
11. Trujillo, J., Palomar, M., Gómez, J., and Song, I.Y. “Designing Data Warehouses with OO Conceptual Models”. IEEE Computer, special issue on Data Warehouses, (34): 66-75 in 2001.
12. Tryfona, N., Busborg, F., and Christiansen, J. “StarER: A Conceptual Model for Data Warehouse Design.” ACM 2nd Int. Workshop on Data Warehousing and OLAP DOLAP'99,. Missouri, USA
13. ”UML Modeling Language Specification. “March 2009.Version 1.3.
14. Villarroel, R., Fernandez-Medina, E., Trujillo, J., and Piattini, M.. “Towards a UML 2.0/OCL extension for Designing Secure Data Warehouses”. in 3rd. Int. Workshop on Security in Information Systems (WOSIS 2005). Miami, USA: INSTICC Press
15. Xuanzi, H. , Kuanfu ,W” Application of Data Warehouse Technology in Data Center Design” Computer Engineering Department,Dongguan City, China. International Conference on Computational Intelligence and Security.

Downloads

Published

2011-02-08

Issue

Section

Peer Reviewed Research Manuscript

How to Cite

Pahwa, P., Taneja, S. and Jain, S. (2011) “Design of a Multidimensional Model Using Object Oriented Features in UML”, IARS’ International Research Journal, 1(1). doi:10.51611/iars.irj.v1i1.2011.6.

Plaudit

Similar Articles

1-10 of 49

You may also start an advanced similarity search for this article.