Performance analysis of working with relational and non-relational databases in Java applications

Krzysztof Caban

krzysztof.caban@pollub.edu.pl
Department of Computer Science, Lublin University of Technology (Poland)

Paweł Czuchryta


Department of Computer Science, Lublin University of Technology (Poland)

Beata Pańczyk


Department of Computer Science, Lublin University of Technology (Poland)

Abstract

The article presents a performance analysis of connections to both relational and non-relational databases, critical components of the functionality of modern web applications. The study is concerned with evaluating the advantages of manually integrated database drivers compared to the comprehensive Spring Data module. In addition, the impact of the Spring Framework on the performance of drivers responsible for database connections was investigated. Based on the results obtained, there are performance benefits for CRUD operations when adding drivers manually and using the Spring Framework for JDBC and MongoDB drivers.


Keywords:

Spring Framework, Java, performance, database drivers

MySQL, https://www.mysql.com/, [08.11.2023].
  Google Scholar

MongoDB: The Developer Data Platform, https://www.mongodb.com/, [08.11.2023].
  Google Scholar

Best NoSQL Databases Software in 2023, https://6sense.com/tech/nosql-databases, [08.11.2023].
  Google Scholar

Java | Oracle, https://www.java.com/pl/, [08.11.2023].
  Google Scholar

Introduction to Spring Framework, https://docs.spring.io/spring-framework/docs/3.2.x/spring-framework-reference/html/overview.html, [08.11.2023].
  Google Scholar

Spring Data, https://spring.io/projects/spring-data, [07.12.2023].
  Google Scholar

A. Ginanjar, M. Hendayun, Spring Framework Reliability Investigation Against Database Bridging Layer Using Java Platform, Procedia Computer Science 161 (2019) 1036-1045, https://doi.org/10.1016/j.procs.2019.11.214.
  Google Scholar

Your relational data. Objectively. - Hibernate ORM, https://hibernate.org/orm/, [08.11.2023].
  Google Scholar

Java JDBC API, https://docs.oracle.com/javase/8/docs/technotes/guides/jdbc/, [08.11.2023].
  Google Scholar

Z. Zhiyu, C. Zhiang, Performance Evaluation of Transparent Persistence Layer in Java Applications, Proceedings of the International Conference on Cyber-Enabled Distributed Computing and Knowledge Discovery (2010) 21-26, https://doi.org/10.1109/CyberC.2010.15.
  Google Scholar

A. M. Bonteanu, C. Tudose, A. M. Anghel, Multi-Platform Performance Analysis for CRUD Operations in Relational Databases from Java Programs using Spring Data JPA, Proceedings of the 13th International Symposium on Advanced Topics in Electrical Engineering (ATEE) (2023) 1-6, https://doi.org/10.1109/ATEE58038.2023.10108212.
  Google Scholar

Start Developing with MongoDB - MongoDB Drivers, https://www.mongodb.com/docs/drivers/, [17.01.2024].
  Google Scholar

Docker Documentation: Docker overview, https://docs.docker.com/get-started/overview/, [08.11.2023].
  Google Scholar

Download


Published
2024-12-30

Cited by

Caban, K., Czuchryta, P., & Pańczyk, B. (2024). Performance analysis of working with relational and non-relational databases in Java applications. Journal of Computer Sciences Institute, 33, 298–305. https://doi.org/10.35784/jcsi.6332

Authors

Krzysztof Caban 
krzysztof.caban@pollub.edu.pl
Department of Computer Science, Lublin University of Technology Poland

Authors

Paweł Czuchryta 

Department of Computer Science, Lublin University of Technology Poland

Authors

Beata Pańczyk 

Department of Computer Science, Lublin University of Technology Poland

Statistics

Abstract views: 42
PDF downloads: 25


License

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.