Open Access iconOpen Access

ARTICLE

ETL Maturity Model for Data Warehouse Systems: A CMMI Compliant Framework

Musawwer Khan1, Islam Ali1, Shahzada Khurram2, Salman Naseer3, Shafiq Ahmad4, Ahmed T. Soliman4, Akber Abid Gardezi5, Muhammad Shafiq6,*, Jin-Ghoo Choi6

1 Department of Computer Science, COMSATS University Islamabad, Wah Cantt, 47000, Pakistan
2 Faculty of Computing, The Islamia University of Bahawalpur, Bahawalpur, 63100, Pakistan
3 Department of Information Technology, University of the Punjab Gujranwala Campus, Gujranwala, 52250, Pakistan
4 Industrial Engineering Department, College of Engineering, King Saud University, P.O. Box 800, Riyadh, 11421, Saudi Arabia
5 Department of Computer Science, COMSATS University Islamabad, Islamabad, 45550, Pakistan
6 Department of Information and Communication Engineering, Yeungnam University, Gyeongsan, 38541, Korea

* Corresponding Author: Muhammad Shafiq. Email: email

Computers, Materials & Continua 2023, 74(2), 3849-3863. https://doi.org/10.32604/cmc.2023.027387

Abstract

The effectiveness of the Business Intelligence (BI) system mainly depends on the quality of knowledge it produces. The decision-making process is hindered, and the user’s trust is lost, if the knowledge offered is undesired or of poor quality. A Data Warehouse (DW) is a huge collection of data gathered from many sources and an important part of any BI solution to assist management in making better decisions. The Extract, Transform, and Load (ETL) process is the backbone of a DW system, and it is responsible for moving data from source systems into the DW system. The more mature the ETL process the more reliable the DW system. In this paper, we propose the ETL Maturity Model (EMM) that assists organizations in achieving a high-quality ETL system and thereby enhancing the quality of knowledge produced. The EMM is made up of five levels of maturity i.e., Chaotic, Acceptable, Stable, Efficient and Reliable. Each level of maturity contains Key Process Areas (KPAs) that have been endorsed by industry experts and include all critical features of a good ETL system. Quality Objectives (QOs) are defined procedures that, when implemented, resulted in a high-quality ETL process. Each KPA has its own set of QOs, the execution of which meets the requirements of that KPA. Multiple brainstorming sessions with relevant industry experts helped to enhance the model. EMM was deployed in two key projects utilizing multiple case studies to supplement the validation process and support our claim. This model can assist organizations in improving their current ETL process and transforming it into a more mature ETL system. This model can also provide high-quality information to assist users in making better decisions and gaining their trust.

Keywords


Cite This Article

APA Style
Khan, M., Ali, I., Khurram, S., Naseer, S., Ahmad, S. et al. (2023). ETL maturity model for data warehouse systems: A CMMI compliant framework. Computers, Materials & Continua, 74(2), 3849-3863. https://doi.org/10.32604/cmc.2023.027387
Vancouver Style
Khan M, Ali I, Khurram S, Naseer S, Ahmad S, Soliman AT, et al. ETL maturity model for data warehouse systems: A CMMI compliant framework. Comput Mater Contin. 2023;74(2):3849-3863 https://doi.org/10.32604/cmc.2023.027387
IEEE Style
M. Khan et al., "ETL Maturity Model for Data Warehouse Systems: A CMMI Compliant Framework," Comput. Mater. Contin., vol. 74, no. 2, pp. 3849-3863. 2023. https://doi.org/10.32604/cmc.2023.027387



cc Copyright © 2023 The Author(s). Published by Tech Science Press.
This work is licensed under a Creative Commons Attribution 4.0 International License , which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
  • 1316

    View

  • 499

    Download

  • 0

    Like

Share Link