Comparative analysis of databases working under the control of Windows system


The aim of this paper is to conduct research on the most popular database management systems such as MySQL, PostgreSQL and Firebird in terms of query performance, CPU load and disk usage. At the first stage, the analysis of the popularity of databases was carried out. In the second stage an application was created that allows for communication with selected databases. At the third stage, tests were carried out using a written application and analysis of results.


analysis; MySQL; postgresql; firebird

[1] Avi Silberschatz, Henry F. Korth, S. Sudarshan: Database System Concepts, McGraw-Hill Education, 2010.
[2] Baron Schwartz, Peter Zaitsev, Vadim Tkachenko: High Performance MySQL: Optimization, Backups, and Replication, O'Reilly Media, 2008.
[3] Rob Mattison: Understanding Database Management Systems, McGraw-Hill, 1997.
[4] Date, C.J: Introduction to Database Systems, Pearson, 2000.
[5] Toby J. Teorey: Database Modeling & Design: The Fundamental Principles, Morgan Kaufmann Pub, 1994.
[6] DB-Engines Ranking, [31.03.2019 r.]
[7] IBM Information Management System, [23.06.2019]
[8] TPC-Homepage V5, [25.02.2019]
[9] Firebird, [12.03.2019]
[10] PostgreSQL, [12.03.2019]
[11] MySQL, [15.03.2019]

Published : 2019-12-30

Stets, S., & Kozieł, G. (2019). Comparative analysis of databases working under the control of Windows system. Journal of Computer Sciences Institute, 13, 298-301.

Serhii Stets
Lublin University of Technology  Ukraine
Grzegorz Kozieł 
Lublin University of Technology  Poland