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

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.