{"created":"2020-09-01T13:22:38.857498+00:00","id":3716,"links":{},"metadata":{"_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":["1582963302567:1597824273898"]},"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","filename":"54026.pdf","filesize":[{"value":"824 Kb"}],"format":"application/pdf","licensetype":"license_note","mimetype":"application/pdf","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"],"publish_date":"2019-07-29","publish_status":"0","recid":"3716","relation_version_is_last":true,"title":["DATA WAREHOUSE FOR STUDENT INFORMATION SYSTEM USING STAR AND SNOWFLAKE SCHEMA"],"weko_creator_id":"1","weko_shared_id":-1},"updated":"2022-03-24T23:16:59.275485+00:00"}