An Improved Data Warehouse Architecture for SPGS, MAUTECH, Yola, Nigeria

Abstract

Data warehousing is a very important contemporary technology that is useful in decision making, relating it to software development, the data warehousing technology is indeed a very new discipline and does not until now offer well established approaches and procedures for the development process in the educational sector. In this paper, we have considered using SPGS MAUTECH, Yola as our case study and present the design of a proposed data warehousing architecture within the context of the University atmosphere, to better incorporate systems for simpler and improved data analysis, reporting and querying activities. We have considered the ideologies of data warehousing in the course of this study and demonstrated how data can be incorporated from diverse heterogeneous source systems into a sole historical repository that is capable of supporting Decision Support System (DSS) for University administrators and other end users.. University data management can step up towards adopting and implementing this proposed architecture.

Keywords: Data Warehouse, Architecture, DSS, Decision Making