Comparative analysis of databases working under the control of Windows system
Article Sidebar
Open full text
Published:
Dec 30, 2019
Issue Vol. 13 (2019)
Articles
-
Machine Learning as a method of adapting offers to the clients
Jacek Bielecki, Oskar Ceglarski, Maria Skublewska-Paszkowska267-271
-
The insulin activity model based on insulin profiles
Tomasz Nowicki272-278
-
UML – a survey on technical university students in Lublin
Kamil Żyła, Adam Ulidowski, Jan Wrzos, Bartłomiej Włodarczyk, Krzysztof Krocz, Patryk Drozd279-282
-
Overview of Big Data platforms
Gabriel Wróbel, Maciej Daniel Wikira283-287
-
Solutions for managing IT projects in the cloud
Grzegorz Szydlowski288-292
-
Performance analysis of the Symfony framework for creating modern web application based on selected versions
Aleksander Wójcik, Mateusz Wolski, Jakub Bartłomiej Smołka293-297
-
Comparative analysis of databases working under the control of Windows system
Serhii Stets, Grzegorz Kozieł298-301
-
Applying of machine learning in the construction of a voice-controlled interface on the example of a music player
Jakub Basiakowski302-309
-
Application of neural networks to the analysis of consumer opinions
Roman Mysan, Ivan Loichuk, Małgorzata Plechawska-Wójcik310-314
-
Comparative analysis of frameworks dedicated to enterprise designing
Katarzyna Curyła, Karolina Habernal315-322
-
Extraction of parameters from biometric data samples
Paweł Danek, Krzysztof Ćwirta, Piotr Kopniak323-331
-
WebAssembly as an alternative solution for JavaScript in developing modern web applications
Dawid Suryś, Piotr Szłapa, Maria Skublewska-Paszkowska332-338
-
Analysis of the defending possibilities against SQL Injection attacks
Chrystian Byzdra, Grzegorz Kozieł339-344
-
Comparison of 3D games’ efficiency with use of CRYENGINE and Unity game engines
Hubert Żukowski345-348
-
Research of an Entity-component-system architectural pattern designed with using of Data-oriented design technique
Dawid Masiukiewicz, Daniel Masiukiewicz, Jakub Smołka349-353
-
Comparative analysis of Kotlin and Java languages used to create applications for the Android system
Daniel Sulowski, Grzegorz Kozieł354-358
-
A performance comparison of garbage collector algorithms in Java Virtual Machine
Igor Kopeć, Jakub Smołka359-365
-
Innovative applications of digital solutions and tools in educating IT school students
Michalina Gryniewicz-Jaworska366-370
Main Article Content
DOI
Authors
Serhii Stets
Lublin 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; firebird
References
[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]
Article Details
Abstract views: 455
License

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