Designing Prototype Data warehouse DecisionSupport system

Abstract

A data warehouse is a “subject-oriented, integrated, time varying, non-volatile” collection of datathat aimed at enabling managers and analysts to make better and faster decisions. Properlydesigned and integrated data is crucial to enhance the internal business processing and strategicdecision making purpose. But, important data such as students, human resources, course, staff,schools or departments are recorded in an appropriate manner. As the result, managers anddecision makers of the institutions always facing challenges in order to analyze, generatesummarized report and make strategic decision in their respective level of management.The main objective of the study is to design a prototype data warehouse system which providesan integrated platform for performing analytic and decision making process from academic data(students, courses, Instructors and academic departments integrated in Repository). Dimensionalmodeling approach is selected to structure and describe the data warehouse that comprises factand dimensional tables. The proposed decision support data warehouse system is designed usingStar schema dimensional modeling technique which efficient in query performance for large datasets and efficient navigation of data in multiple dimensions for analysis. Therefore, the proposedsystem is more users interactive and query process is very fast than OLTP. It successfullyprovides summarized and multidimensional analytical information for strategic decision makers.