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

Arkadiusz Solarz

arkadiusz.solarz@pollub.edu.pl
Politechnika 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, SQL

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

Download


Published
2020-12-30

Cited by

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

Authors

Arkadiusz Solarz 
arkadiusz.solarz@pollub.edu.pl
Politechnika Lubelska Poland

Authors

Tomasz Szymczyk 

Poland

Statistics

Abstract views: 1667
PDF downloads: 1169