A Model Driven Architecture Approach to Generate Multidimensional Schemas of Data Warehouses

Authors

  • Amine Azzaoui MATSI Laboratory, EST, Mohamed First University, Oujda.
  • Ouzayr Rabhi MATSI Laboratory, EST, Mohamed First University, Oujda.
  • Ayyoub Mani MATSI Laboratory, EST, Mohamed First University, Oujda.

DOI:

https://doi.org/10.3991/ijoe.v15i12.10720

Keywords:

Data Warehouse, Meta model, Model Driven Architecture, Transformation, UML

Abstract


Over the past decade, the concept of data warehousing has been widely accepted. The main reason for building data warehouses is to improve the quality of information in order to achieve specific business objectives such as competitive advantage or improved decision-making. However, there is no formal method for deriving a multidimensional schema from heterogeneous databases that is recognized as a standard by the OMG and the professionals of the field. Which is why, in this paper, we present a model-driven approach (MDA) for the design of data warehouses. To apply the MDA approach to the Data warehouse construction process, we describe a multidimensional meta-model and specify a set of transformations from a UML meta-model which is mapped to a multidimensional meta-model. The transformation rules are programmed by the Query View Transformation (QVT) language. A case study illustrates our approach. It demonstrates how it reinforces the components traceability and reusability and how it globally improves the modeler’s efficiency. Furthermore, the use of the UML, as a technique to build data warehouses, is an important facilitator which prepares our further work to automate this approach.

Author Biographies

Amine Azzaoui, MATSI Laboratory, EST, Mohamed First University, Oujda.

A Ph.D student from Mohamed First University, Oujda, Morocco. He is graduated with a computer engineering degree from ENSMR (Rabat Superior National School of Mines) in 2016.

His research interests include Business Process Management (BPM) and MDA models for the end-to-end design of organizations strategic and operational dashboards.

Ouzayr Rabhi, MATSI Laboratory, EST, Mohamed First University, Oujda.

A Ph.D. student from Mohamed First University in Oujda, Morocco.

He holds a Master's degree in Computer Engineering from Oujda Faculty of Science

His research focuses on the management of public organization and MDA models for the end-to-end design of strategic organizations and dashboards of  public organization.

Ayyoub Mani, MATSI Laboratory, EST, Mohamed First University, Oujda.

A computer engineer. Graduated on 2017 from the National School of Applied Sciences Oujda Morocco.

 He is now preparing a PhD in Model driven architecture.

Downloads

Published

2019-08-23

How to Cite

Azzaoui, A., Rabhi, O., & Mani, A. (2019). A Model Driven Architecture Approach to Generate Multidimensional Schemas of Data Warehouses. International Journal of Online and Biomedical Engineering (iJOE), 15(12), pp. 18–31. https://doi.org/10.3991/ijoe.v15i12.10720

Issue

Section

Papers