A Comparison between a relational and a graph database in the context of a recommendation system

• Autorzy: Stanescu, Liana
• Konferencja: Federated Conference on Computer Science and Information Systems (16 ; 02-05.09.2021 ; online)
• Języki publikacji: EN

Abstrakty

EN

This paper presents a comparison between relational and graph database systems' performance in a web application recommendation system. The comparison is conducted on five different queries starting with simple ones, leading up to more complex queries, that are performed in a typical web social application. The implementation is done in C# using .NET framework and the database systems used are SQL Server and Neo4J. To effectively test the performance of both graph and relational database systems, tests were performed on 4 data sets. The tests imply performing 5 different retrieval queries taken in order of difficulty both in SQL and Neo4J.

Słowa kluczowe

PL

relacyjna baza danych; grafowa baza danych; zapytanie; implementacja; aplikacja internetowa; system rekomendacji

EN

relational database; graph-based database; query; implementation; web application; recommendation system

• Czasopismo: Annals of Computer Science and Information Systems
• Rocznik: 2021
• Tom: Vol. 26
• Strony: 133-139
• Opis fizyczny: Bibliogr. 12 poz., rys., wykr.

Twórcy

autor

Stanescu, Liana

• University of Craiova, Faculty of Automation, Computers and Electronics, Craiova, Romania,

Bibliografia

• 1. J. J. Miller, “Graph Database Applications and Concepts with Neo4j”, in Proceedings of the Southern Association for Information Systems Conference, Atlanta, GA, USA. Vol. 2324, No. 36, 2013
• 2. http://neo4j.com/developer/cypher/
• 3. https://linkurio.us/using-neo4j-to-build-a-recommendation-engine-based-on-collaborative-filtering/
• 4. http://graphaware.com/neo4j/2013/10/11/neo4j-bidirectional-relationships.html
• 5. https://neo4j.com/developer/graph-db-vs-rdbms/
• 6. https://sdtimes.com/databases/guest-view-relational-vs-graph-databases-use/
• 7. S. Medhi, and H. K. Baruah, “Relational Database And Graph Database: A Comparative Analysis”, New Technologies, International Vol. 5, No 2, 2017
• 8. A. Martinez, R. Mora, D. Alvarado, G. Lopez, and S. Quiros, “ A Comparison between a Relational Databases and a Graph Database in the Context of a Personalized Cancer Treatment Application”, in CEUR Workshop Proceedings, Vol. 1644, 2016, http://ceur-ws.org/Vol-1644/paper37.pdf
• 9. Y. Cheng, P. Ding,T. Wang, et al., “Which Category Is Better: Benchmarking Relational and Graph Database Management Systems”, Data Sci. Eng., vol.4, pp. 309–322, 2019 https://doi.org/10.1007/s41019-019-00110-3
• 10. W. Khan, E. Ahmed, and W. Shahzad, “Predictive Performance Comparison Analysis of Relational & NoSQL Graph Databases”, International Journal of Advanced Computer Science and Applications, vol. 8, no. 5, 2017
• 11. K. Sahatqija, J. Ajdari, X. Zenuni, B. Raufi, and F. Ismaili, “Comparison between relational and NOSQL databases”, in Proceedings of MIPRO, pp. 0216-0221, 2018
• 12. R. J. Sholichah, M. Imrona, and A. Alamsyah, “Performance Analysis of Neo4j and MySQL Databases using Public Policies Decision Making Data”, in Proceedings of ICITACEE, pp. 152-157, 2020

Uwagi

1. Track 1: Computer Science and Systems

2. Session: 14th International Symposium on Multimedia Applications and Processing

3. Communication papers

Identyfikatory

DOI

10.15439/2021F33