Experimental comparison of syntax and semantics of DBS Oracle and MySQL

Current information systems must deal with complex data management with regards on evolution over the time. There are several database systems with different data modelling principles, data handling and management, however concept of relational database is still most popular. The aim of this paper i...

Full description

Bibliographic Details
Main Authors: Michal Kvet, Lucia Fidesova, Karol Matiasko
Format: Article
Language:English
Published: FRUCT 2016-11-01
Series:Proceedings of the XXth Conference of Open Innovations Association FRUCT
Subjects:
Online Access:https://fruct.org/publications/fruct19/files/Kve.pdf
Description
Summary:Current information systems must deal with complex data management with regards on evolution over the time. There are several database systems with different data modelling principles, data handling and management, however concept of relational database is still most popular. The aim of this paper is to analyze and experimentally compare database systems Oracle and MySQL emphasizing the differences in syntax, semantics and performance characteristics. It consists of analysis of existing database systems, comparison of syntactic and semantic differences with regards on developed application functionality to transform commands to another system. Experimental part compares time consumption based on several characteristics.
ISSN:2305-7254
2343-0737