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

Download


Published
2020-09-30

Cited by

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

Authors

Wojciech Truskowski 
wojciech.truskowski@pollub.edu.pl
Poland

Authors

Rafał Klewek 

Poland

Authors

Maria Skublewska-Paszkowska 

Poland

Statistics

Abstract views: 4219
PDF downloads: 3703