Performance analysis of relational databases Oracle and MS SQL based on desktop application

Comparison of efficiency is not a trivial phenomenon because of disparities between different database systems. This paper presents a methodology of comparing relational database systems in respect of mean time of execution individual DML queries containing subqueries and conjunction of tables. The...

Full description

Bibliographic Details
Published in:Journal of Computer Sciences Institute
Main Authors: Dziewit, Grzegorz, Korczyński, Jakub, Skublewska-Paszkowska, Maria
Format: Article in Journal/Newspaper
Language:English
Published: Lublin University of Technology 2018
Subjects:
DML
Online Access:https://ph.pollub.pl/index.php/jcsi/article/view/693
https://doi.org/10.35784/jcsi.693
Description
Summary:Comparison of efficiency is not a trivial phenomenon because of disparities between different database systems. This paper presents a methodology of comparing relational database systems in respect of mean time of execution individual DML queries containing subqueries and conjunction of tables. The presented methodology can be additionally accommodated to studies of efficiency in a range of database system itself (study of queries executed directly in database engine). The described methodology allows to receive statement telling which database system is better in comparison to another in dependency of functionalities fulfilled by external application. In the article the analysis of mean time of execution individual DML queries was performed.Two research hypotheses have been put forward: "Microsoft SQL Server database system needs less time to execute INSERT and UPDATE queries than Oracle database" and "Oracle database system needs less time to execute DML queries with binary data than SQL Server"