Performance analysis of selected database management systems
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...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Lublin University of Technology
2024-09-01
|
| Series: | Journal of Computer Sciences Institute |
| Subjects: | |
| Online Access: | https://ph.pollub.pl/index.php/jcsi/article/view/6224 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1832570001747345408 |
|---|---|
| author | Radosław Kowalczyk Jakub Smołka |
| author_facet | Radosław Kowalczyk Jakub Smołka |
| author_sort | Radosław Kowalczyk |
| collection | DOAJ |
| description |
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.
|
| format | Article |
| id | doaj-art-630c673b17854a58ab1ef7828741abb5 |
| institution | Kabale University |
| issn | 2544-0764 |
| language | English |
| publishDate | 2024-09-01 |
| publisher | Lublin University of Technology |
| record_format | Article |
| series | Journal of Computer Sciences Institute |
| spelling | doaj-art-630c673b17854a58ab1ef7828741abb52025-02-02T18:01:27ZengLublin University of TechnologyJournal of Computer Sciences Institute2544-07642024-09-013210.35784/jcsi.6224Performance analysis of selected database management systemsRadosław Kowalczyk0Jakub Smołka1Lublin University of TechnologyLublin University of Technology 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. https://ph.pollub.pl/index.php/jcsi/article/view/6224MySQLPostgreSQLH2 |
| spellingShingle | Radosław Kowalczyk Jakub Smołka Performance analysis of selected database management systems Journal of Computer Sciences Institute MySQL PostgreSQL H2 |
| title | Performance analysis of selected database management systems |
| title_full | Performance analysis of selected database management systems |
| title_fullStr | Performance analysis of selected database management systems |
| title_full_unstemmed | Performance analysis of selected database management systems |
| title_short | Performance analysis of selected database management systems |
| title_sort | performance analysis of selected database management systems |
| topic | MySQL PostgreSQL H2 |
| url | https://ph.pollub.pl/index.php/jcsi/article/view/6224 |
| work_keys_str_mv | AT radosławkowalczyk performanceanalysisofselecteddatabasemanagementsystems AT jakubsmołka performanceanalysisofselecteddatabasemanagementsystems |