Pengembangan Model Migrasi Database Relational ke NoSQL Memanfaatkan Metadata SQL

Muhammad Nur Yasir Utomo

Abstract


Penyimpanan data merupakan isu krusial pada teknologi Big Data karena membutuhkan teknologi penyimpanan data yang profisien agar dapat menyimpan data (terstruktur dan tidak terstruktur) secara cepat dalam jumlah besar. Hal ini sudah tidak bisa lagi dipenuhi oleh model database relational (SQL) yang saat ini masih banyak digunakan. Kelemahan tersebut dapat diatasi dengan menggunakan database NoSQL, namun sayangnya proses migrasi data dari relational/SQL database ke NoSQL masih sulit dilakukan karena perbendaan skema dan format penyimpanan data. Berdasarkan masalah tersebut, maka penelitian mengenai migrasi database relational ke NoSQL sangat diperlukan. Penelitian ini mencoba mengajukan pengembangan model perangkat lunak untuk migrasi database relational ke NoSQL menggunakan pendekatan aturan migrasi dan data transformasi yang memanfaatkan metadata SQL. Berdasarkan eksperimen yang telah dilakukan aturan migrasi yang diterapkan pada model yang dikembangkan berhasil melakuakn migrasi database SQL ke NoSQL dengan kecepatan rerata 0.978 detik untuk 5 table dalam 1 database.

Full Text:

PDF

References


M. N. Y. Utomo, A. E. Permanasari, E. Tungadi, and I. Syamsuddin, "Determining single tuition fee of higher education in Indonesia: A comparative analysis of data mining classification algorithms," in Proceedings of 2017 4th International Conference on New Media Studies, CONMEDIA 2017, pp. 113–117, 2017.

S. Hamouda and Z. Zainol, "Document-Oriented Data Schema for Relational Database Migration to NoSQL," in Proceedings - 2017 International Conference on Big Data Innovations and Applications, Innovate-Data 2017, 2018.

S. Ramzan, I. S. Bajwa, B. Ramzan, and W. Anwar, "Intelligent Data Engineering for Migration to NoSQL Based Secure Environments," IEEE Access, vol. 7, pp. 69042–69057, 2019.

M. N. Y. Utomo, A. Bastian, and A. Winursito, "Improving Speed Performance of Select Random Query in SQL Database," INTEK: Jurnal Penelitian, vol. 7, no. 1, pp. 26–31, 2020.

E. Tungadi, I. Thalib, and M. N. Y. Utomo, "Machine Learning Penentuan Penerima Beasiswa Peningkatan Prestasi Akademik (PPA) Menggunakan Metode Jaringan Saraf Tiruan (JST)," Seminar Nasional Hasil Penelitian & Pengabdian Kepada Masyarakat (SNP2M), pp. 391–396, 2018.

Rosdiana, E. Tungadi, Z. Saharuna, and M. N. Y. Utomo, "Analisis Sentimen pada Twitter terhadap Pelayanan Pemerintah Kota Makassar," Seminar Nasional Teknik Elektro dan Informatika, pp. 87–93, 2019.

A. El Alami and M. Bahaj, "Migration of a relational databases to NoSQL: The way forward," International Conference on Multimedia Computing and Systems, pp. 18–23, 2017.

S. Ghule and R. Vadali, "Transformation of SQL system to NoSQL system and performing data analytics using SVM," Proceedings - International Conference on Trends in Electronics and Informatics (ICEI 2017), pp. 883–887, 2018.

W. Puangsaijai and S. Puntheeranurak, "A comparative study of relational database and key-value database for big data applications," International Electrical Engineering Congress (iEECON 2017), pp. 8–10, 2017.

D. Liang, Y. Lin, and G. Ding, "Mid-model design used in model transition and data migration between relational databases and NoSQL databases," Proceedings - 2015 IEEE International Conference on Smart City / SocialCom / SustainCom (SmartCity), pp. 866–869, 2015.

G. B. Solanke and K. Rajeswari, "SQL to NoSQL transformation system using data adapter and analytics," Proceedings - 2017 IEEE International Conference on Technological Innovations in Communication, Control and Automation (TICCA), pp. 59–63, 2017.

Y. T. Liao et al., "Data adapter for querying and transformation between SQL and NoSQL database," Future Generation Computer Systems, vol. 65, pp. 111–121, 2016.

W. Ali, M. U. Shafique, M. A. Majeed, and A. Raza, "Comparison between SQL and NoSQL Databases and Their Relationship with Big Data Analytics," Asian Journal of Research in Computer Science, vol. 4, no. 2, pp. 1–10, 2019.

M. N. Y. Utomo, T. B. Adji, and I. Ardiyanto, "Prediksi Geolokasi Berbasis Teks untuk Data Media Sosial Berbahasa Indonesia Menggunakan Named Entity Extraction," Universitas Gadjah Mada, 2018.

K. Ma, B. Yang, and A. Abraham, "Asynchronous Data Translation Framework for Converting Relational Tables to Document Stores," International Journal of Computers and Applications, vol. 38, no. 1, pp. 19–28, 2016.




DOI: http://dx.doi.org/10.31963/elekterika.v17i2.2212

Refbacks

  • There are currently no refbacks.


Copyright (c) 2020 Muhammad Nur Yasir Utomo

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Publisher by:

Politeknik Negeri Ujung Pandang
Jurusan Teknik Elektro
Kampus 2 Moncongloe
Jalan Tamalanrea Raya (BTP)
Makassar 90245
E-mail: jurnal-elektrika@poliupg.ac.id

Member of :

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

ISSN 1412-8764

e-ISSN 2656-0143


free web stats Statistik Website