Analisis Performa Neo4j, Mongodb, Dan Postgresql Sebagai Database Manajemen Big Data Pemilu 2019
DOI:
https://doi.org/10.34818/eoe.v7i3.14204Abstract
Abstrak Data kini telah menjadi komoditas utama untuk suatu organisasi karena data telah mengubah cara mereka berbisnis, berkomunikasi, dan mengambil keputusan. Data yang diperoleh berupa big data. Salah satu organisasi yang menggunakan big data adalah partai politik. Mereka menggunakan big data untuk menganalisis kemungkinan menangnya kandidat mereka dalam pemilu. Namun di Indonesia penggunaannya belum bisa maksimal karena keterbatasan pada infrastrukturnya. Maka dari itu, untuk memaksimalkan penggunaan big data diperlukan sebuah manajemen penyimpanan data yang dapat menampung big data. Salah satu database tersebut adalah graph database Pada penelitian ini, penulis mengkaji tiga tools database yang sering digunakan yaitu PostgreSQL mewakili relational database, MongoDB mewakili document-based database dan Neo4J mewakili graph database. Penulis melakukan query searching yang memiliki klausa JOIN pada ketiga database. Untuk membandingkan performa antar database engine, penulis menggunakan notasi Big O yang merupakan notasi yang dipakai umum dalam menggambarkan kompleksitas suatu sistem memproses data. Kesimpulan dari penelitian ini adalah MongoDB paling bagus untuk mengelola big data pemilu. Dimana MongoDB memiliki kompleksitas O(1). Hal ini terjadi karena tipe database document based seperti MongoDB memudahkan penyimpanan dan query datanya ke dalam satu collection yang sama. Kata kunci : big data, postgresql, mongodb, neo4j, big o, performa database Abstract Data are now a major commodities for an organization because it changed their way of business, communicates and makes decisions. The data obtained is in form of big data. One type of organization that rely on big data is political party.They use it to analyze the likelihood of their candidate winning in the election. But in Indonesia, its has not been to utilized because of limited infrastructure. Therefore, to utilized the use of big data. It required a data storage management that can accommodate big data. One of these databases is graph database. In this study, the author examines three database tools that often used, namely PostgreSQL representing relational database, MongoDB representing document-based database and Neo4J representing graph database. The author performs searching query that has a JOIN clause on all three databases. To compare their performance, the author uses Big O Notation which is a notation that is commonly used in describing the complexity of a data processing system. The conclusion from this study is that MongoDB is very good for managing Big Data elections. Where MongoDB has complexity of O(1). This happens because document based database like MongoDB easy to store and query data in the same collection. Keywords: big data, postgresql, mongodb, neo4j, big o, database performanceDownloads
References
[1]C. G. Asmara, "Jokowi: Data Lebih Berharga dari Minyak," CNBC Indonesia, 16 August 2019. [Online]. Available: https://www.cnbcindonesia.com/tech/20190816112736-37-92469/jokowi-data-lebih-berharga- dari-minyak. [Accessed 11 October 2019].
[2]Iskandar, "Data Jadi Komoditas Utama di Era Digital," Liputan6, 11 September 2019. [Online]. Available: https://www.liputan6.com/tekno/read/4059254/data-jadi-komoditas-utama-di-era-digital. [Accessed 18 October 2019].
[3]Y. Permana, "Mengenal Big Data," Codepolitan, 29 May 2016. [Online]. Available: https://www.codepolitan.com/mengenal-big-data. [Accessed 2019 October 11].
[4]Y. Debora, "Big Data: Kunci Pemenangan Pilkada," tirto.id, 19 December 2017. [Online]. Available: https://tirto.id/big-data-kunci-pemenangan-pilkada-cBXY. [Accessed 11 October 2019].
[5]I. Robinson, J. Webber and E. Eifrem, Graph Databases, United States of America: O'Reilly Media, Inc, 2015.
[6]M. Sharma, V. D. Sharma and M. M. Bundele, "Performance Analysis of RDBMS and No SQL Databases
: PostgreSQL , MongoDB and Neo4j," in 2018 3rd International Conference and Workshops on Recent Advances and Innovations in Engineering (ICRAIE), Jaipur, 2018.
[7]I. N. D. Pande and R. Sarno, "Book Recommendation Using Neo4j Graph Database in BibTeX Book Metadata," in 2017 3rd International Conference on Science in Information Technology (ICSITech), Bandung, 2017.
[8]H. Lu, Z. Hong and M. Shi, "Analysis of Film Data Based on Neo4j," in 2017 IEEE/ACIS 16th International Conference on Computer and Information Science (ICIS), 2017.
[9]C. Vicknair, M. Macias, Z. Zhao, X. Nan, Y. Chen and D. Wilkins, "A Comparison of a Graph Database and a Relational Database: A Data Provenance Perspective," in Proceedings of the 48th Annual Southeast Regional Conference, Oxford, 2010.
[10]J. Hurwitz, N. Alan, F. Halper and M. Kaufman, Big Data For Dummies, Hoboken: John Wiley & Sons, Inc., 2013.
[11]B. M. Sasaki, J. Chao and R. Howard, Graph Databases For Beginners, Neo4j, 2018.
[12]"What is a Graph Database?," Neo4j, [Online]. Available: https://neo4j.com/developer/graph-database/. [Accessed 30 October 2019].
[13]"The Native Graph Database for Today’s Connected Applications," Neo4j, [Online]. Available: https://neo4j.com/neo4j-graph-database/. [Accessed 31 October 2019].
[14]R. V. Bruggen, Learning Neo4j, Birmingham: Packt Publishing, 2014.
[15]"What is MongoDB? Introduction, Architecture, Features & Example," Guru99, [Online]. Available: https://www.guru99.com/what-is-mongodb.html#1. [Accessed 29 October 2019].
[16]"Introduction to MongoDB," MongoDB, [Online]. Available: https://docs.mongodb.com/manual/introduction/#document-database. [Accessed 29 October 2019].
[17]MongoDB Architecture Guide: Overview, MongoDB, 2019.
[18]"About," PostgreSQL, [Online]. Available: https://www.postgresql.org/about/. [Accessed 30 October 2019].
[19]"Lindungi Hak Pilihmu," Komisi Pemilihan Umum, [Online]. Available: https://lindungihakpilihmu.kpu.go.id/. [Accessed 28 Februari 2020].
[20]K. Sahatqija, J. Ajdari, X. Zenuni, B. Raufi and F. Ismaili, "Comparison between relational and NOSQL databases," in 41st International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO), Opatija, 2018.
[21]S. Huang, "What is Big O Notation Explained: Space and Time Complexity," freeCodeCamp, 16 Januari 2020. [Online]. Available: https://www.freecodecamp.org/news/big-o-notation-why-it-matters-and-why-it- doesnt-1674cfa8a23c/. [Accessed 22 Juni 2020].
[22]S. Debnath, "Analysis of Algorithms | Big-O analysis," GeeksforGeeks, [Online]. Available: https://www.geeksforgeeks.org/analysis-algorithms-big-o-analysis/. [Accessed 27 June 2020].
[23]D. Newton, "Learning Big O Notation With O(n) Complexity," DZone, 25 April 2017. [Online]. Available: https://dzone.com/articles/learning-big-o-notation-with-on-complexity. [Accessed 7 Juli 2020].



