Back to Search
Start Over
Comparison of the performance of relational databases PostgreSQL and MySQL for desktop application
- Source :
- Journal of Computer Sciences Institute, Vol 18 (2021)
- Publication Year :
- 2021
- Publisher :
- Politechnika Lubelska, 2021.
-
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.
- Subjects :
- Small data
Database
Relational database
business.industry
Computer science
relational databases
InformationSystems_DATABASEMANAGEMENT
Information technology
QA75.5-76.95
T58.5-58.64
computer.software_genre
Database tuning
Software
comparison of performance
Relational database management system
Electronic computers. Computer science
General Earth and Planetary Sciences
DBMS
business
computer
Java Programming Language
General Environmental Science
Subjects
Details
- ISSN :
- 25440764
- Volume :
- 18
- Database :
- OpenAIRE
- Journal :
- Journal of Computer Sciences Institute
- Accession number :
- edsair.doi.dedup.....ffaaafae9df4e978df975d39a429c975
- Full Text :
- https://doi.org/10.35784/jcsi.2314