Design of a Multidimensional Model Using Object Oriented Features in UML
DOI:
https://doi.org/10.51611/iars.irj.v1i1.2011.6Keywords:
Data warehouse, Multidimensional modelling, Object Oriented Paradigm, Unified Modelling LanguageAbstract
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
References
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
Issue
Section
License
Copyright (c) 2011 Payal Pahwa, Shweta Taneja, Shalini Jain
This work is licensed under a Creative Commons Attribution 4.0 International License.
Author(s) hold complete right on the content of this article. Copyright to the content are governed as per Copyright Policy of the Journal.