-
RootNode
-
Co-operative College, Mandalay
-
Cooperative College, Phaunggyi
-
Co-operative University, Sagaing
-
Co-operative University, Thanlyin
-
Dagon University
-
Kyaukse University
-
Laquarware Technological college
-
Mandalay Technological University
-
Mandalay University of Distance Education
-
Mandalay University of Foreign Languages
-
Maubin University
-
Mawlamyine University
-
Meiktila University
-
Mohnyin University
-
Myanmar Institute of Information Technology
-
Myanmar Maritime University
-
National Management Degree College
-
Naypyitaw State Academy
-
Pathein University
-
Sagaing University
-
Sagaing University of Education
-
Taunggyi University
-
Technological University, Hmawbi
-
Technological University (Kyaukse)
-
Technological University Mandalay
-
University of Computer Studies, Mandalay
-
University of Computer Studies Maubin
-
University of Computer Studies, Meikhtila
-
University of Computer Studies Pathein
-
University of Computer Studies, Taungoo
-
University of Computer Studies, Yangon
-
University of Dental Medicine Mandalay
-
University of Dental Medicine, Yangon
-
University of Information Technology
-
University of Mandalay
-
University of Medicine 1
-
University of Medicine 2
-
University of Medicine Mandalay
-
University of Myitkyina
-
University of Public Health, Yangon
-
University of Veterinary Science
-
University of Yangon
-
West Yangon University
-
Yadanabon University
-
Yangon Technological University
-
Yangon University of Distance Education
-
Yangon University of Economics
-
Yangon University of Education
-
Yangon University of Foreign Languages
-
Yezin Agricultural University
-
New Index
-
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 |