Design and Implementation of a Data Warehouse for Managing an ‎Educational Institution

Abstract

Developing the work ‎mechanism in ‎educational ‎institutions is one of ‎the most important ‎factors that affect ‎the quality of ‎education and its ‎outcomes. The ‎effective work ‎mechanism ‎contributes to ‎improving efficiency ‎and productivity. In ‎this work, the ‎database stored in ‎‎(The representative ‎of the Iraqi Ministry ‎of Education in Erbil ‎‎/ Specialist ‎Supervision Unit) is ‎transformed into a ‎system for managing ‎the data warehouse ‎of the educational ‎institution by ‎exploiting the ‎database available in ‎the institution and ‎linking this data. By ‎identifying the ‎necessary presences ‎in this system and ‎representing the ‎relationships ‎between the ‎presences to ‎facilitate the process ‎of extracting, ‎converting, and ‎uploading this data ‎to the system ‎designed for the ‎purpose of taking ‎advantage of modern ‎technology to ‎support the decision ‎maker in this ‎educational ‎institution. The ‎proposed system ‎helps the ‎institution’s director ‎quickly access and ‎review historical ‎data on a specific ‎subject and analyze ‎it for the purpose of ‎making strategic ‎decisions related to ‎the educational ‎process according to ‎the available ‎information ‎accurately and ‎without fatigue or ‎boredom.‎

Country : Iraq

1 Qaddo M. Noori Alhayaly2 Rayan Yousif Alkhayat

  1. Representative of the Iraqi Ministry of Education in Erbil, Iraq & Department of Computer Science, College of Computer Sciences and Mathematics, University of Mosul, Mosul – Iraq
  2. Department of Computer Science, College of Computer Sciences and Mathematics, University of Mosul, Mosul – Iraq

IRJIET, Volume 8, Issue 3, March 2024 pp. 36-41

doi.org/10.47001/IRJIET/2024.803005

References

  1. Yu, X. The Application of Data Warehouse in Teaching Management in Colleges and ‎Universities. in Journal of Physics: Conference Series. 2021. IOP Publishing.‎
  2. ‎Vaisman, A. and E. Zimányi, Data warehouse systems. Data-Centric Systems and ‎Applications, 2014.‎
  3. ‎Farooqui, N.A. and R. Mehra. Design of a data warehouse for medical information ‎system using data mining techniques. in 2018 Fifth International Conference on ‎Parallel, Distributed and Grid Computing (PDGC). 2018. IEEE.‎
  4. ‎Moscoso-Zea, O., J. Paredes-Gualtor, and S. Luján-Mora, A holistic view of data ‎warehousing in education. IEEE access, 2018. 6: p. 64659-64673.‎
  5. ‎Suman, S., P. Khajuria, and S. Urolagin. Star schema-based data warehouse model for ‎education system using Mondrian and Pentaho. in International conference on ‎Modelling, Simulation and Intelligent Computing. 2020. Springer.‎
  6. Mubarak, Dr. B. M., & Al-Zubaidi, M. A. a. (2009). Educational and specialist supervision in Iraq: reality and prospects. DIRASAT TARBAWIYA, 2(5).
  7. ‎Chandra, P. and M.K. Gupta, Comprehensive survey on data warehousing research. International ‎Journal of Information Technology, 2018. 10: p. 217-224.‎
  8. CHINYERE, J.O., DATA WAREHOUSE: A TOOL FOR ORGANIZATIONAL EFFICIENCY. Nigerian ‎Journal Of Management Sciences Vol, 2022. 23(2).‎
  9. Chatzistefanou, D., Data Warehousing in Business Intelligence and ETL Processes. 2023.‎
  10. ‎Jagadeesh, K., Business Intelligence Tools for Process Optimization in a Public Electricity ‎Company. 2020.‎
  11. https://www.hechtgroup.com/the-future-of-data-‎warehouses-are-they-obsolete/‎.