Comparison of the performance of relational databases PostgreSQL and MySQL for desktop application
Article Sidebar
Open full text
Issue Vol. 18 (2021)
-
Natural interfaces in VR - comparative analysis
Dawid Majdanik, Adrian Madoń, Tomasz Szymczyk1-6
-
Comparative analysis of solutions used in Automated Testing of Internet Applications
Magdalena Psujek, Aleksandra Radzik, Grzegorz Kozieł7-14
-
Evaluation of the Kinect controller precision
Piotr Mieszawski, Tomasz Szymczyk15-21
-
Analysis of modern human-computer interfaces
Michał Cioczek, Tomasz Czarnota, Tomasz Szymczyk22-29
-
Comparative analysis of tools for the integration of IT systems
Narzędzia do integracji systemów informatycznych - analiza porównawczaVladyslav Shkuta, Marek Miłosz30-36 -
Comparison of frameworks for creating web services using the Axis2/C and gSOAP examples
Roman Bondarev, Beata Pańczyk37-41
-
The comparative analysis of web applications frameworks in the Node.js ecosystem
Bartosz Miłosierny, Mariusz Dzieńkowski42-48
-
Human-social interaction robots to improve shared attention in children with autism
Ali Ashrafi49-54
-
Selection of the type of cooling for an overclocked Raspberry Pi 4B minicomputer processor operating at maximum load conditions
Jakub Machowski, Mariusz Dzieńkowski55-60
-
Comparison of the performance of relational databases PostgreSQL and MySQL for desktop application
Bartłomiej Klimek, Maria Skublewska-Paszkowska61-66
Main Article Content
DOI
Authors
bartlomiej.klimek@pollub.edu.pl
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:
References
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
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
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
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
C.J. Date, An Introduction to Database Systems, Pearson Education, 2004.
Historia baz danych, https://www.quickbase.com/articles/timeline-of-database-history, [11.09.2020].
Historia relacyjnych baz danych, https://twobithistory.org/2017/12/29/codd-relational-model.html, [12.09.2020].
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.
Md. I. Hossain, S. Mahmud, T. D. Santa, Oracle, MySQL, PostgreSQL, SQLite, SQL Server: Performance based competitive analysis, Daffodil International University Dhaka, Bangladesh, 2019.
R. Obe, L. Hsu, PostgreSQL: Up and Running. A practical guide to the advanced open source database, Third edition, O’Reilly Media, 2018.
Dokumentacja PostgreSQL, https://www.postgresql. org/docs/11/intro-whatis.html, [11.09.2020].
Dokumentacja PostgreSQL: Historia, https://www.postgresql.org/docs/8.4/history.html, [11.09.2020].
Artykuł porównujący PostgreSQL i MySQL, https://www.2ndquadrant.com/en/postgresql/postgresql-vs-mysql/, [11.09.2020].
E. Vanier, B. Shah, T. Malepati, Advanced MySQL 8, Packt Publishing Ltd., 2019.
Dokumentacja java: Class System, https://docs.oracle.com/javase/7/docs/api/java/lang/System.html, [18.09.2020].
Blog enterprisedb.com, https://www.enterprisedb.com/blog/postgresql-vs-mysql-360-degreecomparison-syntax-performance-scalability-and-features, [20.09.2020]
Article Details
Abstract views: 3555
License

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