COMPARATIVE PERFORMANCE ANALYSIS OF RELATIONAL AND NON-RELATIONAL DATABASE SYSTEMS

Authors

  • Миљана Симић Autor

DOI:

https://doi.org/10.24867/28BE36Simic

Keywords:

database systems, relational database, non-relational database, performance, query

Abstract

This thesis describes the fundamental concepts of relational and non-relational database systems and their performance. The comparison of database performance was conducted in terms of the average query execution time. The selected dataset was described, and relational (MySQL) and non-relational (Neo4j) databases were created and populated with data. Special attention is given to the classification of queries into different categories for easier performance comparison. Queries are analysed and optimized using appropriate techniques. MySQL Workbench and Neo4j Desktop tools are used for the development and management of the selected databases. Python is used to establish connections with databases and execute queries.

References

[1] Oracle, Database topics, https://www.oracle.com/database/what-is-database/
[2] Couchbase, Why NoSQL, https://www.couchbase.com/resources/why-nosql/
[3] Wikipedia, Graph database, https://en.wikipedia.org/wiki/Graph_database
[4] Oracle, Database Performance Tuning Guide
[5] Alexandra Goltsis, A Performance Comparison of SQL and NoSQL Database Management Systems for 5G Radio Base Station Configuration, Linköping University, 2022, 57 p, https://www.researchgate.net/
[6] Petri Kotiranta, Marko Junkkari, Jyrki Nummenmaa: Performance of Graph and Relational Databases in Complex Queries, Tampere University, 2022, 16 p, https://www.researchgate.net/
[7] Mit Jain, Ashish Khanchandani, Cajetan Rodrigues: Performance Comparison of Graph Database and Relational Database, Computer Science Department San Jose State University, 2023, 19 p, https://www.researchgate.net/
[8] Скуп података Shopify app store, https://www.kaggle.com/datasets/usernam3/shopify-app-store

Published

2024-09-06

Issue

Section

Electrotechnical and Computer Engineering