X-ETL: A Data-Driven Approach for Designing Star Schemas

Nawfal El Moukhi, Ikram El Azami, Abdelaaziz Mouloudi, Abdelali Elmounadi

Abstract


The data warehouse design is currently recognized as the most important and complicated phase in any project of decision support system implementation. Its complexity is primarily due to the proliferation of data source types and the lack of a standardized and well-structured method, hence the increasing interest from researchers who have tried to develop new methods for the automation and standardization of this critical stage of the project. In this paper, the authors present the set of developed methods that follows the data-driven paradigm, and they propose a new data-driven method called X-ETL. This method aims to automating the data warehouse design by generating star models from relational data. This method is mainly based on a set of rules derived from the related works, the Model-Driven Architecture (MDA) and the XML language.

Keywords


Data warehouse; Relational model; Multidimensional model; Design of data warehouses; MDA

Full Text:

PDF



International Journal of Recent Contributions from Engineering, Science & IT (iJES) – eISSN: 2197-8581
Creative Commons License
Indexing:
DOAJ logo DBLP logo MAS logo