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.pl
Lublin 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 performance

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

Download


Published
2021-03-30

Cited by

Klimek, B., & Skublewska-Paszkowska, M. (2021). Comparison of the performance of relational databases PostgreSQL and MySQL for desktop application. Journal of Computer Sciences Institute, 18, 61–66. https://doi.org/10.35784/jcsi.2314

Authors

Bartłomiej Klimek 

Department of Computer Science Poland

Authors

Maria Skublewska-Paszkowska 
maria.paszkowska@pollub.pl
Lublin University of Technology Poland

Statistics

Abstract views: 2523
PDF downloads: 1638