UCSY's Research Repository

DATA WAREHOUSE FOR STUDENT INFORMATION SYSTEM USING STAR AND SNOWFLAKE SCHEMA

Show simple item record

dc.contributor.author Aung, Han Su
dc.contributor.author Latt, Yin Ko
dc.date.accessioned 2019-07-29T07:08:11Z
dc.date.available 2019-07-29T07:08:11Z
dc.date.issued 2009-12-30
dc.identifier.uri http://onlineresource.ucsy.edu.mm/handle/123456789/1453
dc.description.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. en_US
dc.language.iso en en_US
dc.publisher Fourth Local Conference on Parallel and Soft Computing en_US
dc.subject Data warehouse and OLAP en_US
dc.subject Star Schema and Snowflake Schema en_US
dc.title DATA WAREHOUSE FOR STUDENT INFORMATION SYSTEM USING STAR AND SNOWFLAKE SCHEMA en_US
dc.type Article en_US


Files in this item

This item appears in the following Collection(s)

Show simple item record

Search Repository



Browse

My Account