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...
| Main Authors: | , , |
|---|---|
| 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
|
| _version_ | 1819030657023606784 |
|---|---|
| author | Michal Kvet Lucia Fidesova Karol Matiasko |
| author_facet | Michal Kvet Lucia Fidesova Karol Matiasko |
| author_sort | Michal Kvet |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-12-21T06:33:38Z |
| format | Article |
| id | doaj.art-3ba2f441217543d68a6f6c558941b1d0 |
| institution | Directory Open Access Journal |
| issn | 2305-7254 2343-0737 |
| language | English |
| last_indexed | 2024-12-21T06:33:38Z |
| publishDate | 2016-11-01 |
| publisher | FRUCT |
| record_format | Article |
| series | Proceedings of the XXth Conference of Open Innovations Association FRUCT |
| spelling | doaj.art-3ba2f441217543d68a6f6c558941b1d02022-12-21T19:12:55ZengFRUCTProceedings of the XXth Conference of Open Innovations Association FRUCT2305-72542343-07372016-11-014201912813710.23919/FRUCT.2016.7892192Experimental comparison of syntax and semantics of DBS Oracle and MySQLMichal Kvet0Lucia Fidesova1Karol Matiasko2University of Zilina in Zilina, Zilina, SlovakiaUniversity of Zilina in Zilina, Zilina, SlovakiaUniversity of Zilina in Zilina, Zilina, SlovakiaCurrent 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.https://fruct.org/publications/fruct19/files/Kve.pdf database systemperformance comparisonsemanticsMySQLOracle |
| spellingShingle | Michal Kvet Lucia Fidesova Karol Matiasko Experimental comparison of syntax and semantics of DBS Oracle and MySQL Proceedings of the XXth Conference of Open Innovations Association FRUCT database system performance comparison semantics MySQL Oracle |
| title | Experimental comparison of syntax and semantics of DBS Oracle and MySQL |
| title_full | Experimental comparison of syntax and semantics of DBS Oracle and MySQL |
| title_fullStr | Experimental comparison of syntax and semantics of DBS Oracle and MySQL |
| title_full_unstemmed | Experimental comparison of syntax and semantics of DBS Oracle and MySQL |
| title_short | Experimental comparison of syntax and semantics of DBS Oracle and MySQL |
| title_sort | experimental comparison of syntax and semantics of dbs oracle and mysql |
| topic | database system performance comparison semantics MySQL Oracle |
| url | https://fruct.org/publications/fruct19/files/Kve.pdf
|
| work_keys_str_mv | AT michalkvet experimentalcomparisonofsyntaxandsemanticsofdbsoracleandmysql AT luciafidesova experimentalcomparisonofsyntaxandsemanticsofdbsoracleandmysql AT karolmatiasko experimentalcomparisonofsyntaxandsemanticsofdbsoracleandmysql |