The Power of a Model-Driven Approach to Handle Evolving Data Warehouse Requirements

Said Taktak, Saleh Alshomrani, Jamel Feki, Gilles Zurfluh

2017

Abstract

The Data Warehouse (DW) is characterized by complex architecture, specific modeling and design approaches. It integrates data issued from operational data sources in order to meet decision-makers’ needs by providing answers for OLAP queries (On-Line Analytical Processing). In practice, both data source models and decision-makers’ analytical requirements evolve over time and, therefore, lead to changes in the DW multidimensional model. In this evolving context, we have developed the DWE (Data Warehouse Evolution) framework. DWE automatically propagates the changes of the data source data-model on the DW data-model. This paper proposes a model-driven approach for extending DWE in order to consider a further related evolutionary aspect: The evolution of decision-makers’ needs. It deals with the propagation of these evolutions on the DW multidimensional model. This approach relies on a classification of evolution scenarios and a set of transformation rules for the identification of evolution operations to apply on the DW.

Paper Citation

in Harvard Style

Taktak S., Alshomrani S., Feki J. and Zurfluh G. (2017). The Power of a Model-Driven Approach to Handle Evolving Data Warehouse Requirements . In Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD, ISBN 978-989-758-210-3, pages 169-181. DOI: 10.5220/0006209001690181

in Bibtex Style

@conference{modelsward17,
author={Said Taktak and Saleh Alshomrani and Jamel Feki and Gilles Zurfluh},
title={The Power of a Model-Driven Approach to Handle Evolving Data Warehouse Requirements},
booktitle={Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,},
year={2017},
pages={169-181},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006209001690181},
isbn={978-989-758-210-3},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,
TI - The Power of a Model-Driven Approach to Handle Evolving Data Warehouse Requirements
SN - 978-989-758-210-3
AU - Taktak S.
AU - Alshomrani S.
AU - Feki J.
AU - Zurfluh G.
PY - 2017
SP - 169
EP - 181
DO - 10.5220/0006209001690181