Applying MDA to the development of data warehouses

  • Authors:

  • Jose-Norberto Mazon;Juan Trujillo;Manuel Serrano;Mario Piattini

  • Affiliations:

  • University of Alicante, Spain;University of Alicante, Spain;University of Castilla-La Mancha, Spain;University of Castilla-La Mancha, Spain

  • Venue:
  • Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

Different modeling approaches have been proposed to overcome every design pitfall of the development of the different parts of a data warehouse (DW) system. However, they are all partial solutions which deal with isolated aspects of the DW and do not provide designers with an integrated and standard method for designing the whole DW (ETL processes, data sources, DW repository and so on). On the other hand, the Model Driven Architecture (MDA) is a standard framework for software development that addresses the complete life cycle of designing, deploying, integrating, and managing applications by using models in software development. In this paper, we describe how to align the whole DW development process to MDA. Then, we define MD2A (MultiDimensional Model Driven Architecture), an approach for applying the MDA framework to one of the stages of the DW development: multidimensional (MD) modeling. First, we describe how to build the different MDA artifacts (i.e. models) by using extensions of the Unified Modeling Language (UML). Secondly, transformations between models are clearly and formally established by using the Query/View/Transformation (QVT) approach. Finally, an example is provided to better show how to apply MDA and its transformations to the MD modeling.