Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization


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; PostgreSQL

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.

Ranking najpopularniejszych baz danych, https://pypl.github.io/DB.html, [24.06.2020]

Czym jest Docker, https://docs.docker.com/get-started/overview/, [24.06.2020]

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).

R. Čerešňák, M. Kvet, Comparison of query performance in relational a non-relation databases, Transportation Research Procedia. 40 (2019) 170–177.

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.

A.M. Joy, Performance comparison between Linux containers and virtual machines, 2015 International Conference on Advances in Computer Engineering and Applications. (2015).

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.

S. Stets, G. Kozieł, Comparative analysis of databases working under the control of Windows system, Journal of Computer Sciences Institute. 13 (2019) 298–301.

Salehi, S. 2016. Mastering symfony. Packt Publishing Limited.

Czym jest Vue.js, https://vuejs.org/v2/guide/, [24.06.2020].

Tworzenie kontenera dla bazy danych Oracle, https://blogs.oracle.com/oraclemagazine/deliver-oracle-database-18c-express-edition-in-containers [24.06.2020].

Download

Published : 2020-09-30


Truskowski, W., Klewek, R., & Skublewska-Paszkowska, M. (2020). Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization. Journal of Computer Sciences Institute, 16, 279-284. https://doi.org/10.35784/jcsi.2026

Wojciech Truskowski  wojciech.truskowski@pollub.edu.pl
Rafał Klewek 
Maria Skublewska-Paszkowska