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.
References
What is a database? – Simple definition by Oracle, https://www.oracle.com/pl/database/what-is-database/, [02.2023].
Complete ranking of relational DBMS, https://db-engines.com/en/ranking/relational+dbms, [02.2023].
Database as a Service (DBaaS) by TechTarget, https://www.techtarget.com/searchdatamanagement/definition/database-as-a-service-DBaaS, [02.2023].
IBM topics series – What is virtualization?, https://www.ibm.com/topics/virtualization, [02.2023].
IMB topics series – What is containerization?, https://www.ibm.com/topics/containerization, [02.2023].
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.
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.
R. Čerešňák, M. Kvet, Comparison of query performance in relational a non-relation databases, Transportation Research Procedia 40 (2019) 170–177.
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.
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.
Y. Bassil, A Comparative Study on the Performance of the Top DBMS Systems, Journal of Computer Science & Research 1(1) (2012) 20-31.
What is a WSL 2?, https://learn.microsoft.com/en-us/windows/wsl/about#what-is-wsl-2, [03.2023].
Comparing WSL versions, https://learn.microsoft.com/en-us/windows/wsl/compare-versions, [03.2023].
Settings configuration in WSL – Microsoft manual, https://learn.microsoft.com/en-us/windows/wsl/wsl-config, [03.2023].
Specification of IMDb non-commercial datasets, https://developer.imdb.com/non-commercial-datasets/, [03.2023].
Lecture about query optimization – Section 10.2, https://edu.pjwstk.edu.pl/wyklady/szb/scb/rW10.htm, [03.2023].