Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison
Arkadiusz Solarz
arkadiusz.solarz@pollub.edu.plPolitechnika Lubelska (Poland)
Tomasz Szymczyk
(Poland)
Abstract
This article presents a comparative analysis of four popular database technologies. Commercial Oracle Database and SQL Server systems are compared with open source database management systems: PostgreSQL and MySQL. These systems have been available on the market for over a dozen years. Versions released in 2019 were selected for testing and comparasion. For the purposes of the comparative analysis, a database schema was developed and instantiated. Then, test scenarios were developed. They were prepared on the basis of the most popular operations performed with the use of database systems.
Keywords:
relational database, performance, SQLReferences
A. Pelikant, Bazy danych. Pierwsze starcie, Helion, 2012.
Google Scholar
C.J. Date, Database Design and Relational Theory, O'Reilly, 2012.
Google Scholar
B. Pękala, Bazy danych. Teoria i praktyka, Wydawnictwo Uniwersytetu Rzeszowskiego, 2015.
Google Scholar
L. Rockoff, Język SQL. Przyjazny podręcznik, Helion 2017.
Google Scholar
S. Feuerstein, B. Pribyl, Oracle PL/SQL Programming, O′Reilly, 2014.
Google Scholar
Oficjalna dokumentacja SQL Server 2019 https://docs.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver15, [05.2020].
Google Scholar
B. Peasland, Oracle DBA Mentor: Succeeding as an Oracle Database Administrator, Apress, 2019.
DOI: https://doi.org/10.1007/978-1-4842-4321-3
Google Scholar
L. Davidson, J. Moss, Pro SQL Server Relational Data-base Design and Implementation, Apress, 2016.
DOI: https://doi.org/10.1007/978-1-4842-1973-7
Google Scholar
C. Mehta, A. Bhavsar, H. Oza, S. Shah, MySQL 8 Ad-ministrator's Guide: Effective guide to administering high-performance MySQL 8 solutions, Packt Publishing, 2018.
Google Scholar
Ranking systemów zarządzania bazą danych https://db-engines.com/en/ranking ,[08.2020].
Google Scholar
Oficjalna dokumentacja bazy danych PostgreSQL https://www.postgresql.org/files/documentation/pdf/12/postgresql-12-A4.pdf, [02.2020].
Google Scholar
R. West, SQL Server 2019 Administration Inside Out, 2020.
Google Scholar
A. Silberschatz, H.F. Korth, S. Sudarshan, Database System Concepts, McGraw-Hill Higher Education, 2019.
Google Scholar
W. Khadzhynov, P. Ratuszniak, Wprowadzenie do sys-temów baz danych (Wydanie VII), Helion, 2016.
Google Scholar
M. Winand, SQL Performance Explained Everything Developers Need to Know about SQL Performance, 2012.
Google Scholar
Dokumentacja narzędzia wykorzystanego do pomiarów https://github.com/dbeaver/dbeaver/wiki , [07.2020].
Google Scholar
S. Riggs, G. Ciolli, S.K. Meesala, PostgreSQL 11 Ad-ministration Cookbook, Packt Publishing, 2019.
Google Scholar
M. Leach, T. Lahdenmäki, Database Systems: Design, Implementation & Management 12th Edition, Cengage Learning, 2016.
Google Scholar
Authors
Tomasz SzymczykPoland
Statistics
Abstract views: 1678PDF downloads: 1176
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
