QVT transformation by modelling - From UML Model to MD Model

I Arrassen,A.Meziane ,R.Sbai ,M.Erramdani

doi:10.14569/ijacsa.2011.020502

I Arrassen, A.Meziane + Show 2 more

Open Access

https://doi.org/10.14569/ijacsa.2011.020502

Copy DOI

Abstract

To provide a complete analysis of the organization, its business and its needs, it is necessary for leaders to have data that help decision making. Data warehouses are designed to meet such needs; they are an analysis and data management technology. This article describes an MDA (Model Driven Architecture) process that we have used to automatically generate the multidimensional schema of data warehouse. This process uses model transformation using several standards such as Unified Modeling Language, Meta-Object Facility, Query View Transformation, Object Constraint Language, ... From the UML model, especially the class diagram, a multidimensional model is generated as an XML file, the transformation is carried out by the QVT (Query View Transformation) language and the OCL (Object Constraint Language) Language. To validate our approach a case study is presented at the end of this work.

Highlights

To support the process of making management decisions, development of data warehouses is important for organizations
The decisional diagram will be in the form of a multidimensional schema, multidimensional modeling is the one that best represents the data warehouse schema
In [2], the authors propose a model Fact-Dimension (Dimensional-Fact Model DFM), in which they define a special notation for the conceptual model of the DWH

Summary

INTRODUCTION

To support the process of making management decisions, development of data warehouses is important for organizations. According to the definition given by Bill Inmon (1996), data warehouse is a collection of data that is subjectoriented, integrated, time-varying and non-volatile His ultimate goal is integrating data from all corners of the enterprise in a single directory, from which users can find answers to queries, generate reports and perform analysis. We use a UML class diagram summarizing the activities: requirements expression, analysis and design of information system of the organization. From this diagram, we will generate future objects decision diagram such as facts and dimensions.

RELATED WORKS

MDA ARCHITECTURE

VIII. CONCLUSION AND FUTURE WORKS