Computer Science

Computer Science ›› 2021, Vol. 48 ›› Issue (10): 140-144.doi: 10.11896/jsjkx.201100073

• Database & Big Data & Data Science • Previous Articles     Next Articles

Conversion Method from Relational Database to Graph Database

E Hai-hong, HAN Peng-hao, SONG Mei-na   

  1. School of Computer Science (National Pilot Software Engineering School),Beijing University of Posts and Telecommunications,Beijing 100876,China
  • Received:2020-11-09 Revised:2021-01-04 Online:2021-10-15 Published:2021-10-18
  • About author:E Hai-hong,born in 1982,Ph.D,asso-ciate professor,is a member of China Computer Federation.Her main research interests include big data platform,cloud computing and microservice architecture.
  • Supported by:
    National Key Research and Development Program of China(2018YFB1403501).

PDF (PC)

1766

Abstract: Due to the differences between the storage mode of relational database and graph database,during the process of transforming data in relational database to graph database,it is necessary to solve the main problems of edge definition,vertex uniqueness and retention of original database constraint information.To solve the above problems,a method of transforming relational database to graph database is proposed.Firstly,by customizing the existing primary key,combined with the uniqueness of the table name,the problem of ensuring the uniqueness of the vertex is solved;through different configuration schemes,the constraint information of the original relational database can be maximized.Then,the edge definition method based on configuration and intermediate table (EDCIT) method is proposed,it provides different edge mapping solutions for multiple types of databases and solves the definition of edges during the transformation.Finally,through experiments on multiple data sets,and using Gremlin statement to test the transformed data,it verifies the integrity and reliability of the transformed data.

Key words: Cross-database data exchange, Graph database, Gremlin, Hugegraph, Relational database

CLC Number: 

  • TP392
[1]IAN R,JIM W,EIFREM E.Graph Databases[M].O'ReillyMedia,Inc.:Cambridge,2015:12-20.
[2]NEEDHAM M,HODLER A E.Graph Algorithms[M].O'Reilly Media,Inc.:California,2019:5-8.
[3]PAUL S,MITRA A,KONER C.A Review on Graph Database and its Representation[C]//International Conference on Recent Advances in Energy-efficient Computing and Communication.2019:1-5.
[4]ZHAO P,SHOU L D,CHEN K,et al.Storage and Query Model for Localized Search on Temporal Graph Data[J].Computer Science,2019,46(10):186-194.
[5]NEO4J STAFF.The Database Model Showdown:An RDBMS vs.Graph Comparison[EB/OL].(2015-08-03) [2020-11-05].https://neo4j.com/blog/database-model-comparison.
[6]OZGUR C,COTO J,BOOTH D.A comparative study of net-work modeling using a relational database (eg Oracle,mySQL,SQL server) vs.Neo4j[C]//Conference Proceedings By Track.2017:156-165.
[7]MAGORZATA P W,RYKOWSKI D.Comparison of Rela-tional,Document and Graph Databases in the Context of the Web Application Development[C]//Information Systems Architecture and Technology:Proceedings of 36th International Conference on Information Systems Architecture and Technology.Springer International Publishing,2016:3-13.
[8]FOSIC I,ŠOLIC K.Graph database approach for data storing,presentation and manipulation[C]//2019 42nd International Convention on Information and Communication Technology,Electronics and Microelectronics.2019:1548-1552.
[9]SHOLICHAH R J,IMRONA M,ALAMSYAH A.Performance Analysis of Neo4j and MySQL Databases using Public Policies Decision Making Data[C]//2020 7th International Conference on Information Technology,Computer,and Electrical Enginee-ring (ICITACEE).2020:152-157.
[10]BATRA S,CHARU T.Comparative analysis of relational and graph databases[J].International Journal of Soft Computing and Engineering (IJSCE),2012,2:509-512.
[11]MUELLER W,IDZIASZEK P,GIERZ U,el al.Mapping and visualization of complex relational structures in the graph form using the Neo4j graph database[C]//Proceedings of Eleventh International Conference on Digital Image Processing.2019.
[12]UNAL Y,OGUZTUZUN H.Migration of data from relational database to graph database[C]//the 8th International Confe-rence.2018:1-5.
[13]DE VIRGILIO R,MACCIONI A,TORLONE R.R2G:a Tool for Migrating Relations to Graphs[C]//International Confe-rence on Extending Database Technology.2014:640-643.
[14]DE VIRGILIO R,MACCIONI A,TORLONE R.Converting relational to graph databases[C]//International Workshop on Graph Data Management Experiences and Systems.2013:1-6.
[15]ANZUM N.Systems for Graph Extraction from Tabular Data[D].Waterloo:University of Waterloo,2020.
[16]SERIN F,METE S,GUL M,et al.Mapping between relational database management systems and graph database for public transportation network[C]//International Research/Expert Conference.2018:209-212.
[17]linlin1989117.HugeGraph之Variables [EB/OL].(2020-10-14) [2020-11-7].https://blog.csdn.net/linlin1989117/article/details/109072676.
[18]thutmose.“JanusGraph与HugeGraph”图形数据库-技术选型-功能对比[EB/OL].(2019-03-25) [2020-11-07].https://blog.csdn.net/lovebyz/article/details/88800363.
[1] LIANG Jing-ru, E Hai-hong, Song Mei-na. Method of Domain Knowledge Graph Construction Based on Property Graph Model [J]. Computer Science, 2022, 49(2): 174-181.
[2] HUANG Mei-gen, LIU Chuan, DU Huan, LIU Jia-le. Research on Cognitive Diagnosis Model Based on Knowledge Graph and Its Application in Teaching Assistant [J]. Computer Science, 2021, 48(6A): 644-648.
[3] LU Jia-wen, YAN Li. Mapping Method from Object-relational Database to RDF(S) [J]. Computer Science, 2021, 48(10): 145-151.
[4] LAI Xin, ZENG Ji-wei. Study on Mapping Transformation from Geometric Aviation Data to Relational Database [J]. Computer Science, 2020, 47(11A): 570-572.
[5] ZHAO Ping, SHOU Li-dan, CHEN Ke, CHEN Gang, WU Xiao-fan. Storage and Query Model for Localized Search on Temporal Graph Data [J]. Computer Science, 2019, 46(10): 186-194.
[6] YANG De-xian, SUN Hua, YU Jiong and GUO Bing-lei. Relational Database Energy Prediction Model Based on MBRC [J]. Computer Science, 2017, 44(7): 161-166.
[7] JIANG Ren-he, ZHENG Xiao-mei, ZHU Xiao-qian, PAN Min-xue and ZHANG Tian. Method of Java Code Repository Construction Based on UML Relationship [J]. Computer Science, 2017, 44(11): 69-79.
[8] GE Wei-yi, ZONG Shi-qiang and YIN Wen-ke. Keyword Search for Relational Databases Based on Offline Index [J]. Computer Science, 2016, 43(4): 182-187.
[9] LUO Jun and WANG Qiu-ju. Semantic Research on Relational Database [J]. Computer Science, 2014, 41(Z6): 455-458.
[10] . Attribute-Value-Distribution Based Result Ran(}ing Algorithm for Object-level [J]. Computer Science, 2013, 40(3): 219-224.
[11] ZHANG Jun,GAO Yan and YU Su-hua. Research on Fuzzy Logic in Database Information Retrieval [J]. Computer Science, 2013, 40(10): 183-189.
[12] . Research on Object-level Information Retrieval over Relational Databases [J]. Computer Science, 2012, 39(1): 142-147.
[13] LU Yan-hui. Storage of Fuzzy Ontologies Based on Relational Databases [J]. Computer Science, 2011, 38(6): 217-222.
[14] . Approach of Ontology Learning from Relational Database Based on FCA [J]. Computer Science, 2011, 38(12): 167-171.
[15] . Research on Watermarking Relational Database Based on Character Field [J]. Computer Science, 2011, 38(12): 162-166.
Viewed
Full text


Abstract

Cited
  Shared   
  Discussed   
No Suggested Reading articles found!
渝ICP备16013121号-4
Add:18# Honghu West Rd., Yubei ,Chongqing,China    Post Code: 401121
Tel: 023-63500828/023-67039612/023-67039623
E-mail: jsjkx12@163.com
Powered by Beijing Magtech Co., Ltd.