Analisis Pengujian Database SQL dan NoSQL pada Aplikasi Berbasis Microservice dengan Spring Boot

Steven Arycena Fatich(1*), Yeremia Alfa Susetyo(2),

(1) Universitas Kristen Satya Wacana, Salatiga, Jawa Tengah, Indonesia
(2) Universitas Kristen Satya Wacana, Salatiga, Jawa Tengah, Indonesia
(*) Corresponding Author

Abstract


Efficient database utilization is essential in application development. This study aims to analyze the performance of PostgreSQL (SQL) and MongoDB (NoSQL) in CRUD operations and data aggregation using the Spring Boot framework. The research stages include developing a test application, conducting 10 simulation tests for each operation, and analyzing response times. The results indicate that MongoDB excels in create operations with an average response time of 230.4 ms and delete operations at 2.6 ms. In contrast, PostgreSQL demonstrates better efficiency in read operations and aggregations (sum, average, min, max) with superior response times

Full Text:

PDF

References


D. M. Sagala, L. Rahmadani, Y. Rahmadani, E. S. Wahyuningsih, A. Arifah Dan N. F. Lawita, “Penerapan Database Pada Perusahaan (Studi Penerapan Erp Pada Pt. Sinar Sosro),” Jurnal Pendidikan Tambusai, Vol. 5, No. 2, Pp. 1-2, 2021.

S. T. Nurhayati Dan M. I. Nasution, “Database Management System Pada Perusahaan,” Jurnal Akuntansi Keuangan Dan Bisnis, Vol. 1, No. 2, Pp. 62-64, 2023.

A. Fadli, M. I. Zulfa, A. W. W. Nugraha, A. Taryana Dan M. S. Aliim, “Analisis Perbandingan Unjuk Kerja Database Sql Dan Database Nosql Untuk Mendukung Era Big Data,” Jurnal Nasional Teknik Elektro, Vol. 9, No. 3, Pp. 155-156, 2020.

A. S. Maharani, C. F. Alifa Dan A. L. Febriga, “Perancangan Data Base Kasir Dan Persediaan Barang Menggunakan Mongodb,” Jdmsi, Vol. 3, No. 1, Pp. 32-33, 2022.

F. Zhang, G. Sun, B. Zheng Dan L. Dong, “Design And Implementation Of Energy Management System Based On Spring Boot Framework,” Information, Vol. 12, No. 457, Pp. 1-2, 2021.

W. C. U. Dagha Dan Y. A. Susetyo, “Pembangunan Aplikasi Web Event Menggunakan Framework Spring Boot Di Pt Xyz,” Jurnal Teknik Informatika Dan Sistem Informasi, Vol. 8, No. 3, Pp. 2-3, 2021.

D. Vohra, “Using Spring Data With Mongodb,” Dalam Buku "Pro Mongodb™ Development", New York, Apress, 2020, Pp. 2-3.

M. F. Abdi, A. Susanto Dan Kusnawi, “Perbandingan Kecepatan Pencarian Data Sql Dan Nosql,” Jurnal Teknologi Informasi, Vol. 5, No. 1, Pp. 2-3, 2021.

M. S. D. Pujas, M. I. Amar, M. E. Arif Dan M. M. Mustamin, “Pengukuran Kinerja Database Sql Dan Nosql Pada Aplikasi E-Commerce,” Jurnal Fokus Elektroda, Vol. 9, No. 1, Pp. 1-2, 2024.

D. Choma, K. Chwaleba Dan M. Dzieńkowski, “The Efficiency And Reliability Of Backend Technologies: Express, Django, And Spring Boot,” Iapgoś, Vol. 4, No. 4, Pp. 3-5, 2023.

T. L. Sinaga, N. Charibaldi Dan N. H. Cahyana, “Perbandingan Waktu Respon Aplikasi Database Nosql Elasticsearch Dan Mongodb Pada Pengujian Operasi Crud,” Jiska (Jurnal Informatika Sunan Kalijaga), Vol. 8, No. 1, Pp. 9-13, 2023.

S. Keshavarz, “Analyzing Performance Differences Between Mysql And Mongodb,” Technology Arts Sciences Th Köln, Koln, 2021.

A. Makris, K. Tserpes, G. Spiliopoulos, D. Zissis Dan D. Anagnostopoulos, “Mongodb Vs Postgresql: A Comparative Study On Performance Aspects,” Geoinformatica, Vol. 25, Pp. 264-265, 2020.

I. Dalström Dan P. Ericsson, “Performance Comparison Between Postgresql, Mongodb, Arangodb And Hbase,” Bachelor Degree Project In Information Technology, Pp. 19-36, 2022.

A. Vatjalainen, “Sql Versus Nosql,” Hämeen Ammatti-Korkeakoulu, Pp. 24-30, 2023.

M. Q. Porter-Brown, “Accelerating Aggregation Efficiency: Using Postgres As A Cache With Mongodb,” Bard Digital Commons, Pp. 46-48, 2021.

M. Q. Porter-Brown, “Accelerating Aggregation Efficiency: Using Postgres As A Cache With Mongodb,” Bard Digital Commons, Pp. 49-51, 2021.

L. Alves, P. Oliveira, J. Rocha, C. Wanzeller, F. Cardoso, P. Martins Dan M. Abbasi, “Comparison Of Semi-Structured Data On Mssql And Postgresql,” Marketing And Smart Technologies, Pp. 11-12, 2023.

D. Joiner, M. Clement, S. (. Chan, K. Pereira, A. Wong, Y. Khmelevsky, J. Mahony Dan M. Ferri, “Dw Vs Oltp Performance Optimization In The Cloud On Postgresql (A Case Study),” 2022 Ieee International Conference On Recent Advances In Systems Science And Engineering (Rasse), Pp. 6-7, 2022.




DOI: https://doi.org/10.30645/kesatria.v6i1.561

DOI (PDF): https://doi.org/10.30645/kesatria.v6i1.561.g556

Refbacks

  • There are currently no refbacks.


Published Papers Indexed/Abstracted By: