Open AccessOracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison
Author(s) -
Arkadiusz Solarz,
Tomasz Szymczyk
Publication year - 2020
Publication title -
journal of computer sciences institute
Language(s) - English
Resource type - Journals
ISSN - 2544-0764
DOI - 10.35784/jcsi.2281
Subject(s) - computer science , database , oracle , database schema , database server , relational database management system , view , sql server , oracle database , pl/sql , in memory processing , sql , data transformation services , database design , database tuning , relational database , world wide web , query by example , software engineering , web search query , search engine
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.