Comparative analysis of databases working under the control of Windows system


Abstract

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.


Keywords

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, https://db-engines.com/en/ranking [31.03.2019 r.]
[7] IBM Information Management System, https://en.wikipedia.org/wiki/IBM_Information_Management_System [23.06.2019]
[8] TPC-Homepage V5, http://www.tpc.org [25.02.2019]
[9] Firebird, https://pl.wikipedia.org/wiki/Firebird [12.03.2019]
[10] PostgreSQL, https://pl.wikipedia.org/wiki/PostgreSQL [12.03.2019]
[11] MySQL, https://pl.wikipedia.org/wiki/MySQL [15.03.2019]
Download

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. https://doi.org/10.35784/jcsi.1323

Serhii Stets  kompanybbc@gmail.com
Lublin University of Technology  Ukraine
Grzegorz Kozieł 
Lublin University of Technology  Poland