Design of a Data Warehouse Model for a University Decision Support System

Abstract

Data Warehouse (DW) can be a valuable asset in providing a stress-free access to data for reporting and analysis. Regrettably, building and preserving an active DW is usually associated with numerous hitches ranging from design to maintenance.  Research in the field of data warehousing has led to the emergence of vital contemporary technologies to aid design, management, and use of information systems that is capable of conveying a Decision Support System (DSS) to organizations. Nevertheless, in the face of persistent achievement and evolution of the field, abundant research is still left unturned across many diverse areas of the data warehousing. The objective of the paper therefore, is to design a DW database model for a University DSS using a dimensional modeling and techniques. A proposed DW database model with specific focus on modeling and design has been realized in this study.  The researchers have demonstrated on how a DW database model can be realized using the dimensional modeling and technique.

Keywords: Data Warehouse, Modeling, Decision Support System, Decision Making.