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

Arkadiusz Solarz | Zendy; Tomasz Szymczyk | Zendy

AI Assistant Blog Pricing

Home ZAIA Blog

Open Access

Oracle 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.

The content you want is available to Zendy users.

Already have an account? Click here to sign in.

Having issues? You can contact us here

Accelerating Research