Performance analysis of selected database management systems
Radosław Kowalczyk
radoslaw.kowalczyk1@pollub.edu.plLublin University of Technology (Poland)
Jakub Smołka
Lublin University of Technology (Poland)
Abstract
The article presents the results of performance tests of database management systems. In order to conduct the tests, an application running in Java environment and using an ORM tool such as Hibernate for communication with the database was used. The tests were carried out for test scenarios such as CRUD operations, join queries, aggregate functions, and filter conditions in queries. The DBMSes used for testing were MySQL, PostgreSQL and H2. Performance analysis looked at the execution time of operations, RAM usage and CPU load. Additionally, tests were carried out for different sizes of user groups using the application. PostgreSQL proved to be the best choice for complex operations.
Keywords:
MySQL, PostgreSQL, H2References
N. Dhingra, E. Abdelmoghith, H. T. Mouftah, Performance Evaluation of JPA Based ORM Techniques, In Proceedings of the 2nd International Conference on Computer Science Networks and Information Technology (2016) 263–269.
Google Scholar
M. Grzesińska, M. Waszczyńska, B. Pańczyk, JEE Database Applications Performance, Informatyka, Automatyka, Pomiar W Gospodarce I Ochronie Środowiska 6(4) (2016) 7376, https://doi.org/10.5604/01.3001.0009.5194.
Google Scholar
Hibernate technical documentation, https://hibernate.org, [06.04.2024].
Google Scholar
B. M. Klimek, M. Skublewska-Paszkowska, Comparison of the performance of relational databases PostgreSQL and MySQL for desktop application, Journal of Computer Sciences Institute 18 (2021) 61–66, https://doi.org/10.35784/jcsi.2314.
Google Scholar
K. Jóźwicka, M. Mitrus, Hybrid methods of working with databases in JEE applications, Journal of Computer Sciences Institute 12 (2019) 167–171, https://doi.org/10.35784/jcsi.433.
Google Scholar
Relational DBMS popularity ranking, https://db-engines.com/en/ranking/relational+dbms, [06.04.2024].
Google Scholar
R. Elmasri, S. Navathe, Fundaamentals of Database Systems, Pearson, Boston Munich, 2016.
Google Scholar
C. Bauer, G. King, G. Gregory, Java Persistence with Hibernate, Helion, Gliwice, 2017.
Google Scholar
Java Documentation, https://docs.oracle.com/javase/8/docs/api, [06.04.2024].
Google Scholar
Authors
Jakub SmołkaLublin University of Technology Poland
Statistics
Abstract views: 80PDF downloads: 109
