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

Article Sidebar

Open full text

PDF
Published: Dec 30, 2020
DOI: https://doi.org/10.35784/jcsi.2281
Crossref
Scopus
Google Scholar
Europe PMC
Articles

Archives

2020

Main Article Content

DOI

https://doi.org/10.35784/jcsi.2281

Authors

Arkadiusz Solarz

arkadiusz.solarz@pollub.edu.pl

Politechnika Lubelska, Poland
Tomasz Szymczyk

t.szymczyk@pollub.pl

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

References

Article Details

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