Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph Databases
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. Graphdatabases are becoming more common day by day due to their capacity to contribute to the analysis.Also, graph da...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Çanakkale Onsekiz Mart University
2022-06-01
|
| Series: | Journal of Advanced Research in Natural and Applied Sciences |
| Subjects: | |
| Online Access: | https://dergipark.org.tr/en/download/article-file/1766229 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1832095475784744960 |
|---|---|
| author | Ramazan Altın A. Cumhur Kınacı |
| author_facet | Ramazan Altın A. Cumhur Kınacı |
| author_sort | Ramazan Altın |
| collection | DOAJ |
| description | 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. Graphdatabases 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 relationaldatabases. To use graph databases with old data stored in relational databases a transfer process isneeded. In this study, the problems to be encountered in transferring the data stored in a relationaldatabase to a graph database were examined and methods that could be used as solutions to themwere proposed. In addition, it is aimed to prevent data loss and data inconsistency that may occur withdesign errors in relational databases. For this purpose, the normalization process needs to be appliedto a relational database before transferring data to a graph database. In our study, we developed amethod that converts data to the first normal form during the transfer. But for better data consistency inpractice 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 dependencydetection, which is normally a very time-consuming and costly process, we developed a method basedon a graph database. |
| format | Article |
| id | doaj-art-5c4eab74a52d4feaa974bfd046e7bdd1 |
| institution | Kabale University |
| issn | 2757-5195 |
| language | English |
| publishDate | 2022-06-01 |
| publisher | Çanakkale Onsekiz Mart University |
| record_format | Article |
| series | Journal of Advanced Research in Natural and Applied Sciences |
| spelling | doaj-art-5c4eab74a52d4feaa974bfd046e7bdd12025-02-05T17:58:10ZengÇanakkale Onsekiz Mart UniversityJournal of Advanced Research in Natural and Applied Sciences2757-51952022-06-018228129210.28979/jarnas.936702453Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph DatabasesRamazan Altın0https://orcid.org/0000-0002-2176-3002A. Cumhur Kınacı1https://orcid.org/0000-0002-8832-5453ÇANAKKALE ONSEKİZ MART ÜNİVERSİTESİÇANAKKALE ONSEKİZ MART ÜNİVERSİTESİ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. Graphdatabases 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 relationaldatabases. To use graph databases with old data stored in relational databases a transfer process isneeded. In this study, the problems to be encountered in transferring the data stored in a relationaldatabase to a graph database were examined and methods that could be used as solutions to themwere proposed. In addition, it is aimed to prevent data loss and data inconsistency that may occur withdesign errors in relational databases. For this purpose, the normalization process needs to be appliedto a relational database before transferring data to a graph database. In our study, we developed amethod that converts data to the first normal form during the transfer. But for better data consistency inpractice 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 dependencydetection, which is normally a very time-consuming and costly process, we developed a method basedon a graph database.https://dergipark.org.tr/en/download/article-file/1766229relational databasegraph databasenormalizationnormal formfunctional dependency |
| spellingShingle | Ramazan Altın A. Cumhur Kınacı Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph Databases Journal of Advanced Research in Natural and Applied Sciences relational database graph database normalization normal form functional dependency |
| title | Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph Databases |
| title_full | Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph Databases |
| title_fullStr | Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph Databases |
| title_full_unstemmed | Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph Databases |
| title_short | Analyzing The Encountered Problems and Possible Solutions of Converting Relational Databases to Graph Databases |
| title_sort | analyzing the encountered problems and possible solutions of converting relational databases to graph databases |
| topic | relational database graph database normalization normal form functional dependency |
| url | https://dergipark.org.tr/en/download/article-file/1766229 |
| work_keys_str_mv | AT ramazanaltın analyzingtheencounteredproblemsandpossiblesolutionsofconvertingrelationaldatabasestographdatabases AT acumhurkınacı analyzingtheencounteredproblemsandpossiblesolutionsofconvertingrelationaldatabasestographdatabases |