Comparative Analysis of Performance of Open Source Databases in Web Application Development
Authors: D. Savić, S. Vučetić, P. Milić
Keywords: database, SQL, NoSQL, performance, web application
Abstract:
One of the dilemmas faced by developers of Web application is whether to use SQL or NoSQL database with the unavoidable fact that application must have a quick response. Often these applications work with large amounts of data. This paper presents a comparative analysis of performance of open source SQL and NoSQL databases used in web application development. We tested behavior of different open source SQL and NoSQL databases by different parameters and give some conclusions about suitability of their application in different cases.
References:
[1] W. KHAN, T. KUMAR, C. ZHANG, K. RAJ, A. M. ROY, B. LUO, SQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review, Big Data and Cognitive Computing. Vol. 7, 2 (2023), 97–102.
[2] A. D. PRABA, M. SAFITRI, Studi perbandingan performansi antara mysql dan postgresql, Jurnal Khatulistiwa Informatika. Vol. 8, 2 (2020), 88–93.
[3] R. POLJAK, P. POŠČIĆ, D. JAKŠIĆ, Comparative analysis of the selected relational database management systems, In: Proceedings of a Conference on Information and Communication Technology, Electronics and Microelectronics (P. Biljanovic, eds.), Opatia, Croatia, 2017, pp. 1496–1500.
[4] A. MEIER, M. KAUFMANN, SQL & NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management, Springer, New York, 2019.
[5] N. D. BHARDWAJ, Comparative study of couchdb and mongodb–nosql document oriented databases, International Journal of Computer Applications. Vol. 136, 3 (2016), 24–26.
[6] R. KUMBHARE, S. NIMBALKAR, S. CHOPADE, V. K. PACHGHARE, Tamper detection in MongoDB and CouchDB database, In: Proceedings of a Conference on Computational Science and Applications: ICCSA 2019 (O. Gervasi, eds.), Thuy Loi University, Hanoi, 2019, pp. 109–117.
[7] B. MILOŠEVIĆ, S. JOVKOVIĆ, L. PETKOVICĆ, D. KRSTIĆ, S. OBRADOVIĆ, Results of comparison between open source and commercial methods of organizing databases, In: Proceedings of a INFOTEH conference (S. Lubura, eds.), Jahorina, Pale, 2012, pp. 643–648.
[8] N. ALAN HECKERT, J. J. FILLIBEN, C. M. CROARKIN, B. HEMBREE, W. F. GUTHRIE, P. TOBIAS, J. PRINZ, e-Handbook of statistical methods, NIST, Washington, 2002.
[9] L. YISH, S. MANOHARAN, Performance comparison of SQL and NoSQL databases, In: Proceedings of Pacific Rim Conference on Communications (M. McGuire, eds.), Victoria BC, Canada, 2013, pp. 15–19.
[10] L. BONNET, A. LAURENT, M. SALA, B. LAURENT, N. SICARD, Reduce, you say: What NoSQL can do for data aggregation and BI in large repositories., In: Proceedings on Database and Expert Systems Applications Conference (M. A. Hady, eds.), Toulouse, 2011, pp. 483–488.