Comparative analysis of the performance of selected database management  system

Piotr Marcin Tracz; Małgorzata Plechawska-Wójcik

doi:10.35784/jcsi.5927

Open full text

PDF

Published: Jun 30, 2024

DOI: https://doi.org/10.35784/jcsi.5927

Issue Vol. 31 (2024)

Articles

Comparative analysis of the implementation performance using selected scripting languages in the Godot game engine
Sebastian Alchimowicz, Małgorzata Plechawska-Wójcik

68-72
Comparative analysis of smart home management systems
Patryk Bąk, Grzegorz Kozieł

73-81
Comparative analysis of database types in mobile applications running on the Android operating system
Adrian Bartoszek

82-88
Comparative analysis of the performance of selected database management system
Piotr Marcin Tracz, Małgorzata Plechawska-Wójcik

89-96
Comparative Analysis of ORM Systems for the .NET Platform
Tomasz Wiatrowski

97-102
Analysis of Compliance with WCAG Guidelines Regarding Contrast Im-plementation in an E-Learning Quiz
Krzysztof Dziedzic, Marcin Barszcz, Tomasz Wiśniewski

103-108
Comparative analysis of Microsoft’s ,,low-code” programming technology
Grzegorz Łopata, Konrad Gromaszek

109-115
Efficiency comparison of message brokers
Sebastian Dyjach, Małgorzata Plechawska-Wójcik

116-123
Investigating the impact of microservice-oriented platform configurations on application performance
Bartosz Biegajło, Dariusz Czerwiński

124-131
Comparison of Laravel and Symfony - the most popular PHP frame-works, based on a simple CRUD application
Patryk Gajewski, Mariusz Dzieńkowski

132-137
Analysis of the usability of selected auction websites
Adrian Duwer, Mariusz Dzieńkowski

138-144
Comparison of selected tools for automation testing of Web applications
Piotr Pasławski, Maciej Pańczyk

145-150

DOI

https://doi.org/10.35784/jcsi.5927

Authors

Piotr Marcin Tracz

piotr.tracz1@pollub.edu.pl

Lublin University of Technology, Poland

Małgorzata Plechawska-Wójcik

m.plechawska@pollub.pl

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, performance

References

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.

K. Goel, A. H. Ter Hofstede, Privacy-breaching patterns in nosql databases, IEEE Access 9 (2021) 35229–35239. DOI: https://doi.org/10.1109/ACCESS.2021.3062034

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. DOI: https://doi.org/10.19026/rjaset.11.1799

T. Patel, T. Eltaieb, Relational database vs NoSQL, Journal of Multidisciplinary Engineering Science and Technology (JMEST) 2(4) (2015) 691-695.

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. DOI: https://doi.org/10.1145/1900008.1900067

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. DOI: https://doi.org/10.1109/PACRIM.2013.6625441

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. DOI: https://doi.org/10.1109/WAINA.2015.19

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. DOI: https://doi.org/10.1109/ICGCIoT.2015.7380523

S. Sicari, A. Rizzardi, A.Coen-Porisini, Security&privacy issues and challenges in NoSQL databases, Computer Networks 206 (2022) 108828–108830. DOI: https://doi.org/10.1016/j.comnet.2022.108828

B. Jose, S. Abraham, Performance analysis of NoSQL and relational databases with MongoDB and MySQL, Materials today: Proceedings 24 (2020) 2036–2043. DOI: https://doi.org/10.1016/j.matpr.2020.03.634

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. DOI: https://doi.org/10.14569/IJACSA.2015.061111

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. DOI: https://doi.org/10.1007/978-3-319-58274-0_13

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. DOI: https://doi.org/10.3390/app10238524

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. DOI: https://doi.org/10.4236/jcc.2020.84005

S. Schmid, E. Galicz, W. Reinhardt, Performance investigation of selected SQL and NoSQL databases, Proceedings of the AGILE (2015) 1–5. DOI: https://doi.org/10.1109/MILTECHS.2015.7153736

E. F. Codd, A relational model of data for large shared data banks, Communications of the ACM 13 (1970) 377–387. DOI: https://doi.org/10.1145/362384.362685

D. D. Chamberlin, Early history of SQL, IEEE Annals of the History of Computing 34 (2012) 78–82. DOI: https://doi.org/10.1109/MAHC.2012.61

J. R. Groff, P. N. Weinberg, A. J. Oppel, SQL: The Complete Reference Vol. 2, McGrawHill/Osborne, 2002.

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. DOI: https://doi.org/10.3934/bdia.2016004

V. Abramova, J. Bernardino, P. Furtado, Experimental evaluation of NoSQL databases, International Journal of Database Management Systems 6(3) (2014) 1–16. DOI: https://doi.org/10.5121/ijdms.2014.6301

R. Arora, R. R. Aggarwal, Modeling and querying data in mongodb, International Journal of Scientific and Engineering Research 4(7) (2013) 141–144.

I. Carvalho, F. Sá, J. Bernardino, Performance Evaluation of NoSQL Document Databases: Couchbase, CouchDB, and MongoDB, Algorithms 16(2) (2023) 78–95. DOI: https://doi.org/10.3390/a16020078

Tracz, P. M., & Plechawska-Wójcik, M. (2024). Comparative analysis of the performance of selected database management system. Journal of Computer Sciences Institute, 31, 89–96. https://doi.org/10.35784/jcsi.5927

Comparative analysis of the performance of selected database management system

Issue Vol. 31 (2024)

Archives

DOI

Authors

Abstract

Keywords:

References

License

Article Sidebar

Issue Vol. 31 (2024)

Archives

Main Article Content

DOI

Authors

Abstract

Keywords:

References

Article Details

License