Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison


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; SQL

A. Pelikant, Bazy danych. Pierwsze starcie, Helion, 2012.

C.J. Date, Database Design and Relational Theory, O'Reilly, 2012.

B. Pękala, Bazy danych. Teoria i praktyka, Wydawnictwo Uniwersytetu Rzeszowskiego, 2015.

L. Rockoff, Język SQL. Przyjazny podręcznik, Helion 2017.

S. Feuerstein, B. Pribyl, Oracle PL/SQL Programming, O′Reilly, 2014.

Oficjalna dokumentacja SQL Server 2019 https://docs.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver15, [05.2020].

B. Peasland, Oracle DBA Mentor: Succeeding as an Oracle Database Administrator, Apress, 2019.

L. Davidson, J. Moss, Pro SQL Server Relational Data-base Design and Implementation, Apress, 2016.

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.

Ranking systemów zarządzania bazą danych https://db-engines.com/en/ranking ,[08.2020].

Oficjalna dokumentacja bazy danych PostgreSQL https://www.postgresql.org/files/documentation/pdf/12/postgresql-12-A4.pdf, [02.2020].

R. West, SQL Server 2019 Administration Inside Out, 2020.

A. Silberschatz, H.F. Korth, S. Sudarshan, Database System Concepts, McGraw-Hill Higher Education, 2019.

W. Khadzhynov, P. Ratuszniak, Wprowadzenie do sys-temów baz danych (Wydanie VII), Helion, 2016.

M. Winand, SQL Performance Explained Everything Developers Need to Know about SQL Performance, 2012.

Dokumentacja narzędzia wykorzystanego do pomiarów https://github.com/dbeaver/dbeaver/wiki , [07.2020].

S. Riggs, G. Ciolli, S.K. Meesala, PostgreSQL 11 Ad-ministration Cookbook, Packt Publishing, 2019.

M. Leach, T. Lahdenmäki, Database Systems: Design, Implementation & Management 12th Edition, Cengage Learning, 2016.

Download

Published : 2020-12-30


Solarz, A., & Szymczyk, T. (2020). Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison. Journal of Computer Sciences Institute, 17, 373-378. https://doi.org/10.35784/jcsi.2281

Arkadiusz Solarz  arkadiusz.solarz@pollub.edu.pl
  Poland
Tomasz Szymczyk