Abstract Data Warehouse (DW) applications provide past detail for judgment process for the companies. It is acknowledged that these systems depend on Multidimensional (MD) modelling different from traditional database modelling. MD modelling keeps data in the form of facts and dimensions. Some proposals have been presented to achieve the modelling of these systems, but none of them covers the MD modelling completely. There is no any approach which considers all the major components of MD systems. Some proposals provide their proprietary visual notations, which force the architects to gain knowledge of new precise model. This paper describes a framework which is in the form of an extension to Unified Modelling Language (UML). UML is worldwide known to design a variety of perspectives of software systems. Therefore, any method using the UML reduces the endeavour of designers in understanding the novel notations. Another exceptional characteristic of the UML is that it can be extended

References

[1] Abelló A. and Samos J., “YAM/Sup 2/(Yet Another Multidimensional Model): An Extension of UML,” in Proceedings of International Database Engineering and Applications Symposium, Edmonton, pp. 172-181, 2002.

[2] Amaral G. and Guizzardi G., “On the Application of Ontological Patterns for Conceptual Modellingin Multidimensional Models,” in Proceedings of European Conference on Advances in Databases and Information Systems, Bled, pp. 215-231, 2019.

[3] Azzaoui A., Rabhi O., and Mani A., “A Model Driven Architecture Approach to Generate Multidimensional Schemas of Data Warehouses,” International Journal of Online and Biomedical Engineering,vol.12, no. 12, pp. 18-31, 2019.

[4] Abdelhedi F., Brahim A., and Zurfluh G., “Formalizing the Mapping of UML Conceptual Schemas to Column-Oriented Databases,” International Journal of Data Warehousing and Mining, vol. 14, no. 3, pp. 44-68, 2018.

[5] Campeau-Lecours A., Lamontagne H., Latour S., Fauteux P., Maheu V., Boucher F., Deguire C., and L'Ecuyer L., “Kinova Modular Robot Arms for Service Robotics Applications,” International Journal of Robotics Applications and Technologies, vol. 5, no. 2, pp. 693-719, 2019.

[6] Das I., Roy S., Chatterjee A., and Sen S.,“A Data Warehouse Based Schema Design on Decision- Making in Loan Disbursement for Indian Advance Sector,” in Emerging Technologies in Data Mining and Information Security, vol. 2, pp. 603-614, 2019.

[7] Dhawan B. and Gosain A., “Extending UML for Multidimensional Modeling in Data Warehouse,” International Journal of Computer and Communication Technology, vol. 2, no. 7, pp. 59- 64, 2011.

[8] Debnath N., Garis A., Riesco D., and Montejano G., “Defining Patterns Using UML Profiles,” in Proceedings of IEEE International Conference on Computer Systems and Applications, Dubai, pp. 1147-1150, 2006.

[9] El Hayat S. and Bahaj M., “A Temporal Data Warehouse Conceptual Modelling and its Transformation into Temporal Object Relational Model,” in Proceedings of International Conference on Advanced Intelligent Systems for Sustainable Development, Marrakech, pp. 314- 323, 2018.

[10] El Moukhi N., El Azami I., Mouloudi A., and ElMounadi A., “Requirements-Based Approach for Multidimensional Design,” Procedia Computer Science, vol. 148, pp. 333-42, 2019.

[11] Fernández L. and Vallecillo A., “An Introduction to UML Profiles,” UML and Model Engineering, no. 2, pp. 6-13, 2004.

[12] Gosain A. and Mann S., “Object Oriented Multidimensional Model for a Data Warehouse with Operators,” International Journal of Database Theory and Application, vol. 3, no. 4, pp. 35-40, 2010.

[13] Kochar B. and Chhillar R., “An Effective Data Warehousing System for RFID Using Novel Data Cleaning, Data Transformation and Loading Techniques,” The International Arab Journal of Information Technology, vol. 9 no. 3, pp. 208-16, 2012.

[14] Luján-Mora S., Vassiliadis P., and Trujillo., “Data Warehouse Design with UML,” International Conference on Conceptual Modeling, Salvador, pp. 191-204, 2005.

[15] Luján-Mora S., “Multidimensional Modeling using UML and XML,” in Proceedings of 12th Workshop for PhD Students in Object-Oriented Systems, 16th European Conference on Object- Oriented Programming, Málaga, vol. 2548, pp. 48-49, 2002.

[16] Luján-Mora S., Trujillo J., and Song I., “A UML Profile for Multidimensional Modeling in Data Warehouses,” Data and Knowledge Engineering, vol. 59, no. 3, pp. 725-69, 2006.

[17] Nguyen T., Tjoa A., and Wagner R., “An Object Oriented Multidimensional Data Model for OLAP,” in Proceedings of International Conference on Web-Age Information Management, Beijing, pp. 69-82, 2000.

[18] Naiburg E. and Maksimchuck R., UML for Database Design, Addison-Wesley Professional, 2001.

[19] Platt R. and Thompson N., The Past, Present, and Future of UML, in Advanced Methodologies and Technologies in Network Architecture, Mobile Computing, and Data Analytics, IGI Global, 2019.

[20] Prat N., Akoka J., and Comyn-Wattiau I., “A UML-Based Data Warehouse Design Method,” Decision Support Systems, vol. 42, no. 3, pp. 1449-73, 2006.

[21] Prat N., Comyn-Wattiau I., and Akoka A., “Representation of Aggregation Knowledge in OLAP Systems,” in Proceedings of 18th European Conference on Information Systems, Pretoria, pp. 7-9, 2010.

[22] Specification OMG Infrastructure “Object Management Group,” Needham MA, USA 2.2 2006. An Improved Framework for Modelling Data Warehouse Systems Using UML Profile 571

[23] Schacher M., “Integrated Enterprise Modelling Based on OMG Specifications,” in Proceedings of 12th International IEEE Enterprise Distributed Object Computing Conference, Munich, 2008.

[24] Song E., Yin S., and Ray I., “Using UML to Model Relational Database Operations,” Computer Standards and Interfaces, vol. 29, no. 3, pp. 343-54, 2007.

[25] Thalheim B., Entity-Relationship Modelling: Foundations of Database Technology, Springer Science and Business Media, 2013.

[26] Trujillo J., Soler E., Fernández-Medina E., and Piattini M., “A UML 2.0 Profile to Define Security Requirements for Data Warehouses,” Computer Standards and Interfaces, vol. 31, no. 5, pp. 969-83, 2009.

[27] Theodoratos D., Ligoudistianos S., and Sellis T., View Selection for Designing the Multidimensional Structure, Data and Knowledge Engineering, pp. 219-240, 2001.

[28] Unified Modeling Language: Superstructure version 2.4.1. OMG Group. 2016.

[29] Villarroel R., Fernández-Medina E., Piattini M., Trujillo J., “A UML 2.0/OCL Extension for Designing Secure Data Warehouses,” Journal of Research and Practice in Information Technology, vol. 38, no. 1, 2006.

[30] Zubcoff J. and Trujillo J.,“A UML 2.0 Profile to Design Association Rule Mining Models in The Multidimensional Conceptual Modeling of Data Warehouses,” Data and Knowledge Engineering, vol. 63, no. 1, pp. 44-62, 2007.

[31] Zubcoff J., Pardillo J., and Trujillo J., “A UML Profile for the Conceptual Modelling of Data- Mining with Time-Series on Data Warehouses,” Information and Software Technology, vol. 51, no. 6, pp. 977-92, 2009. Muhammad Babar is currently associated with IQRA University Islamabad Campus. He received hisPh.D degree in Computer Software Engineering from National University Sciences and Technology (NUST), Islamabad, Pakistan. He did his Masters of Sciences in Computer Software Engineering from National University Sciences and Technology (NUST), Islamabad, Pakistan in 2012. He receives his Bachelors in Computer Sciences with distinction from University of Peshawar, Pakistan in 2008. His research area includes but not limited to Big Data Analytics, Internet of Things (IoT), Smart City Design and Planning, and Social Web of Things (SWOT). He has published his research work in various IEEE and ACM/Springer International conferences and journals. He is an active reviewer and guest editor in the reputed journals. Akmal Khattak received MS Computer Science degree from National University of Computer and Emerging Sciences (NU- FAST), Islamabad, Pakistan, in 2006. He got his Ph.D. in Engineering–Computer Science) from University of Leipzig, Germany, in 2014. He later joined Department of Computer Sciences, Quaid- i-Azam University, Islamabad, Pakistan, as an Assistant Professor in Sep2014. He also served as Assistant Professor in Iqra University, Islamabad from Sep 2017 to Aug 2018. Since September 2018, he has been with the Quaid-i-Azam University, Islamabad, Pakistan, as an Assistant Professor. His current research interests include information retrieval systems, natural language processing, machine learning, text mining and recommender systems. Dr. Khattak was a reviewer in NUST Journal of Engineering Sciences (NJES), Journal of the American Society for Information Science and Technology (JASIST). Fahim Arif receives his Bachelors in Telecommunication from College of Telecommunication Engineering (UET Lahore) in 1995 and Master in Sciences in Computer Software Engineering from National University Science and Technology, Islamabad in 2003. He has won NUST Endowment fund scheme scholarship for NUST in 2003 and International Research Support Initiative Program Fund from HEC in 2007. He worked as international research scholar in System and Computer Engineering Department, Carleton University, Ottawa, Canada in 2007 and participated in numerous research and academic activities. He is principal investigator (PI) for a project funded by NUST. Recently, his biography has been published by South Asian Publication Who’s Who in the World 2008 Edition and awarded with Star Laureate 2008 in recognition to his contributions to knowledge and research. Muhammad Tariq has more than 13 years’ experience in industry and academia. He earned his PhD in Management with distinction from Calsouthern USA. He holds a Bachelor’s and Master’s of Science in Computing, with a specialization in Software Engineering. His research interests include management, IoT, six sigma, knowledge management, information technology, economics, organizational change, facial recognition, biomedical devices, and computer science. Dr. Tariq has a passion for learning and development, project management, and training that made him achieve 4 patents.