Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization
Article Sidebar
Open full text
Issue Vol. 16 (2020)
-
Java and Kotlin code performance in selected web frameworks
Grzegorz Bujnowski, Jakub Smołka219-226
-
Blender as a tool for generating synthetic data
Rafał Sieczka, Maciej Pańczyk227-232
-
Analysis of selected methods of creating artificial intelligence on the example of a popular card game
Łukasz Gałka, Mariusz Dzieńkowski233-240
-
Comparative analysis of Kotlin coroutines with Java and Scala in parallel programming
Adrian Zieliński241-246
-
Performance testing of STL and Qt library elements in multi-threaded processing
Piotr Krasowski, Jakub Smołka247-251
-
A security analysis of authentication and authorization implemented in web applications based on the REST architecture
Tomasz Muszyński, Grzegorz Koziel252-260
-
Analysis of security CMS platforms by vulnerability scanners
Patryk Zamościński, Grzegorz Kozieł261-268
-
Analysis of the Blazor framework in client-hosted mode
Karol Kozak, Jakub Smołka269-273
-
Implementation of solutions for distributed team management in IT sector companies
Mykhailo Kuzyk, Elżbieta Miłosz274-278
-
Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization
Wojciech Truskowski, Rafał Klewek, Maria Skublewska-Paszkowska279-284
-
Comparative analysis of selected object-relational mapping systems for the .NET platform
Krzysztof Drzazga, Marcin Bobel, Maria Skublewska-Paszkowska285-292
-
Analysis of the use of Java and C# languages for building a mobile application for the Android platform.
Michał Jankowski, Maria Skublewska-Paszkowska293-299
-
Performance comparison of chosen JSON parsers and a parser that employs a different reading method
Przemysław Koter300-304
-
Comparison of Objective-C and Swift on the example of a mobile game
Karolina Banach, Maria Skublewska-Paszkowska305-308
-
Comparison of REST and GraphQL web technology performance
Mateusz Mikuła, Mariusz Dzieńkowski309-316
-
The analysis of air pollution based on laser beam photo
Rafał Maksim, Anna Pawelec, Maria Skublewska-Paszkowska317-325
Main Article Content
DOI
Authors
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:
References
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
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). DOI: https://doi.org/10.1145/2790798.2790808
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. 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). DOI: https://doi.org/10.1109/ICACEA.2015.7164727
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. DOI: https://doi.org/10.35784/jcsi.1323
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].
Article Details
Abstract views: 5359
License

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