DATABASE MIGRATION METHOD AND APPARATUS

摘要

A method for migrating data from a relational DB to a graph DB comprises, collecting constraints of referencing tables having a column set as a foreign key, among tables of a relational DB which is a migration source DB, determining a relation type of each of the referencing tables, based on constraints of the referencing table, determining a node generation target table and a relation frame for each of the referencing tables, based on the relation type of the referencing table, and converting data in each row of the node generation target table into a node of a graph DB which is a migration target DB and generating a relation of the graph DB, which connects the generated nodes, according to the relation frame.

主权项

1. A database (DB) migration method comprising:
collecting a plurality of constraints of a referencing table having a column set as a foreign key, the referencing table being one of a plurality of referencing tables, and the plurality of referencing tables being among tables of a relational DB which is a migration source DB; determining a relation type of the referencing table, based on the plurality of constraints of the referencing table; determining a node generation target table and a relation frame for the referencing table, based on the relation type of the referencing table; and converting a plurality of pieces of data in a row of the node generation target table into a node of a graph DB which is a migration target DB, and generating a relation of the graph DB, which connects the generated node to a plurality of other nodes, according to the relation frame.