Query Response Time Comparison SQL and No SQL for Contact Tracing Application
Perbandingan Waktu Respons Kueri SQL dan Tanpa SQL untuk Aplikasi Pelacakan Kontak
-
(1) * Arik Bagus Setyawan
Universitas Muhammadiyah Sidoarjo
Indonesia
(2) Irwan Alnarus Kautsar Universitas Muhammadiyah Sidoarjo
Indonesia
(3) Nuril Lutvi Azizah Universitas Muhammadiyah Sidoarjo
Indonesia
(*) Corresponding Author
Abstract
During the current Covid-19 pandemic, it is necessary to have facilities to track community activities to make it easier to cope with the Covid-19 pandemic situation which is still a threat to the community. Contact tracing application (Contact Tracing) is one solution that can be used in this regard. By utilizing Contact Tracing, people's activities can be recorded when traveling to meet other people so that they can generate a history that can be used to track someone if one of them is infected with Covid-19. With this application, data storage (database) is very important because the application will generate and consume a lot of data. In this study, the researcher attempted to compare the query speed of the common data storage (database) that is usually used, namely Relational Database (MySQL) with Non-Relational Database (MongoDB). The results of the experiments conducted by the researchers resulted in the Non-Relational Database (MongoDB) suitable for use when the data has reached large amounts because the query speed is quite fast and stable. Meanwhile, Relational Database performance is still reliable when the data query needs are only on a small scale.
Downloads
References
M. Malik and T. Patel, “Database Security - Attacks and Control Methods,” Int. J. Inf. Sci. Tech., vol. 6, pp. 175–183, Mar. 2016, doi: 10.5121/ijist.2016.6218. DOI: https://doi.org/10.5121/ijist.2016.6218
F. A. Bhaswara, R. Sarno, and D. Sunaryono, “Perbandingan Kemampuan Database NoSQL dan SQL dalam Kasus ERP Retail,” J. Tek. ITS, vol. 6, no. 2, Art. no. 2, Sep. 2017, doi: 10.12962/j23373539.v6i2.24031. DOI: https://doi.org/10.12962/j23373539.v6i2.24031
S. Suryadi, “Implementasi Normalisasi Dalam Perancangan Database Relational,” U-NET J. Tek. Inform., vol. 3, no. 2, Art. no. 2, Aug. 2019, doi: 10.52332/u-net.v3i2.7. DOI: https://doi.org/10.52332/u-net.v3i2.7
K. Fraczek and M. Plechawska-Wojcik, “Comparative Analysis of Relational and Non-relational Databases in the Context of Performance in Web Applications,” in Beyond Databases, Architectures and Structures. Towards Efficient Solutions for Data Analysis and Knowledge Representation, Cham, 2017, pp. 153–164. doi: 10.1007/978-3-319-58274-0_13. DOI: https://doi.org/10.1007/978-3-319-58274-0_13
W. Schultz, T. Avitabile, and A. Cabral, “Tunable consistency in MongoDB,” Proc. VLDB Endow., vol. 12, no. 12, pp. 2071–2081, Aug. 2019, doi: 10.14778/3352063.3352125. DOI: https://doi.org/10.14778/3352063.3352125
M. M. Patil, A. Hanni, C. H. Tejeshwar, and P. Patil, “A qualitative analysis of the performance of MongoDB vs MySQL database based on insertion and retriewal operations using a web/android application to explore load balancing — Sharding in MongoDB and its advantages,” in 2017 International Conference on I-SMAC (IoT in Social, Mobile, Analytics and Cloud) (I-SMAC), Feb. 2017, pp. 325–330. doi: 10.1109/I-SMAC.2017.8058365. DOI: https://doi.org/10.1109/I-SMAC.2017.8058365
D. Damodaran B, S. Salim, and S. M. Vargese, “Performance Evaluation of MySQL and MongoDB Databases,”
Int. J. Cybern. Inform., vol. 5, no. 2, pp. 387–394, Apr. 2016, doi: 10.5121/ijci.2016.5241. DOI: https://doi.org/10.5121/ijci.2016.5241
S. Rautmare and D. M. Bhalerao, “MySQL and NoSQL database comparison for IoT application,” in 2016 IEEE International Conference on Advances in Computer Applications (ICACA), Oct. 2016, pp. 235–238. doi: 10.1109/ICACA.2016.7887957. DOI: https://doi.org/10.1109/ICACA.2016.7887957
I. K. G. Sudiartha, I. N. E. Indrayana, I. W. Suasnawa, S. A. Asri, and P. W. Sunu, “Data Structure Comparison Between MySql Relational Database and Firebase Database NoSql on Mobile Based Tourist Tracking Application,” J. Phys. Conf. Ser., vol. 1569, p. 032092, Jul. 2020, doi: 10.1088/1742-6596/1569/3/032092. DOI: https://doi.org/10.1088/1742-6596/1569/3/032092
C. R. Harris et al., “Array programming with NumPy,” Nature, vol. 585, no. 7825, Art. no. 7825, Sep. 2020, doi: 10.1038/s41586-020-2649-2. DOI: https://doi.org/10.1038/s41586-020-2649-2
P. Charbonneau, “C. RANDOM NUMBERS AND WALKS,” in C. RANDOM NUMBERS AND WALKS, Princeton University Press, 2017, pp. 321–337. doi: 10.1515/9781400885497-016. DOI: https://doi.org/10.1515/9781400885497-016
Copyright (c) 2022 Arik Bagus Setyawan, Irwan Alnarus Kautsar, Nuril Lutvi Azizah
This work is licensed under a Creative Commons Attribution 4.0 International License.
