loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Faten Atigui ; Franck Ravat ; Ronan Tournier and Gilles Zurfluh

Affiliation: IRIT (UMR 5505), Institut de Recherche en Informatique de Toulouse and University Toulouse 1 Capitole, France

Keyword(s): Data Warehouse, Multidimensional modelling, ETL, MDA, QVT.

Related Ontology Subjects/Areas/Topics: Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems

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.

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 18.217.228.35

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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 2: ICEIS; ISBN 978-989-8425-53-9; ISSN 2184-4992, SciTePress, pages 247-252. DOI: 10.5220/0003502002470252

@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 2: ICEIS},
year={2011},
pages={247-252},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003502002470252},
isbn={978-989-8425-53-9},
issn={2184-4992},
}

TY - CONF

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