Perfomance analysis of relational databases MySQL, PostgreSQL, MariaDB and H2
Article Sidebar
Open full text
Published:
Mar 30, 2020
Issue Vol. 14 (2020)
Articles
-
Perfomance analysis of relational databases MySQL, PostgreSQL, MariaDB and H2
Katarzyna Krocz, Oleksandra Kizun, Maria Skublewska-Paszkowska1-7
-
Applications supporting utilization of agile methods in software development process
Tomasz Bławucki, Siarhei Ramanovich, Maria Skublewska-Paszkowska8-13
-
An assessment of portal to learn foreign languages
Marek Szmit, Paweł Wojtaszko, Grzegorz Kozieł14-18
-
Functional and performance analysis of selected message brokers in a distributed application
Tobiasz Kaciuczyk, Tomasz Korga, Jakub Smołka19-25
-
Comparative analysis of Windows Presentation Foundation and Windows Forms
Michał Pasztaleniec, Maria Skublewska-Paszkowska26-30
-
Impact of the cloud application programming language on the performance of its implementation in selected serverless environments
Krzysztof Bezrąk, Sławomir Przyłucki31-36
-
Application of support vector machine in a traffic lights control
Artur Całuch, Adam Cieślikowski, Małgorzata Plechawska-Wójcik37-42
-
Comparison of GreenDao and Room ORM Systems
Maciej Lewiński43-47
-
An Assessment of IT Students' Awareness in the Field of Instant Messengers Security
Paweł Stręciwilk, Grzegorz Kozieł48-54
-
Methods of determining indicators of similarity of 3D motion
Piotr Flisiak, Marcin Kuszyk55-58
-
Perfomance analysis of frameworks Angular and Vue.js
Roman Baida, Maksym Andriienko, Małgorzata Plechawska-Wójcik59-64
-
Possibility analysis of applying serious game to learn the first aid procedures
Klaudia Zaborek, Małgorzata Plechawska-Wójcik65-72
-
Comparison of the performance of tools for creating a SPA application interface - React and Vue.js
Krzysztof Boczkowski, Beata Pańczyk73-77
-
Comparative analysis of view technologies for the Spring application
Vadym Borys, Roman Slezenko, Beata Pańczyk78-81
-
Performance analysis of selected tools for building a Single Page Application
Yehor Timanovskyi, Małgorzata Plechawska-Wójcik82-87
-
Analysis of selected usability assessment methods in the process of creating web applications
Krzysztof Nowak, Daniel Samolej88-93
-
Performance analysis of selected database systems: MySQL, MS SQL, PostgerSQL in the context of web applications
Katarzyna Lachewicz94-100
-
Methods of creating realistic spaces – 3D scanning and 3D modelling
Aleksandra Salwierz, Tomasz Szymczyk101-108
Main Article Content
DOI
Authors
Katarzyna Krocz
Lublin University of Technology, Poland
Oleksandra Kizun
oleksandra.kizun@pollub.edu.pl
Lublin University of Technology, Ukraine
Maria Skublewska-Paszkowska
Lublin University of Technology, Poland
Abstract
This article will compare the performance of relational databases MySQL, PostgreSQL, MariaDB and H2. The speed of executing will be tested on simple and more complex SQL queries. The tests results will show which database is more efficient.
Keywords:
DBMS; relational model; performance analysis
References
[1] Y. Abubakar, Benchmarking popular open source RDBMS: a performance evaluation for it professionals, International Journal of Advanced Computer Technology (IJACT), 2014.
[2] S. Tongkaw, A. Tongkaw, A Comparison of Database Performance of MariaDB and MySQL with OLTP Workload, IEEE Conference on Open Systems (ICOS), 2016.
[3] M. Meekyung, Experiments of Search Query Performance for SQL-Based Open Source Databases, International Journal of Internet, 2018.
[4] R. Poljak, P. Pošcić, D. Jakšić, Comparative Analysis of the Selected Relational Database Management Systems, MIPRO, 2017.
[5] Ranking SZBD według ich popularności, https://db engines.com/en/ranking, [20.03.2019].
[6] Opis bazy MySQL, https://pl.wikipedia.org/wiki/MySQL, [20.03.2019].
[7] Dokuntacja MySQL, https://dev.mysql.com/doc/, [20.03.2019].
[8] Opis bazy MariaDB, https://en.wikipedia.org/wiki/MariaDB, [20.03.2019].
[9] Silnik MyRocks, https://mariadb.com/kb/en/library/about-myrocks-for-mariadb/, [20.03.2019].
[10] J. D. Drake , J. C. Worsley, Practical PostgreSQL, O’Reilly Media, Inc., 2002.
[11] Dokumentacja PostgreSQL, https://www.postgresql.org/docs/11/index.html, [20.03.2019].
[12] Opis bazy H2, https://en.wikipedia.org/wiki/H2_(DBMS), [20.03.2019].
[13] Strona bazy H2, http://www.h2database.com/html/main.html, [20.03.2019].
[2] S. Tongkaw, A. Tongkaw, A Comparison of Database Performance of MariaDB and MySQL with OLTP Workload, IEEE Conference on Open Systems (ICOS), 2016.
[3] M. Meekyung, Experiments of Search Query Performance for SQL-Based Open Source Databases, International Journal of Internet, 2018.
[4] R. Poljak, P. Pošcić, D. Jakšić, Comparative Analysis of the Selected Relational Database Management Systems, MIPRO, 2017.
[5] Ranking SZBD według ich popularności, https://db engines.com/en/ranking, [20.03.2019].
[6] Opis bazy MySQL, https://pl.wikipedia.org/wiki/MySQL, [20.03.2019].
[7] Dokuntacja MySQL, https://dev.mysql.com/doc/, [20.03.2019].
[8] Opis bazy MariaDB, https://en.wikipedia.org/wiki/MariaDB, [20.03.2019].
[9] Silnik MyRocks, https://mariadb.com/kb/en/library/about-myrocks-for-mariadb/, [20.03.2019].
[10] J. D. Drake , J. C. Worsley, Practical PostgreSQL, O’Reilly Media, Inc., 2002.
[11] Dokumentacja PostgreSQL, https://www.postgresql.org/docs/11/index.html, [20.03.2019].
[12] Opis bazy H2, https://en.wikipedia.org/wiki/H2_(DBMS), [20.03.2019].
[13] Strona bazy H2, http://www.h2database.com/html/main.html, [20.03.2019].
Article Details
Krocz, K. ., Kizun, O., & Skublewska-Paszkowska, M. (2020). Perfomance analysis of relational databases MySQL, PostgreSQL, MariaDB and H2. Journal of Computer Sciences Institute, 14, 1–7. https://doi.org/10.35784/jcsi.1565
Abstract views: 1670
License

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