MERAL Myanmar Education Research and Learning Portal
Item
{"_buckets": {"deposit": "fbbbca12-5e75-4b2e-bee0-9b0408c2f354"}, "_deposit": {"id": "3716", "owners": [], "pid": {"revision_id": 0, "type": "recid", "value": "3716"}, "status": "published"}, "_oai": {"id": "oai:meral.edu.mm:recid/3716", "sets": ["1597824273898", "user-ucsy"]}, "communities": ["ucsy"], "item_1583103067471": {"attribute_name": "Title", "attribute_value_mlt": [{"subitem_1551255647225": "DATA WAREHOUSE FOR STUDENT INFORMATION SYSTEM USING STAR AND SNOWFLAKE SCHEMA", "subitem_1551255648112": "en"}]}, "item_1583103085720": {"attribute_name": "Description", "attribute_value_mlt": [{"interim": "Data warehouses collectinformation from remotesources into a single database. Data Warehouse iscreated for speed up queries by reducing the volumeof data to be scanned. Data warehousing and on lineanalytical processing (OLAP) are essential elementsof decision support, whic h has increasingly become afocus of the database industry . OLAP system is amethodology that support summarized report forknowledge worker (e.g. analyst, executive) in relatedfield. And then develop OLAP tools to retrieveinformation from data warehouse . This paperproposes to develop a data warehouse for historicalstudent information. It collects the data from differentstudent data and create s a data warehouse . Thepurpose of this paper is intended to view the detail ofhistorical student’s informatio n for ComputerUniversity of Magway. Finally, this paper providesnot only OLAP operation by using star and snowflakeschema but also compares the time that take forsearching historical data by using roll up and drilldown operation between star and snowf lake schema."}]}, "item_1583103108160": {"attribute_name": "Keywords", "attribute_value_mlt": [{"interim": "Data warehouse and OLAP"}, {"interim": "Star Schema and Snowflake Schema"}]}, "item_1583103120197": {"attribute_name": "Files", "attribute_type": "file", "attribute_value_mlt": [{"accessrole": "open_access", "date": [{"dateType": "Available", "dateValue": "2019-07-29"}], "displaytype": "preview", "download_preview_message": "", "file_order": 0, "filename": "54026.pdf", "filesize": [{"value": "824 Kb"}], "format": "application/pdf", "future_date_message": "", "is_thumbnail": false, "licensetype": "license_free", "mimetype": "application/pdf", "size": 824000.0, "url": {"url": "https://meral.edu.mm/record/3716/files/54026.pdf"}, "version_id": "8e6885bd-e9c3-498d-9d40-0d93a8218bcc"}]}, "item_1583103131163": {"attribute_name": "Journal articles", "attribute_value_mlt": [{"subitem_issue": "", "subitem_journal_title": "Fourth Local Conference on Parallel and Soft Computing", "subitem_pages": "", "subitem_volume": ""}]}, "item_1583103147082": {"attribute_name": "Conference papers", "attribute_value_mlt": [{"subitem_acronym": "", "subitem_c_date": "", "subitem_conference_title": "", "subitem_part": "", "subitem_place": "", "subitem_session": "", "subitem_website": ""}]}, "item_1583103211336": {"attribute_name": "Books/reports/chapters", "attribute_value_mlt": [{"subitem_book_title": "", "subitem_isbn": "", "subitem_pages": "", "subitem_place": "", "subitem_publisher": ""}]}, "item_1583103233624": {"attribute_name": "Thesis/dissertations", "attribute_value_mlt": [{"subitem_awarding_university": "", "subitem_supervisor(s)": [{"subitem_supervisor": ""}]}]}, "item_1583105942107": {"attribute_name": "Authors", "attribute_value_mlt": [{"subitem_authors": [{"subitem_authors_fullname": "Aung, Han Su"}, {"subitem_authors_fullname": "Latt, Yin Ko"}]}]}, "item_1583108359239": {"attribute_name": "Upload type", "attribute_value_mlt": [{"interim": "Publication"}]}, "item_1583108428133": {"attribute_name": "Publication type", "attribute_value_mlt": [{"interim": "Article"}]}, "item_1583159729339": {"attribute_name": "Publication date", "attribute_value": "2009-12-30"}, "item_1583159847033": {"attribute_name": "Identifier", "attribute_value": "http://onlineresource.ucsy.edu.mm/handle/123456789/1453"}, "item_title": "DATA WAREHOUSE FOR STUDENT INFORMATION SYSTEM USING STAR AND SNOWFLAKE SCHEMA", "item_type_id": "21", "owner": "1", "path": ["1597824273898"], "permalink_uri": "http://hdl.handle.net/20.500.12678/0000003716", "pubdate": {"attribute_name": "Deposited date", "attribute_value": "2019-07-29"}, "publish_date": "2019-07-29", "publish_status": "0", "recid": "3716", "relation": {}, "relation_version_is_last": true, "title": ["DATA WAREHOUSE FOR STUDENT INFORMATION SYSTEM USING STAR AND SNOWFLAKE SCHEMA"], "weko_shared_id": -1}
DATA WAREHOUSE FOR STUDENT INFORMATION SYSTEM USING STAR AND SNOWFLAKE SCHEMA
http://hdl.handle.net/20.500.12678/0000003716
http://hdl.handle.net/20.500.12678/00000037161ff96878-fca6-487d-9b94-21d484264126
fbbbca12-5e75-4b2e-bee0-9b0408c2f354
Name / File | License | Actions |
---|---|---|
![]() |
|
Publication type | ||||||
---|---|---|---|---|---|---|
Article | ||||||
Upload type | ||||||
Publication | ||||||
Title | ||||||
Title | DATA WAREHOUSE FOR STUDENT INFORMATION SYSTEM USING STAR AND SNOWFLAKE SCHEMA | |||||
Language | en | |||||
Publication date | 2009-12-30 | |||||
Authors | ||||||
Aung, Han Su | ||||||
Latt, Yin Ko | ||||||
Description | ||||||
Data warehouses collectinformation from remotesources into a single database. Data Warehouse iscreated for speed up queries by reducing the volumeof data to be scanned. Data warehousing and on lineanalytical processing (OLAP) are essential elementsof decision support, whic h has increasingly become afocus of the database industry . OLAP system is amethodology that support summarized report forknowledge worker (e.g. analyst, executive) in relatedfield. And then develop OLAP tools to retrieveinformation from data warehouse . This paperproposes to develop a data warehouse for historicalstudent information. It collects the data from differentstudent data and create s a data warehouse . Thepurpose of this paper is intended to view the detail ofhistorical student’s informatio n for ComputerUniversity of Magway. Finally, this paper providesnot only OLAP operation by using star and snowflakeschema but also compares the time that take forsearching historical data by using roll up and drilldown operation between star and snowf lake schema. | ||||||
Keywords | ||||||
Data warehouse and OLAP, Star Schema and Snowflake Schema | ||||||
Identifier | http://onlineresource.ucsy.edu.mm/handle/123456789/1453 | |||||
Journal articles | ||||||
Fourth Local Conference on Parallel and Soft Computing | ||||||
Conference papers | ||||||
Books/reports/chapters | ||||||
Thesis/dissertations |