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

Authors

  • Nawfal El Moukhi MISC Laboratory, Faculty of Sciences, Ibn Tofail University, Kenitra, Morocco https://orcid.org/0000-0001-5357-9421
  • Ikram El Azami MISC Laboratory, Faculty of Sciences, Ibn Tofail University, Kenitra, Morocco
  • Abdelaaziz Mouloudi MISC Laboratory, Faculty of Sciences, Ibn Tofail University, Kenitra, Morocco
  • Abdelali Elmounadi LASTIMI, Mohammadia School of Engineers, Mohammed V University, Rabat, Morocco

DOI:

https://doi.org/10.3991/ijes.v7i1.10009

Keywords:

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

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.

Downloads

Published

2019-03-22

How to Cite

El Moukhi, N., El Azami, I., Mouloudi, A., & Elmounadi, A. (2019). X-ETL: A Data-Driven Approach for Designing Star Schemas. International Journal of Recent Contributions from Engineering, Science & IT (iJES), 7(1), pp. 4–21. https://doi.org/10.3991/ijes.v7i1.10009

Issue

Vol. 7 No. 1 (2019)

Section

Papers

License

The submitting author warrants that the submission is original and that she/he is the author of the submission together with the named co-authors; to the extend the submission incorporates text passages, figures, data or other material from the work of others, the submitting author has obtained any necessary permission.
Articles in this journal are published under the Creative Commons Attribution Licence (CC-BY What does this mean?). This is to get more legal certainty about what readers can do with published articles, and thus a wider dissemination and archiving, which in turn makes publishing with this journal more valuable for you, the authors.
By submitting an article the author grants to this journal the non-exclusive right to publish it. The author retains the copyright and the publishing rights for his article without any restrictions.
This journal has been awarded the SPARC Europe Seal for Open Access Journals (What's this?)