Powered by OpenAIRE graph
Found an issue? Give us feedback
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/ Transportation Resea...arrow_drop_down
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
Transportation Research Procedia
Article . 2019 . Peer-reviewed
License: CC BY NC ND
Data sources: Crossref
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
Transportation Research Procedia
Article
License: CC BY NC ND
Data sources: UnpayWall
versions View all 1 versions
addClaim

Comparison of query performance in relational a non-relation databases

Authors: Roman Čerešňák; Michal Kvet;

Comparison of query performance in relational a non-relation databases

Abstract

Abstract Data are the most important treasure of the company. They form the source for the analysis, evaluation and decision making. Complex data management requires sophisticated storage structures and access principles. This paper deals with the database storage architectures, principles and differences, describes the main manipulation operations– insert, update, delete and select. For the evaluation, relational databases, such as Oracle, MySQL, and MS SQL has been selected, which is consecutively compared in the performance section to the non-relational oriented databases – Mongo, Redis, GraphQl and Cassandra, as well. After the theoretical background definition, the experiment section is proposed. For this purpose, a database of the train connections as a combination of all the train stops in Slovakia is designed. For the first performance evaluation model, the only small data portion is used examining the speed of the operation and loading operation into the table. The second model is far more complex, stores a huge number of records. It evaluates the time aspect, as well as storage size demands. Results are summarized in conclusion showing recommendations for the individual database type with emphasis on the speed of the system and limitations.

Related Organizations
  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    40
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Top 10%
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Top 10%
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Top 10%
Powered by OpenAIRE graph
Found an issue? Give us feedback
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
40
Top 10%
Top 10%
Top 10%
gold