TRANSFORMASI SKEMA BASIS DATA RELASIONAL MENJADI MODEL DATA BERORIENTASI DOKUMEN PADA MONGODB; TRANSFORMATION OF RELATIONAL DATABASE SCHEMA TO THE DOCUMENT ORIENTED DATA MODEL IN MONGODB

I GEDE WINAYA, Ahmad Ashari

2015 | Disertasi | FMIPA

MongoDB is a database that uses document-oriented data storage models. In fact, to migrate from a relational database to NoSQL databases such as MongoDB is not an easy matter especially if the data are extremely complex. Based on the documentation that has been done by several global companies related to the use of MongoDB, it can be concluded that the process of migration from RDBMS to MongoDB require quite a long time. One process that takes quite a lot is transformation of relational database schema into a document-oriented data model on MongoDB. This research discusses the development transformation system of relational database schema to the document oriented data model in MongoDB. RDBMS that is used to represent relational database in this research is MySQL. The process of transformation is done by utilizing the structure and relationships between tables in the scheme as the main parameters of the modeling algorithm. In the process of the modeling documents, it necessary to adjustments the specifications of MongoDB document such as document size limitations, the establishment identifier, incremental data handling, and data types translation. This adjustment is necessary so that any data contained in a relational database can be represented as a whole and consistent by MongoDB document models. Document models are formed from transformation process can be a single document, embedded document, or referenced document depends on the type, rules, and the cardinality value of the relationships between tables in the relational database schema. Based on the data samples, data access time of the single and embedded document model in MongoDB have better performance than the process of accessing the data on MySQL. However, the process of accessing data on the referenced document model slower than accessing data on MySQL.

Kata Kunci : N