Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe

Muhammed Kabir Ahmed; Ahmadu Bappah Muhammad; Abubakar Adamu; Aishatu Yahaya Umar

doi:doi:10.11648/j.ajmcm.20220704.12

| Peer-Reviewed

Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe

Muhammed Kabir Ahmed, Ahmadu Bappah Muhammad, Abubakar Adamu, Aishatu Yahaya Umar

Published in American Journal of Mathematical and Computer Modelling (Volume 7, Issue 4)

Received: 11 December 2022 Accepted: 4 January 2023 Published: 17 January 2023

Views: Downloads:

Download PDF

Share This Article

Twitter
Linked In
Facebook

Abstract

Universities are among the several organizations with complex activities regarding staff records, payroll, and staff promotion. This work intends to use Data warehouse as a solution to simplify these complex activities. Due to their ability to combine heterogeneous data from several information sources in a single storage location for querying and analysis, data warehousing is gaining importance in terms of strategic decision making throughout time. Data collection is a long-standing practice among organizations. Building a massive data warehouse enables them store all important and relevant information. This information is available, but very few organizations have been able to use it to make informed decisions. Due to the significant role played by the Data Warehouse (DW) and Data Mining in strategic decision making, this work developed a Data Warehouse system that can be used academic staff promotion in a University. The prototype which demonstrated the benefits of Data Warehouse and sensitizes universities in Nigeria to start binding such facilities into their staff management system for the purpose of establishing effective administrative system. The system was implemented under oracle Data Warehouse Builder and is meant to serve as a repository of data for data mining operations. The system offers high degree of accuracy in predicting the case of promotion, staff-students ratio as well as the budget projection.

Published in	American Journal of Mathematical and Computer Modelling (Volume 7, Issue 4)
DOI	10.11648/j.ajmcm.20220704.12
Page(s)	55-60
Creative Commons	This is an Open Access article, distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution and reproduction in any medium or format, provided the original work is properly cited.
Copyright	Copyright © The Author(s), 2024. Published by Science Publishing Group

Keywords

Data Warehouse, Oracle, Management System

References

[1]	Akintola, K. G., Adetunmbi, A. O., & Adeola, O. S. (2011). Building Warehouse and Data Mining from Course Management System; A Case Study of FUTA Course Management Information System. International Journal of Database Theory and Application, 13-20.
[2]	Sherenaz, A. B., Alesso, M., & Mauro, M. (2005). Anormaly Detection in Computing Network. A State of the Art Review. Journal of Wireless Mobile Network Ubiquitors Computing and Dependable Application, 29-64.
[3]	Nafeez, A. F., & Rikita, M. (2018). Design of Data Warehouse for Medical Information System Using Data Mining Techniques. 5th IEEE International Conference on Parallel Distributed and Grid Computing (PDGC) (pp. 20-22). Solan, India: Solan Computing Press.
[4]	Majid, A., Dmitriy, D., Brihat, S., Xiaoyuan, C., Jason, B., Steven, B., Ron, P. (2019). Development and Application of a High throughput Natural Language Processing Architecture to convert all Clinical Data Warehouse into Standardized Medical Vocabularies. Journal of the American Informatics Association, 1364-1369.
[5]	Jie, L., Wei, Y., Wan, Z., Xinyu, Y., Hanlin, Z., & Wei, Z. (2017). A Survey on Internet of things: Architecture, Enabling Technologies Security and Privacy and Applications. Internet of Things Journal IEEE, 1-17.
[6]	Pravin, C., & Manoj, K. G. (2018). Comprehensive Survey on Data Warehousing Research. International Journal of Technology, 217-224.
[7]	Senda, B., Ahlem, N., & Faiez, G. (2019). Design a Data Warehouse Scheme from Document Oriented Database. 23rd International Conference on Knowledge Based and Intelligent Information and Engineering Systems. Procedia Computer Science. Elsevier, Science Direct.
[8]	Azman, T., Mohamad, S. A., Suwannit, C. C., & Mohd, H. M. (2017). Data Warehouse System for Blended Learning in Institutions of Higher Education. e-academia Journal, 144-155.
[9]	Antti, L., Juha-pekka, J., Mikko, R., Tommi, M., & Timo, L. (2017). Migrating from a centralized Data Warehouse to a Decentralized Data Platform Architecture. Retrieved from http://www.solita.com
[10]	Youssef, B. (2012). A Data Warehouse Design for a Typical University Information System. Retrieved from Lebanese Association for computational Sciences: http://www.lacsc.org
[11]	Quafafou, M., Naouali, G., & Nachouki, G. (2005). Knowledge Data Warehouse: Web Usage OLAP Application. International Conference on Web Intelligence, (pp. 19-22).
[12]	Pant, S., & Hsu, C. (1995). Information Resource Management Association. International Conference, (pp. 21-24). Georgia, Atlanta.
[13]	Xingquan, Z., & Ian, D. (2007). Knowledge Discovery and Data Mining. Global Research Collection.
[14]	Singh, Y., & Chauchan, A. S. (2013). Application of Data Mining Using Artificial Neural NetworkSurvey. International Journal of Database Theory and Application.
[15]	Earlvon, F. L., John, K. J., Mark, J. K., & Pagatpat, D. D. (2018). Development of a University Financial Data Warehouse and its Visualization Tool. 3rd International Conference on Computer Science and Computational Intelligence (pp. 587-595). Elsevier, Science Direct.
[16]	Kefi, H. and Koppel, N. (2011) ‘Measuring data warehousing success: an empirical investigation applying the DeLone and McLean model’, Int. J. Data Analysis Techniques and Strategies, Vol. 3, No. 2, pp. 178–201.

Cite This Article

Plain Text BibTeX RIS

APA Style

Muhammed Kabir Ahmed, Ahmadu Bappah Muhammad, Abubakar Adamu, Aishatu Yahaya Umar. (2023). Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe. American Journal of Mathematical and Computer Modelling, 7(4), 55-60. https://doi.org/10.11648/j.ajmcm.20220704.12

Copy | Download

ACS Style

Muhammed Kabir Ahmed; Ahmadu Bappah Muhammad; Abubakar Adamu; Aishatu Yahaya Umar. Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe. Am. J. Math. Comput. Model. 2023, 7(4), 55-60. doi: 10.11648/j.ajmcm.20220704.12

Copy | Download

AMA Style

Muhammed Kabir Ahmed, Ahmadu Bappah Muhammad, Abubakar Adamu, Aishatu Yahaya Umar. Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe. Am J Math Comput Model. 2023;7(4):55-60. doi: 10.11648/j.ajmcm.20220704.12

Copy | Download

@article{10.11648/j.ajmcm.20220704.12,
  author = {Muhammed Kabir Ahmed and Ahmadu Bappah Muhammad and Abubakar Adamu and Aishatu Yahaya Umar},
  title = {Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe},
  journal = {American Journal of Mathematical and Computer Modelling},
  volume = {7},
  number = {4},
  pages = {55-60},
  doi = {10.11648/j.ajmcm.20220704.12},
  url = {https://doi.org/10.11648/j.ajmcm.20220704.12},
  eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ajmcm.20220704.12},
  abstract = {Universities are among the several organizations with complex activities regarding staff records, payroll, and staff promotion. This work intends to use Data warehouse as a solution to simplify these complex activities. Due to their ability to combine heterogeneous data from several information sources in a single storage location for querying and analysis, data warehousing is gaining importance in terms of strategic decision making throughout time. Data collection is a long-standing practice among organizations. Building a massive data warehouse enables them store all important and relevant information. This information is available, but very few organizations have been able to use it to make informed decisions. Due to the significant role played by the Data Warehouse (DW) and Data Mining in strategic decision making, this work developed a Data Warehouse system that can be used academic staff promotion in a University. The prototype which demonstrated the benefits of Data Warehouse and sensitizes universities in Nigeria to start binding such facilities into their staff management system for the purpose of establishing effective administrative system. The system was implemented under oracle Data Warehouse Builder and is meant to serve as a repository of data for data mining operations. The system offers high degree of accuracy in predicting the case of promotion, staff-students ratio as well as the budget projection.},
 year = {2023}
}

Copy | Download

TY  - JOUR
T1  - Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe
AU  - Muhammed Kabir Ahmed
AU  - Ahmadu Bappah Muhammad
AU  - Abubakar Adamu
AU  - Aishatu Yahaya Umar
Y1  - 2023/01/17
PY  - 2023
N1  - https://doi.org/10.11648/j.ajmcm.20220704.12
DO  - 10.11648/j.ajmcm.20220704.12
T2  - American Journal of Mathematical and Computer Modelling
JF  - American Journal of Mathematical and Computer Modelling
JO  - American Journal of Mathematical and Computer Modelling
SP  - 55
EP  - 60
PB  - Science Publishing Group
SN  - 2578-8280
UR  - https://doi.org/10.11648/j.ajmcm.20220704.12
AB  - Universities are among the several organizations with complex activities regarding staff records, payroll, and staff promotion. This work intends to use Data warehouse as a solution to simplify these complex activities. Due to their ability to combine heterogeneous data from several information sources in a single storage location for querying and analysis, data warehousing is gaining importance in terms of strategic decision making throughout time. Data collection is a long-standing practice among organizations. Building a massive data warehouse enables them store all important and relevant information. This information is available, but very few organizations have been able to use it to make informed decisions. Due to the significant role played by the Data Warehouse (DW) and Data Mining in strategic decision making, this work developed a Data Warehouse system that can be used academic staff promotion in a University. The prototype which demonstrated the benefits of Data Warehouse and sensitizes universities in Nigeria to start binding such facilities into their staff management system for the purpose of establishing effective administrative system. The system was implemented under oracle Data Warehouse Builder and is meant to serve as a repository of data for data mining operations. The system offers high degree of accuracy in predicting the case of promotion, staff-students ratio as well as the budget projection.
VL  - 7
IS  - 4
ER  -

Copy | Download

Author Information

Muhammed Kabir Ahmed

Department of Computer Science, Gombe State University, Gombe, Nigeria
Ahmadu Bappah Muhammad

Department of Mathematics, Gombe State University, Gombe, Nigeria
Abubakar Adamu

Department of Mathematics, Gombe State University, Gombe, Nigeria
Aishatu Yahaya Umar

Department of Computer Science, Gombe State University, Gombe, Nigeria

Download PDF

Sections

Plain Text BibTeX RIS

APA Style

Muhammed Kabir Ahmed, Ahmadu Bappah Muhammad, Abubakar Adamu, Aishatu Yahaya Umar. (2023). Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe. American Journal of Mathematical and Computer Modelling, 7(4), 55-60. https://doi.org/10.11648/j.ajmcm.20220704.12

Copy | Download

ACS Style

Muhammed Kabir Ahmed; Ahmadu Bappah Muhammad; Abubakar Adamu; Aishatu Yahaya Umar. Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe. Am. J. Math. Comput. Model. 2023, 7(4), 55-60. doi: 10.11648/j.ajmcm.20220704.12

Copy | Download

AMA Style

Muhammed Kabir Ahmed, Ahmadu Bappah Muhammad, Abubakar Adamu, Aishatu Yahaya Umar. Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe. Am J Math Comput Model. 2023;7(4):55-60. doi: 10.11648/j.ajmcm.20220704.12

Copy | Download

@article{10.11648/j.ajmcm.20220704.12,
  author = {Muhammed Kabir Ahmed and Ahmadu Bappah Muhammad and Abubakar Adamu and Aishatu Yahaya Umar},
  title = {Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe},
  journal = {American Journal of Mathematical and Computer Modelling},
  volume = {7},
  number = {4},
  pages = {55-60},
  doi = {10.11648/j.ajmcm.20220704.12},
  url = {https://doi.org/10.11648/j.ajmcm.20220704.12},
  eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ajmcm.20220704.12},
  abstract = {Universities are among the several organizations with complex activities regarding staff records, payroll, and staff promotion. This work intends to use Data warehouse as a solution to simplify these complex activities. Due to their ability to combine heterogeneous data from several information sources in a single storage location for querying and analysis, data warehousing is gaining importance in terms of strategic decision making throughout time. Data collection is a long-standing practice among organizations. Building a massive data warehouse enables them store all important and relevant information. This information is available, but very few organizations have been able to use it to make informed decisions. Due to the significant role played by the Data Warehouse (DW) and Data Mining in strategic decision making, this work developed a Data Warehouse system that can be used academic staff promotion in a University. The prototype which demonstrated the benefits of Data Warehouse and sensitizes universities in Nigeria to start binding such facilities into their staff management system for the purpose of establishing effective administrative system. The system was implemented under oracle Data Warehouse Builder and is meant to serve as a repository of data for data mining operations. The system offers high degree of accuracy in predicting the case of promotion, staff-students ratio as well as the budget projection.},
 year = {2023}
}

Copy | Download

TY  - JOUR
T1  - Building a Secured Data Warehouse for a University Staff Management System: A Case Study of Gombe State University, Gombe
AU  - Muhammed Kabir Ahmed
AU  - Ahmadu Bappah Muhammad
AU  - Abubakar Adamu
AU  - Aishatu Yahaya Umar
Y1  - 2023/01/17
PY  - 2023
N1  - https://doi.org/10.11648/j.ajmcm.20220704.12
DO  - 10.11648/j.ajmcm.20220704.12
T2  - American Journal of Mathematical and Computer Modelling
JF  - American Journal of Mathematical and Computer Modelling
JO  - American Journal of Mathematical and Computer Modelling
SP  - 55
EP  - 60
PB  - Science Publishing Group
SN  - 2578-8280
UR  - https://doi.org/10.11648/j.ajmcm.20220704.12
AB  - Universities are among the several organizations with complex activities regarding staff records, payroll, and staff promotion. This work intends to use Data warehouse as a solution to simplify these complex activities. Due to their ability to combine heterogeneous data from several information sources in a single storage location for querying and analysis, data warehousing is gaining importance in terms of strategic decision making throughout time. Data collection is a long-standing practice among organizations. Building a massive data warehouse enables them store all important and relevant information. This information is available, but very few organizations have been able to use it to make informed decisions. Due to the significant role played by the Data Warehouse (DW) and Data Mining in strategic decision making, this work developed a Data Warehouse system that can be used academic staff promotion in a University. The prototype which demonstrated the benefits of Data Warehouse and sensitizes universities in Nigeria to start binding such facilities into their staff management system for the purpose of establishing effective administrative system. The system was implemented under oracle Data Warehouse Builder and is meant to serve as a repository of data for data mining operations. The system offers high degree of accuracy in predicting the case of promotion, staff-students ratio as well as the budget projection.
VL  - 7
IS  - 4
ER  -

Copy | Download