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.
