Performance analysis of databases created in virtualized and containerized environment

Zygmunt Łata

zygmunt.lata@pollub.edu.pl
Department 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 machines

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

Download


Published
2023-09-30

Cited by

Łata, Z., & Skublewska-Paszkowska, M. (2023). Performance analysis of databases created in virtualized and containerized environment. Journal of Computer Sciences Institute, 28, 264–272. https://doi.org/10.35784/jcsi.3743

Authors

Zygmunt Łata 
zygmunt.lata@pollub.edu.pl
Department of Computer Science, Lublin University of Technology Poland

Authors

Maria Skublewska-Paszkowska 

Lublin University of Technology Poland

Statistics

Abstract views: 191
PDF downloads: 177