Data Warehouse for Student Information System using Star and Snowflake Schema

Abstract

Data warehouses collect information from remote sources into a single database. Data Warehouse is created for speed up queries by reducing the volume of data to be scanned. Data warehousing and on line analytical processing (OLAP) are essential elements of decision support, whic h has increasingly become a focus of the database industry . OLAP system is a methodology that support summarized report for knowledge worker (e.g. analyst, executive) in related field. And then develop OLAP tools to retrieve information from data warehouse . This paper proposes to develop a data warehouse for historical student information. It collects the data from different student data and create s a data warehouse . The purpose of this paper is intended to view the detail of historical student’s informatio n for Computer University of Magway. Finally, this paper provides not only OLAP operation by using star and snowflake schema but also compares the time that take for searching historical data by using roll up and drill down operation between star and snowf lake schema.