An MDA Approach for the Evolution of Data Warehouses

An MDA Approach for the Evolution of Data Warehouses

Said Taktak (MIRACL Laboratory, University of Sfax, Sfax, Tunisia), Saleh Alshomrani (Faculty of Computing and Information Technology, University of Jeddah, Jeddah, Saudi Arabia), Jamel Feki (MIRACL Laboratory, University of Sfax, Sfax, Tunisia) and Gilles Zurfluh (Institut de Recherche en Informatique de Toulouse (IRIT), Université Toulouse I Capitole, Toulouse, France)
Copyright: © 2015 |Pages: 25
DOI: 10.4018/ijdsst.2015070104
OnDemand PDF Download:
$30.00
List Price: $37.50

Abstract

Modeling and data warehousing have been considered, for more than one decade, as a new challenging research topic for which different approaches have been proposed. Nevertheless these proposals have focused on static aspects only. In practice, the evolution of the operational information system can lead to changes in its dependent multidimensional data warehouse (i.e. that this system feeds with data), and therefore may require the evolution of the data warehouse model. In this evolving context, the authors propose a model-driven based approach in order to automate the propagation of the evolutions occurred in the source database towards the multidimensional data warehouse. This approach is based on two evolution models, along with a set of transformation rules formalized in Query/View/Transformation. This paper describes this evolution approach for which we are developing a software prototype called DWE© (Data Warehouse Evolution).
Article Preview

The DW evolution problem has been the main topic of several research studies. It was treated from different viewpoints which we can classify as follows: (i) The evolution of multidimensional model, (ii) The maintenance of materialized views, and (iii) The adaptation of the ETL process. We review these works in order to indicate our own position as compared to their contributions and then, we focus on how to propagate the evolution of the DS model towards the DW model.

Complete Article List

Search this Journal:
Reset
Open Access Articles: Forthcoming
Volume 10: 4 Issues (2018): 1 Released, 3 Forthcoming
Volume 9: 4 Issues (2017)
Volume 8: 4 Issues (2016)
Volume 7: 4 Issues (2015)
Volume 6: 4 Issues (2014)
Volume 5: 4 Issues (2013)
Volume 4: 4 Issues (2012)
Volume 3: 4 Issues (2011)
Volume 2: 4 Issues (2010)
Volume 1: 4 Issues (2009)
View Complete Journal Contents Listing