A UNIFIED MODEL DRIVEN METHODOLOGY FOR DATA WAREHOUSES AND ETL DESIGN

Faten Atigui, Franck Ravat, Ronan Tournier, Gilles Zurfluh

2011

Abstract

During the last few years, several frameworks have dealt with Data Warehousing (DW) design issues. Most of these frameworks provide partial answers that focus either on multidimensional (MD) modelling or on Extraction-Transformation-Loading (ETL) modelling. However, less attention has been given neither to uni-fying both modelling issues into a single structured framework nor to automating the warehousing process. To overcome these limits, this paper provides a generic unified and semi-automated method that integrates DW and ETL processes design. The framework is handled within the Model Driven Architecture (MDA). It (i) first helps the designer in modelling the decision-makers requirements and then (ii) generates the MD model as well as (ii) the logical and the physical models and finally (iv) generates the source code. In this approach, the transformation rules are formalized using the Query/View/Transformation (QVT) language.

Paper Citation

in Harvard Style

Atigui F., Ravat F., Tournier R. and Zurfluh G. (2011). A UNIFIED MODEL DRIVEN METHODOLOGY FOR DATA WAREHOUSES AND ETL DESIGN . In Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8425-53-9, pages 247-252. DOI: 10.5220/0003502002470252

in Bibtex Style

@conference{iceis11,
author={Faten Atigui and Franck Ravat and Ronan Tournier and Gilles Zurfluh},
title={A UNIFIED MODEL DRIVEN METHODOLOGY FOR DATA WAREHOUSES AND ETL DESIGN},
booktitle={Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2011},
pages={247-252},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003502002470252},
isbn={978-989-8425-53-9},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - A UNIFIED MODEL DRIVEN METHODOLOGY FOR DATA WAREHOUSES AND ETL DESIGN
SN - 978-989-8425-53-9
AU - Atigui F.
AU - Ravat F.
AU - Tournier R.
AU - Zurfluh G.
PY - 2011
SP - 247
EP - 252
DO - 10.5220/0003502002470252