Author:
Tracz Piotr Marcin,Plechawska-Wójcik Małgorzata
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.
Reference22 articles.
1. 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.
2. K. Goel, A. H. Ter Hofstede, Privacy-breaching patterns in nosql databases, IEEE Access 9 (2021) 35229–35239.
3. 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.
4. T. Patel, T. Eltaieb, Relational database vs NoSQL, Journal of Multidisciplinary Engineering Science and Technology (JMEST) 2(4) (2015) 691-695.
5. 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.