Performance analysis of databases created in virtualized and containerized environment
Zygmunt Łata
zygmunt.lata@pollub.edu.plDepartment of Computer Science, Lublin University of Technology (Poland)
Maria Skublewska-Paszkowska
Lublin University of Technology (Poland)
Abstract
Database systems are currently implemented on different environments - containerized and virtualized. This paper aimed to compare the performance of relational databases running on these two environments. Therefore, two research hypotheses were formulated. The first hypothesis assumed that databases running on Docker containers are more efficient than those on virtual machines. The second one assumed that the Oracle is the most efficient database regardless of which environment it was run on. MySQL, PostgreSQL, Microsoft SQL Server and Oracle databases were tested. The study measured the execution times of INSERT, UPDATE, DELETE and SELECT queries. Each test was repeated 100 times. It was stated that databases running on Docker containers outperform instances running on virtual machines. Furthermore, it was found that the PostgreSQL database have a definite advantage in performance over the rest, analysed databases, which allowed the second hypothesis to be rejected.
Keywords:
performance comparison, relational databases, Docker containers, virtual machinesReferences
What is a database? – Simple definition by Oracle, https://www.oracle.com/pl/database/what-is-database/, [02.2023].
Google Scholar
Complete ranking of relational DBMS, https://db-engines.com/en/ranking/relational+dbms, [02.2023].
Google Scholar
Database as a Service (DBaaS) by TechTarget, https://www.techtarget.com/searchdatamanagement/definition/database-as-a-service-DBaaS, [02.2023].
Google Scholar
IBM topics series – What is virtualization?, https://www.ibm.com/topics/virtualization, [02.2023].
Google Scholar
IMB topics series – What is containerization?, https://www.ibm.com/topics/containerization, [02.2023].
Google Scholar
B.B. Rad, H.J. Bhatti, M. Ahmadi, An Introduction to Docker and Analysis of its Performance, International Journal of Computer Science and Network Security (IJCSNS) 17(3) (2017) 228-235.
Google Scholar
R. Klewek, W. Truskowski, M. Skublewska-Paszkowska, Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization, Journal of Computer Sciences Institute (JCSI) 16 (2020) 279-284.
DOI: https://doi.org/10.35784/jcsi.2026
Google Scholar
R. Čerešňák, M. Kvet, Comparison of query performance in relational a non-relation databases, Transportation Research Procedia 40 (2019) 170–177.
DOI: https://doi.org/10.1016/j.trpro.2019.07.027
Google Scholar
M. Ilić, L. Kopanja, D. Zlatković, M. Trajković, D. Ćurguz, Microsoft SQL Server and Oracle: Comparative Performance Analysis, The 7th International Conference on Knowledge Management and Informatics, Vrnjačka Banja, 7(poz. 5) (2021) 33-40.
Google Scholar
K. Islam, K. Ahsan, S. A. K. Bari, M. Saeed, S. Asim, Huge and Real-Time Database Systems: A Comparative Study and Review for SQL Server 2016, Oracle 12c & MySQL 5.7 for Personal Computer, Journal of Basic & Applied Sciences 13 (2017) 481-490.
DOI: https://doi.org/10.6000/1927-5129.2017.13.79
Google Scholar
Y. Bassil, A Comparative Study on the Performance of the Top DBMS Systems, Journal of Computer Science & Research 1(1) (2012) 20-31.
Google Scholar
What is a WSL 2?, https://learn.microsoft.com/en-us/windows/wsl/about#what-is-wsl-2, [03.2023].
Google Scholar
Comparing WSL versions, https://learn.microsoft.com/en-us/windows/wsl/compare-versions, [03.2023].
Google Scholar
Settings configuration in WSL – Microsoft manual, https://learn.microsoft.com/en-us/windows/wsl/wsl-config, [03.2023].
Google Scholar
Specification of IMDb non-commercial datasets, https://developer.imdb.com/non-commercial-datasets/, [03.2023].
Google Scholar
Lecture about query optimization – Section 10.2, https://edu.pjwstk.edu.pl/wyklady/szb/scb/rW10.htm, [03.2023].
Google Scholar
Authors
Zygmunt Łatazygmunt.lata@pollub.edu.pl
Department of Computer Science, Lublin University of Technology Poland
Authors
Maria Skublewska-PaszkowskaLublin University of Technology Poland
Statistics
Abstract views: 187PDF downloads: 174
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.