Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph Databases

Ramazan ALTIN; A. Cumhur KINACI

doi:https://doi.org/10.28979/jarnas.936702

Makale detayları

Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph Databases

Yazarlar:

Ramazan ALTIN | A. Cumhur KINACI

Yayıncı:

Çanakkale Onsekiz Mart University

Ana Başlıklar:

Veri işleme & bilgisayar bilimi

Dergi:

Journal of Advanced Research in Natural and Applied Sciences 2022 Vol.8 Issue 2, pp.281-292

Belge Tipi:

Makale

Yayın Tarihi:

6/2022

Belge Dili:

İngilizce

Document ID (Org No.):

2000488231

Sıklık:

Aylık

eISSN:

2757-5195

DOI:

https://doi.org/10.28979/jarnas.936702

Özet:

 

Relational database management systems have been used for storing data for a long time.
However, these systems are insufficient to analyze the large and complex structure of the data. Graph
databases are becoming more common day by day due to their capacity to contribute to the analysis.
Also, graph databases are better at modeling and querying complex relationships than relational
databases. To use graph databases with old data stored in relational databases a transfer process is
needed. In this study, the problems to be encountered in transferring the data stored in a relational
database to a graph database were examined and methods that could be used as solutions to them
were proposed. In addition, it is aimed to prevent data loss and data inconsistency that may occur with
design errors in relational databases. For this purpose, the normalization process needs to be applied
to a relational database before transferring data to a graph database. In our study, we developed a
method that converts data to the first normal form during the transfer. But for better data consistency in
practice third normal form is the minimum requirement. By using the functional dependencies found,
it is possible to make relational databases suitable for higher normal forms. For functional dependency
detection, which is normally a very time-consuming and costly process, we developed a method based
on a graph database.

Makale detayları

Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph Databases

Yazarlar: Ramazan ALTIN | A. Cumhur KINACI

Yayıncı: Çanakkale Onsekiz Mart University

Ana Başlıklar: Veri işleme & bilgisayar bilimi

Dergi: Journal of Advanced Research in Natural and Applied Sciences 2022 Vol.8 Issue 2, pp.281-292

Belge Tipi: Makale

Yayın Tarihi: 6/2022

Belge Dili: İngilizce

Document ID (Org No.): 2000488231

Sıklık: Aylık

eISSN: 2757-5195

DOI: https://doi.org/10.28979/jarnas.936702

Sayı

Yazarlar:

Ramazan ALTIN | A. Cumhur KINACI

Yayıncı:

Çanakkale Onsekiz Mart University

Ana Başlıklar:

Veri işleme & bilgisayar bilimi

Dergi:

Journal of Advanced Research in Natural and Applied Sciences 2022 Vol.8 Issue 2, pp.281-292

Belge Tipi:

Makale

Yayın Tarihi:

6/2022

Belge Dili:

İngilizce

Document ID (Org No.):

2000488231

Sıklık:

Aylık

eISSN:

2757-5195

DOI:

https://doi.org/10.28979/jarnas.936702