INTEGRATION OF RELATIONAL AND GRAPH DATABASES TO SUPPORT THE INFORMATION SYSTEM OF THE SOCIAL NETWORK

Authors

  • Тамара Говорчин Autor

DOI:

https://doi.org/10.24867/22BE16Govorcin

Keywords:

relational database, graph database, entity type, social network.

Abstract

This paper describes the relational and graph database, as well as the problems that can be encountered when using only the relational database. Тhe ways in which the graph database can overcome some of the issues of the relational database are also listed. Based on all the collected information, a way to integrate the relational and graph database was investigated. In this paper, the information system of the social network is also described, which represents a use case of the solution previously performed. The goal of this information system is to facilitate the process of connecting users in the form of expressing friendship within the network, as well as to enable adding and viewing photos with additional information. The conceptual database scheme was designed using the lucid-app tool, and the databases used were MySQL as a relational database and Neo4j as a graph database.

References

[1] Документација везана за Python - https://www.python.org/
[2] Документација везана за Spring Framework - https://en.wikipedia.org/wiki/Spring_Framework#Spring_Boot
[3] Документација везана за React.js - https://reactjs.org/
[4] Документација везана за MySQL базу података - https://www.mysql.com/
[5] Документација везана за Neo4j базу података - https://neo4j.com/
[6] Веб сајт за креирање дијаграма - https://lucid.app/documents#/dashboard
[7] Justin J. Miller - “Graph Database Applications and Concepts with Neo4j “, 2013 - https://asset-pdf.scinapse.io/prod/776871969/776871969.pdf
[8] Chen, Yaowen - “Comparison of Graph Databases and Relational Databases When Handling Large-Scale Social Data”, 1989 - https://harvest.usask.ca/handle/10388/7434
[9] D. Naga Jyothi - “Book Recommendation System using Neo4j Graph Database “, 2020 - http://www.ijaema.com/gallery/55-ijaema-june-4051.pdf

Published

2023-03-06

Issue

Section

Electrotechnical and Computer Engineering