Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization
Wojciech Truskowski
wojciech.truskowski@pollub.edu.pl(Poland)
Rafał Klewek
(Poland)
Maria Skublewska-Paszkowska
(Poland)
Abstract
Oracle, MSSQL, MySQL and PostgreSQL are four of the most popular relational databases. They are often used in internet applications. This paper aims to compare the efficiency of these technologies in terms of speed using virtualization with Docker. No publications that include virtualization were found among previous papers. After review of the literature, it was hypothesized that the Oracle engine would be the fastest. During the research, a series of experiments was carried out using the application, in which tests for measuring the time of instruction execution were implemented. Each query was measured 100 times and the first measurement was rejected. The obtained results confirmed the hypothesis about the superiority of the Oracle database. As in previous studies, it proved to be the fastest, also using virtualization.
Keywords:
virtualization, Docker, database performance, Oracle, MSSQL, MySQL, PostgreSQLReferences
G. Eason, B. Noble, I. N. Sneddon, On certain integrals of Lipschitz-Hankel type involving products of Bessel functions, Phil. Trans. Roy. Soc. London A247 (1955) 529–551.
DOI: https://doi.org/10.1098/rsta.1955.0005
Google Scholar
Ranking najpopularniejszych baz danych, https://pypl.github.io/DB.html, [24.06.2020]
Google Scholar
Czym jest Docker, https://docs.docker.com/get-started/overview/, [24.06.2020]
Google Scholar
R. Almeida, P. Furtado, J. Bernardino, Performance Evaluation MySQL InnoDB and Microsoft SQL Server 2012 for Decision Support Environments, Proceedings of the Eighth International C* Conference on Computer Science & Software Engineering - C3S2E '15. (2008).
DOI: https://doi.org/10.1145/2790798.2790808
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. Yasir, A Review on Introduction to Docker and its Features, International Journal of Advanced Research in Computer Science and Software Engineering. 8 (2018) 12.
Google Scholar
A.M. Joy, Performance comparison between Linux containers and virtual machines, 2015 International Conference on Advances in Computer Engineering and Applications. (2015).
DOI: https://doi.org/10.1109/ICACEA.2015.7164727
Google Scholar
K. Lachewicz, Performance analysis of selected database systems: MySQL, MS SQL, PostgerSQL in the context of web applications. Journal of Computer Sciences Institute. 14, (Mar. 2020), 94-100.
Google Scholar
S. Stets, G. Kozieł, Comparative analysis of databases working under the control of Windows system, Journal of Computer Sciences Institute. 13 (2019) 298–301.
DOI: https://doi.org/10.35784/jcsi.1323
Google Scholar
Salehi, S. 2016. Mastering symfony. Packt Publishing Limited.
Google Scholar
Czym jest Vue.js, https://vuejs.org/v2/guide/, [24.06.2020].
Google Scholar
Tworzenie kontenera dla bazy danych Oracle, https://blogs.oracle.com/oraclemagazine/deliver-oracle-database-18c-express-edition-in-containers [24.06.2020].
Google Scholar
Authors
Rafał KlewekPoland
Authors
Maria Skublewska-PaszkowskaPoland
Statistics
Abstract views: 4219PDF downloads: 3703
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.