Query Response Time Comparison SQL and No SQL for Contact Tracing Application Perbandingan Waktu Respons Kueri SQL dan Tanpa SQL untuk Aplikasi Pelacakan Kontak
Article Sidebar
Main Article Content
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
Article Details
This work is licensed under a Creative Commons Attribution 4.0 International License.
References
[2] 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.
[3] 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.
[4] 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.
[5] 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.
[6] 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.
[7] 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.
[8] 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.
[9] 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.
[10] 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.
[11] 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.