Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison
Article Sidebar
Published:
2020-12-30
Issue Vol. 17 (2020)
Articles
-
Impact of the persistence layer implementation methods on application per-formance
326-331
-
Analysis of positioning errors of the GPS navigation receivers
332-338
-
Analysis and comparison of programming frameworks used for automated tests
339-344
-
An Examination of Selected Websites Availability For People With Various Types of Disabilities
345-350
-
Comparative analysis of web application performance testing tools
351-357
-
Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework
358-364
-
Comparative analysis of microcontrollers from the Arduino family and other compatible ones
365-372
-
Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison
373-378
-
Comparative analysis of medical images watermarking methods
379-383
-
Performance comparison of web services using Symfony, Spring, and Rails examples
384-389
-
Modeling of COVID-19 cases of selected states in Nigeria using linear and non-linear prediction models
390-395
-
Comparative analysis of the technology used to create multi-platform applications on the example of NW.js and Electron
396-400
-
Faster R-CNN model learning on synthetic images
401-404
-
Enviromental data visualisation using Delaunay triangulation
405-411
-
Comparison of methods and tools for generating levels of details of 3D models for popular game engines
412-416
-
Analysis of the use of the UTAUT model for modeling the information technology acceptance process
417-420
-
Transport preferences of the students and employers in Lublin University of Technology
421-427
Main Article Content
Authors
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
Article Details
Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison. (2020). Journal of Computer Sciences Institute, 17, 373-378. https://doi.org/10.35784/jcsi.2281
