Comparative analysis of databases working under the control of Windows system
Serhii Stets
kompanybbc@gmail.comLublin University of Technology (Ukraine)
Grzegorz Kozieł
Lublin University of Technology (Poland)
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; firebirdReferences
[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]
[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]
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
Authors
Grzegorz KoziełLublin University of Technology Poland
Statistics
Abstract views: 379PDF downloads: 298
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.