Comparison of the performance of relational databases PostgreSQL and MySQL for desktop application
Bartłomiej Klimek
Department of Computer Science (Poland)
Maria Skublewska-Paszkowska
maria.paszkowska@pollub.plLublin University of Technology (Poland)
Abstract
The aim of this thesis was to compare the performance of two relational database management systems PostgreSQL and MySQL. For the purpose of the study a relational database was designed and a piece of software was implemented to connect desktop application with the database system. This software shall also create entities and relations between them in desired empty schemes on servers for databases. There has also been implemented a desktop application in Java programming language, that allows browsing data stored in database and performing the tests of database performance. Tests addressed basic operations of adding, collecting, updating and deleting data. Thisthesis makes a hypothesis "PostgreSQL is more efficient for desktop application while loaded with small data, in that case 1000 of queries", that was confirmed by achieved results from tests performed.
Keywords:
DBMS, relational databases, comparison of performanceReferences
C. A. Gy˝or¨odi, D. V. Dum¸se-Burescu, D. R. Zmaranda, R. S¸. Gy˝or¨odi, G. A. Gabor, D. Pecherle. Performance Analysis of NoSQL and Relational Databases with CouchDB and MySQL for Application’s Data Storage, Applied Sciences 2020 vol. 10.
DOI: https://doi.org/10.3390/app10238524
Google Scholar
R. Klewek, W. Truskowski, M. Skublewska-Paszkowska, Porównanie wydajności baz danych MySQL, MSSQL, PostgreSQL oraz Oracle z uwzględnieniem wirtualizacji, Journal of Computer Science Institute 16, 2020, pp. 279–284.
DOI: https://doi.org/10.35784/jcsi.2026
Google Scholar
B. Nejman, B. Pańczyk, Wydajność pracy z bazami danych aplikacji tworzonych w Django, Journal of Computer Science Institute 11, 2019, pp. 82-85.
DOI: https://doi.org/10.35784/jcsi.142
Google Scholar
K. Krocz, O. Kizun, M. Skublewska-Paszkowska, Analiza porównawczawydajności relacyjnych baz danych MySQL, PostgreSQL, MariaDB oraz H2, Journal of Computer Science Institute 14, 2020, pp. 1-7.
DOI: https://doi.org/10.35784/jcsi.1565
Google Scholar
C.J. Date, An Introduction to Database Systems, Pearson Education, 2004.
Google Scholar
Historia baz danych, https://www.quickbase.com/articles/timeline-of-database-history, [11.09.2020].
Google Scholar
Historia relacyjnych baz danych, https://twobithistory.org/2017/12/29/codd-relational-model.html, [12.09.2020].
Google Scholar
C. Asiminidis, G. Kokkonis, S. Kontogiannis, Database systems Performance Evaluation for IoT Applications, Laboratory team of Distributed Microcomputer systems, Department of Mathematics, University of Ioannina, Ioannina,Greece, Department of Business Administration, TEI of Western Macedonia, Grevena, Greece, 2018.
Google Scholar
Md. I. Hossain, S. Mahmud, T. D. Santa, Oracle, MySQL, PostgreSQL, SQLite, SQL Server: Performance based competitive analysis, Daffodil International University Dhaka, Bangladesh, 2019.
Google Scholar
R. Obe, L. Hsu, PostgreSQL: Up and Running. A practical guide to the advanced open source database, Third edition, O’Reilly Media, 2018.
Google Scholar
Dokumentacja PostgreSQL, https://www.postgresql. org/docs/11/intro-whatis.html, [11.09.2020].
Google Scholar
Dokumentacja PostgreSQL: Historia, https://www.postgresql.org/docs/8.4/history.html, [11.09.2020].
Google Scholar
Artykuł porównujący PostgreSQL i MySQL, https://www.2ndquadrant.com/en/postgresql/postgresql-vs-mysql/, [11.09.2020].
Google Scholar
E. Vanier, B. Shah, T. Malepati, Advanced MySQL 8, Packt Publishing Ltd., 2019.
Google Scholar
Dokumentacja java: Class System, https://docs.oracle.com/javase/7/docs/api/java/lang/System.html, [18.09.2020].
Google Scholar
Blog enterprisedb.com, https://www.enterprisedb.com/blog/postgresql-vs-mysql-360-degreecomparison-syntax-performance-scalability-and-features, [20.09.2020]
Google Scholar
Authors
Bartłomiej KlimekDepartment of Computer Science Poland
Authors
Maria Skublewska-Paszkowskamaria.paszkowska@pollub.pl
Lublin University of Technology Poland
Statistics
Abstract views: 2620PDF downloads: 1700
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.