Comparative analysis of the performance of selected database management system
Piotr Marcin Tracz
piotr.tracz1@pollub.edu.plLublin University of Technology (Poland)
Małgorzata Plechawska-Wójcik
Lublin University of Technology (Poland)
Abstract
Currently, in the era of large amounts of generated data, a significant challenge is fast data processing. The aim of the article is to conduct a comparative analysis of the performance of relational and non-relational databases using MS SQL Server, MongoDB, and CouchDB as examples. The comparison was carried out based on developed research scenarios designed to examine the execution time of CRUD operations. A performance ranking of databases was established based on the obtained results, with SQL Server taking the first place, MongoDB the second, and CouchDB the third. For the operations of deletion, downloading, and updating of data, MS SQL Server proved to be the most efficient database. Only in the operation of inserting data did MongoDB turn out to be the most efficient database.
Keywords:
database management system, non-relational databases, relational databases, performanceReferences
D. Chauhan, K. L. Bansal, Using the advantages of NOSQL: a case study on MongoDB, International Journal on Recent and Innovation Trends in Computing and Communication 5(2) (2017) 90–93.
Google Scholar
K. Goel, A. H. Ter Hofstede, Privacy-breaching patterns in nosql databases, IEEE Access 9 (2021) 35229–35239.
Google Scholar
A. Abdullah, Q. Zhuge, From relational databases to NoSQL databases: Performance evaluation, Research Journal of Applied Sciences, Engineering and Technology 11(4) (2015) 434–439.
Google Scholar
T. Patel, T. Eltaieb, Relational database vs NoSQL, Journal of Multidisciplinary Engineering Science and Technology (JMEST) 2(4) (2015) 691-695.
Google Scholar
C. Vicknair, M. Macias, Z. Zhao, X. Nan, Y. Chen, D. Wilkins, A comparison of a graph database and a relational database: a data provenance perspective, Proceedings of the 48th annual Southeast regional conference (2010) 1–6, https://doi.org/10.1145/1900008.1900067.
Google Scholar
Y. Li, S. Manoharan, A performance comparison of SQL and NoSQL databases, Proceedings of 2013 IEEE Pacific Rim conference on communications, computers and signal processing (PACRIM) (2013) 15–19, https://doi.org/10.1109/PACRIM.2013.6625441.
Google Scholar
J. Bhogal, I. Choksi, Handling big data using NoSQL, Proceedings of 2015 IEEE 29th International Conference on Advanced Information Networking and Applications Workshops (2015) 393–398, https://doi.org/10.1109/WAINA.2015.19.
Google Scholar
P. P. Srivastava, S. Goyal, A. Kumar, Analysis of various NoSql database, Proceedings of 2015 International Conference on Green Computing and Internet of Things (ICGCIoT) (2015) 539–544, https://doi.org/10.1109/ICGCIoT.2015.7380523.
Google Scholar
S. Sicari, A. Rizzardi, A.Coen-Porisini, Security&privacy issues and challenges in NoSQL databases, Computer Networks 206 (2022) 108828–108830.
Google Scholar
B. Jose, S. Abraham, Performance analysis of NoSQL and relational databases with MongoDB and MySQL, Materials today: Proceedings 24 (2020) 2036–2043.
Google Scholar
C. Gyorödi, R. Gyorödi, R. Sotoc, A comparative study of relational and non-relational database models in a Web-based application, International Journal of Advanced Computer Science and Applications 6(11) (2015) 78–83.
Google Scholar
K. Fraczek, M. Plechawska-Wojcik, Comparative analysis of relational and non-relational databases in the context of performance in web applications, Beyond Databases, Architectures and Structures, Proceedings of 13th International Conference Towards Efficient Solutions for Data Analysis and Knowledge Representation (2017) 153–164, https://doi.org/10.1007/978-3-319-58274-0_13.
Google Scholar
C. A. Győrödi, D. V. Dumşe-Burescu, D. R. Zmaranda, R. Ş. Győrödi, G. A. Gabor, G. D. Pecherle, Performance analysis of NoSQL and relational databases with CouchDB and MySQL for application’s data storage, Applied Sciences 10(23) (2020) 8524–8545.
Google Scholar
A. Malik, A. Burney, F. Ahmed, A comparative study of unstructured data with SQL and NO-SQL database management systems, Journal of Computer and Communications 8(4) (2020) 59–71.
Google Scholar
S. Schmid, E. Galicz, W. Reinhardt, Performance investigation of selected SQL and NoSQL databases, Proceedings of the AGILE (2015) 1–5.
Google Scholar
E. F. Codd, A relational model of data for large shared data banks, Communications of the ACM 13 (1970) 377–387.
Google Scholar
D. D. Chamberlin, Early history of SQL, IEEE Annals of the History of Computing 34 (2012) 78–82.
Google Scholar
J. R. Groff, P. N. Weinberg, A. J. Oppel, SQL: The Complete Reference Vol. 2, McGrawHill/Osborne, 2002.
Google Scholar
H. Khazaei, M. Fokaefs, S. Zareian, How do I choose the right NoSQL solution? A comprehensive theoretical and experimental survey, Big Data and Information Analytics 1(2) (2016) 185–216.
Google Scholar
V. Abramova, J. Bernardino, P. Furtado, Experimental evaluation of NoSQL databases, International Journal of Database Management Systems 6(3) (2014) 1–16.
Google Scholar
R. Arora, R. R. Aggarwal, Modeling and querying data in mongodb, International Journal of Scientific and Engineering Research 4(7) (2013) 141–144.
Google Scholar
I. Carvalho, F. Sá, J. Bernardino, Performance Evaluation of NoSQL Document Databases: Couchbase, CouchDB, and MongoDB, Algorithms 16(2) (2023) 78–95.
Google Scholar
Authors
Małgorzata Plechawska-WójcikLublin University of Technology Poland
Statistics
Abstract views: 23PDF downloads: 5
