The impact of relational and non-relational databases on application performance
Article Sidebar
Open full text
Issue Vol. 35 (2025)
-
Analysis of the impact of selected user interface elements on its usability
Damian Wojtal, Paweł Powroźnik113-120
-
Performance comparison of development frameworks in selected environments in REST API architecture
Mateusz Szewczyk, Maria Skublewska-Paszkowska121-128
-
Comparison of data processing efficiency in Java and Scala
Bartosz Markiewicz, Krzysztof Matyjaszczyk, Marek Miłosz129-136
-
Comparative analysis of Python and Rust: evaluating their combined impact on performance
Przemysław Mroczek, Jakub Mańturz, Marek Miłosz137-141
-
Comparison of the flexibility of standard Salesforce components and custom components in Lightning Web Components
Tomasz Olszewski, Klaudia Parczyńska, Marek Miłosz142-149
-
The impact of using eBPF technology on the performance of networking solutions in a Kubernetes cluster
Konrad Miziński, Sławomir Przyłucki150-158
-
A comparative analysis of web application test automation tools
Michał Moń, Beata Pańczyk159-165
-
Advancing Bangla typography: machine learning and transfer learning based font detection and classification approach using the ‘Bang-laFont45’ dataset
ML and TL based font detection and classification approach using ‘Bang-laFont45’ datasetKazi Samiul Islam, Gourab Roy, Nafiz Nahid, Sunjida Yeasmin Ripti, Md. Abu Naser Mojumder, Md. Janibul Alam Soeb, Md. Fahad Jubayer166-174 -
Performance comparison of CRUD operations in Spring Boot and ASP.NET Core frameworks
Michał Grzeszuk, Marek Miłosz175-183
-
The impact of relational and non-relational databases on application performance
Jakub Olszak, Maria Skublewska-Paszkowska184-190
-
An analysis of the quality of interfaces of selected universities in Lublin
Kamil Kurteczka, Marek Miłosz191-196
-
Comparative analysis of the performance of Unity and Unreal Engine
Robert Kilijanek, Marek Miłosz197-201
-
Analysis the efficiency of object detection in images using machine learning libraries in Python
Patryk Kalita, Marek Miłosz202-208
-
Comparative analysis of database access performance of the Hibernate framework and the Jooq library
Karol Hetman, Marek Miłosz209-215
-
Security vulnerabilities in C++ programs
Piotr Michał Adamczyk, Marek Miłosz216-223
-
Impact of web application universal design on accessibility and usability
Daniel Strzelecki, Kamil Adamiec, Maria Skublewska-Paszkowska224-231
Main Article Content
DOI
Authors
Abstract
The purpose of this study was to assess the performance of two database systems, PostgreSQL (relational) and MongoDB (non-relational), in handling data and their impact on application performance. The evaluation was conducted through a series of performance tests including read, write, delete, update, and aggregation operations on small and large datasets. Key metrics such as task completion time, response times were used for comparisons. Based on the results obtained during the experiments, it is difficult to definitively conclude which database system performs better, as both systems demonstrated advantages in different scenarios depending on the specific use case.
Keywords:
References
[1] S. Padhy, G. M. M. Kumaran, A quantitative performance analysis between Mongodb and Oracle NoSQL, In 2019 6th international conference on computing for sustainable global development, IEEE (2019) 387-391.
[2] S. H. Aboutorabi, M. Rezapour, M. Moradi, N. Ghadir, Performance evaluation of SQL and MongoDB databases for big e-commerce data, In 2015 International Symposium on Computer Science and Software Engineering CSSE (2015) 1-7, https://doi.org/10.1109/CSICSSE.2015.7369245. DOI: https://doi.org/10.1109/CSICSSE.2015.7369245
[3] A. Boicea, F. Radulescu, L. I. Agapin, MongoDB vs Oracle database comparison, In 2012 Third International Conference on Emerging Intelligent Data and Web Technologies, IEEE (2012) 330-335, https://doi.org/10.1109/EIDWT.2012.32. DOI: https://doi.org/10.1109/EIDWT.2012.32
[4] Y. Cheng, K. Zhou, J. Wang, Performance analysis of PostgreSQL and MongoDB databases for unstructured data, In 2019 International Conference on Mathematics, Big Data Analysis and Simulation and Modelling, MBDASM (2019) 60-62, https://doi.org/10.2991/mbdasm-19.2019.14. DOI: https://doi.org/10.2991/mbdasm-19.2019.14
[5] S. Chakraborty, S. Paul, K. A. Hasan, Performance comparison for data retrieval from nosql and sql databases: a case study for covid-19 genome sequence dataset, In 2021 2nd International Conference on Robotics, electrical and signal processing techniques (ICREST) IEEE (2021) 324-328, https://doi.org/10.1109/ICREST51555.2021.9331044. DOI: https://doi.org/10.1109/ICREST51555.2021.9331044
[6] I. Carvalho, F. Sá, J. Bernardino, Performance evaluation of NoSQL document data bases: couchbase, CouchDB, and MongoDB, Algorithms 16(2) (2023) 78, https://doi.org/10.3390/a16020078. DOI: https://doi.org/10.3390/a16020078
[7] Y. Li, S. Manoharan, A performance comparison of SQL and NoSQL databases. In 2013 IEEE Pacific Rim conference on communications, computers and signal processing (PACRIM) IEEE (2013) 15-19, https://doi.org/10.1109/PACRIM.2013.6625441. DOI: https://doi.org/10.1109/PACRIM.2013.6625441
[8] G. Dhasmana, P. Gujjar, G. Prasad, P. K. HR, SQL and NOSQL databases in the application of business analytics. In 2023 International Conference on Computer Science and Emerging Technologies (CSET) IEEE (2023) 1-5, https://doi.org/10.1109/CSET58993.2023.10346657. DOI: https://doi.org/10.1109/CSET58993.2023.10346657
[9] M. A. Hassan, Relational and nosql databases: The appropriate database model choice. In 2021 22nd International Arab Conference on Information Technology (ACIT) IEEE (2021) 1-6, https://doi.org/10.1109/ACIT53391.2021.9677042. DOI: https://doi.org/10.1109/ACIT53391.2021.9677042
[10] R. Ceresnak, O. Chovancova, Comparison of Query Performance Between MySQL and MongoDB Database. In CERes Journal 5(1) (2019), 45-51.
Article Details
Abstract views: 223

