Method and system for migrating data from graph database to relational database

Abstract

The invention discloses a data migration method and system from a graph database to a relational database, and the method comprises the steps: 1, configuring the connection information of the graph database and the connection information of the relational database, and carrying out the connection; 2, reading graph data information in the graph database, selecting data to be migrated, and constructing a migration object list; wherein the migration object list comprises a vertex table or an edge table; if the migration object list comprises an edge table, the migration object list must comprise a vertex table on which the edge table depends; and 3, migrating the graph data in the graph database into the relational database by constructing an entity table or constructing an ER model according to the content in the migration object list. According to the method, the graph data can be correctly and quickly converted into the relational data.

Description

technical field [0001] The invention belongs to data migration technology, and in particular relates to a method and a corresponding system for migrating data in a graph database to a relational database. Background technique [0002] The graph database stores the adjacency information data between entities, can directly express the relationship between entities in the real world, is easy to model, and because of its unique design, it can efficiently and deeply retrieve the entities existing in massive data Therefore, more and more data are put into the graph database for management. In order to give full play to the huge value of massive graph data, it may be necessary to analyze the data in the graph database (referred to as graph data), such as analyzing the development trend and business revenue from the data (if there is attribute data required by the report in the graph data), from the data In analyzing the consumption tendency of user groups (if there are order infor...

AI Technical Summary

Problems solved by technology

In order to give full play to the huge value of massive graph data, it may be necessary to analyze the data in the graph database (referred to as graph data), such as analyzing the development trend and business revenue from the data (if there is attribute data required by the report in the graph data), from the data In analyzing the consumption tendency of user groups (if there are order information and crowd information data in the graph data), it would be laborious to deal with the above situation if it is completely relied on the graph database. Massive data cannot exert its great value in the graph database, but the relational database can handle it easily. these businesses

[0003] In reality, although graph data can be converted into relational data through complex processing, professional database practitioners must be familiar with the business logic, the two databases before and after conversion, and the relationship between data before they can operate. Learning and time costs high

Images