Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for converting relational database into Neo4j model and data migration method

A model conversion and database technology, applied in database models, relational databases, digital data processing, etc., can solve problems such as difficulty in operation, inability to achieve optimal performance, lack of visual display, etc., and achieve easy operation and accurate data migration. Effect

Active Publication Date: 2016-09-07
北京八月瓜科技有限公司
View PDF5 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] One of the purposes of the present invention is to provide a method for converting a relational database to a Neo4j model and for data migration, so as to solve the problem that the existing data migration method cannot achieve optimal performance, lacks visual presentation, is prone to errors in data migration, and is not easy to operate question

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for converting relational database into Neo4j model and data migration method
  • Method for converting relational database into Neo4j model and data migration method
  • Method for converting relational database into Neo4j model and data migration method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0062] In order to illustrate the specific scheme of the present invention, an example is now given. The conceptual model of the following relational database and the conceptual model of Neo4j adopt the ER graphical conceptual model.

[0063] Figure 4 Shown is the conceptual model of the extracted relational database, in which the entities with Tabel subscripts include Actor table, Film_Actor table, Language table, Film table and Film_Text table, between Actor table and Film_Actor table, between Film_Actor table and Film table There is a primary-foreign key relationship between the Language table and the Film table. Assume that no model conversion is performed on the Film_Text table, only other tables are converted, and then the conceptual model of the relational database is converted into the conceptual model of Neo4j according to the Neo4j conceptual model conversion framework, which specifically includes the following steps:

[0064] Step a1: From Figure 4, it can be see...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for converting a relational database into an Neo4j model and a data migration method. The model conversion method includes the followings steps: S1, extracting a concept model of the relational database; S2, screening out a table to be converted; S3, establishing an Neo4j concept model conversion frame; S4, searching a table having a main key consisting of two foreign keys, and converting the table into a relationship entity having attributes; S5, converting the rest of tables which are not be converted into label entities of nodes in the Neo4j concept model; and S6, converting all the other main-foreign relationships in the step S4 into relationship entities without attributes in the Neo4j concept model, except the searched table-related main-foreign relationship. The model conversion method can migrate data from the relational database into the Neo4j model, and allows data migration to be more accurate and easy to operate.

Description

technical field [0001] The invention relates to the technical field of computer databases, in particular to a method for converting a relational database to a Neo4j model and for migrating data. Background technique [0002] In the early days of data modeling, there were two main schools. One was the relational model, which gradually evolved into a relational database; the other was the network structure adopted by the semantic network, which has now evolved into a graph database in non-relational data. The most popular and representative database in graph database is Neo4j. [0003] Neo4j is a high-performance, world-leading graph database with a flexible structure and complete transaction features. Compared with relational databases, Neo4j has its own advantages and disadvantages. The advantage of Neo4j is that it saves all the data in the network rather than in the form of tables in relational databases, so it has good query speed and is especially suitable for expressi...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/214G06F16/254G06F16/258G06F16/284
Inventor 李长青孙鹏丁贵广李志文董艳华
Owner 北京八月瓜科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com