Modeling and automatic generation of data warehouse using model-driven transformation in business intelligence process

Redouane Esbai (Mohammed First University, Oujda, Morocco)
Soufiane Hakkou (Mohammed First University, Oujda, Morocco)
Mohamed Achraf Habri (Mohammed First University, Oujda, Morocco)

Indonesian Journal of Electrical Engineering and Computer Science
Vol 30, No 3: June 2023

The work presented in this paper focuses on the modeling and implementation of business intelligence processes, specifically how to apply model-driven architecture (MDA) throughout the entire development process of a data warehouse to automatically generate the multidimensional schema. As a result, this work specifies different rules for automating the process of obtaining an online analytical processing (OLAP) cube and implementing it using a collection of metamodels and automatic transformations. The data warehouse relational and OLAP cube models are then created using a model transformation from the conceptual model (class diagram). Finally, the XML file and SQL code are generated for creating the OLAP cubes and relational data warehouse, respectively. Using transformation languages like query-view-transformation (QVT) and Acceleo, all model transformations are performed.