COMPARATIVE PERFORMANCE ANALYSIS OF RELATIONAL AND NON-RELATIONAL DATABASE SYSTEMS
DOI:
https://doi.org/10.24867/28BE36SimicKeywords:
database systems, relational database, non-relational database, performance, queryAbstract
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
[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
Downloads
Published
2024-09-06
Issue
Section
Electrotechnical and Computer Engineering