Performance analysis of databases created in virtualized and containerized environment
Article Sidebar
Open full text
Issue Vol. 28 (2023)
-
The Examination of SQL Queries Efficiency in Chosen IT System
Krzysztof Barczak186-189
-
Comparative analysis of selected databases on the example of a proprietary web application
Łukasz Przychodzień, Dominika Radwan, Grzegorz Kozieł190-196
-
Performance optimization of web applications using Qwik
Adam Lipiński, Beata Pańczyk197-203
-
Analyze the effectiveness of ETL processes implemented using SQL and Apache HiveQL languages
Krzysztof Litka204-209
-
A comparative analysis of the performance of the relational database and the Hadoop environment in the context of analytical data processing
Michał Zadrąg210-216
-
Performance comparison of Flutter platform GUI in web and native environments
Juliusz Piskor, Marcin Badurowicz217-222
-
Usability analysis of banking service interfaces in Poland
Paulina Sułek, Aleksandra Walaszek223-228
-
Comparative analysis of selected tools for test automation of web applications
Analiza porównawcza wybranych narzędzi do automatyzacji testów aplikacji webowychMichał Pojęta, Franciszek Wąsik, Małgorzata Plechawska-Wójcik229-235 -
Comparative analysis of methods for testing web applications
Wojciech Superson, Tomasz Smyk, Małgorzata Plechawska-Wójcik236-241
-
Performance comparison of microservices written using reactive and imperative approaches
Kacper Mochniej, Marcin Badurowicz242-247
-
Comparative analysis of live sports streaming services
Emilia Skiba248-255
-
Comparative analysis of Angular and React development frameworks
Sylwester Skrzypiec, Małgorzata Plechawska-Wójcik256-263
-
Performance analysis of databases created in virtualized and containerized environment
Zygmunt Łata, Maria Skublewska-Paszkowska264-272
-
A comparative analysis of non-relational databases in e-commerce applications
Kacper Saweczko, Grzegorz Rożek, Małgorzata Plechawska-Wójcik273-278
-
Analysis of how universal design principles impact on the perception of virtual museum interfaces
Dawid Nicpoń, Weronika Wach, Maria Skublewska-Paszkowska279-284
-
An accessibility analysis of websites of selected types of universities
Maciej Banaszak, Mariusz Dzieńkowski285-290
-
Impact of changes in graphics setting on performance in selected video games
Kamil Szafran, Małgorzata Plechawska-Wójcik291-295
-
The comparative performance analysis of selected relational database systems
Szymon Schab296-303
Main Article Content
DOI
Authors
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:
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. DOI: https://doi.org/10.35784/jcsi.2026
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
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. DOI: https://doi.org/10.6000/1927-5129.2017.13.79
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].
Article Details
Abstract views: 364
License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
