Towards an MDA-oriented UML profiles for data warehouses design and development
Omar El Beggar, Khadija Letrache, Mohammed Ramdani · 2016
Nowadays, many approaches have been proposed to design and develop Data Warehouse (DW). However, there are neither standard method that addresses the design of all DW layers nor a software process prescribed for this kind of engineering domain. Generally, most of those approaches are interested in a particular aspect of DW (Storage, ETL processing, OLAP analysis, reporting, etc.) and don't cover its whole life-cycle. On the other hand, the Model Driven Architecture (MDA) is a standard approach which intended to support the whole phases of software manufacturing, by promoting the usage of models and transformations between them up to code generation. The MDA aims to automate the software engineering process, reducing thus the software development cost and improving its productivity. In this paper, we describe how to apply MDA throughout the entire development process of DW. In fact, the proposal is an MDA-oriented UML profiles. It starts by eliciting the DW requirements and then deduces the multidimensional conceptual model. The first two steps are both based on UML profiles. Afterwards, a model transformation is performed from the conceptual model to get the relational and OLAP models. At last, the SQL code and XMLA are generated for building respectively the DW and its corresponding OLAP cubes. All model transformations are performed using the transformation language ATL.