{"created":"2020-11-19T15:06:17.304368+00:00","id":6265,"links":{},"metadata":{"_buckets":{"deposit":"a994ec7b-07f8-4d2b-971d-8cec6e51aa96"},"_deposit":{"created_by":45,"id":"6265","owner":"45","owners":[45],"owners_ext":{"displayname":"","email":"dimennyaung@uit.edu.mm","username":""},"pid":{"revision_id":0,"type":"recid","value":"6265"},"status":"published"},"_oai":{"id":"oai:meral.edu.mm:recid/6265","sets":["1582963342780:1605779935331"]},"communities":["uit"],"item_1583103067471":{"attribute_name":"Title","attribute_value_mlt":[{"subitem_1551255647225":"Uniformly Integrated Database Approach for Heterogenous Databases","subitem_1551255648112":"en"}]},"item_1583103085720":{"attribute_name":"Description","attribute_value_mlt":[{"interim":"The demands of more storage, scalability, commodity of heterogenous data for storing, analyzing and retrieving data are rapidly increasing in today data-centric area such as cloud computing, big data analytics, etc. These demands cannot be solely handled by relational database system (RDBMS) due to its strict relational model for scalability and adaptability. Therefore, NoSQL (Not only SQL) database called non-relational database is recently introduced to extend RDBMS, and now it is widely used in some software developments. As a result, it becomes challenges regarding how to transform relational to non-relational database or how to integrate them to achieve business purposes regarding storage and adaptability. This paper therefore proposes an approach for uniformly integrated database to integrate data separately extracted from individual database schema from relational and NoSQL database systems. We firstly try to map the data elements in terms of their semantic meaning and structures with the help of ontological semantic mapping and metamodeling from the extracted data. We then cover structural, semantical and syntactical diversity of each database schema and produce integrated database results. To prove efficiency and usefulness of our proposed system, we test our developed system with popular datasets in BSON and traditional sql format using MongoDB and MySQL database. According to the results compared with other proficient contemporary approaches, we have achieved significant results in mapping similarity results although running time and retrieval time are competitive with the others."}]},"item_1583103108160":{"attribute_name":"Keywords","attribute_value_mlt":[{"interim":"Relational database"},{"interim":"NoSQL database"},{"interim":"ontological semantic mapping"},{"interim":"database schema"}]},"item_1583103120197":{"attribute_name":"Files","attribute_type":"file","attribute_value_mlt":[{"accessrole":"open_access","date":[{"dateType":"Available","dateValue":"2020-11-19"}],"displaytype":"preview","filename":"Uniformly Integrated Database Approach for Heterogenous Databases.pdf","filesize":[{"value":"1.5 Mb"}],"format":"application/pdf","license_note":"© 2017 ICAIT","licensetype":"license_note","url":{"url":"https://meral.edu.mm/record/6265/files/Uniformly Integrated Database Approach for Heterogenous Databases.pdf"},"version_id":"d3145ae2-b296-4aa3-b6fa-849bf8d87cfc"}]},"item_1583103147082":{"attribute_name":"Conference papers","attribute_value_mlt":[{"subitem_acronym":"ICAIT-2017","subitem_c_date":"1-2 November, 2017","subitem_conference_title":"1st International Conference on Advanced Information Technologies","subitem_place":"Yangon, Myanmar","subitem_session":"Data Science","subitem_website":"https://www.uit.edu.mm/icait-2017/"}]},"item_1583105942107":{"attribute_name":"Authors","attribute_value_mlt":[{"subitem_authors":[{"subitem_authors_fullname":"Hlaing Phyu Phyu Mon"},{"subitem_authors_fullname":"Thin Thin San"},{"subitem_authors_fullname":"Zinmar Naing"},{"subitem_authors_fullname":"Thandar Swe"}]}]},"item_1583108359239":{"attribute_name":"Upload type","attribute_value_mlt":[{"interim":"Publication"}]},"item_1583108428133":{"attribute_name":"Publication type","attribute_value_mlt":[{"interim":"Conference paper"}]},"item_1583159729339":{"attribute_name":"Publication date","attribute_value":"2017-11-02"},"item_title":"Uniformly Integrated Database Approach for Heterogenous Databases","item_type_id":"21","owner":"45","path":["1605779935331"],"publish_date":"2020-11-19","publish_status":"0","recid":"6265","relation_version_is_last":true,"title":["Uniformly Integrated Database Approach for Heterogenous Databases"],"weko_creator_id":"45","weko_shared_id":-1},"updated":"2021-12-13T00:39:12.990213+00:00"}