Method for migrating data from non-relational database to relational database

A non-relational, database technology, applied in the field of data migration

Active Publication Date: 2014-01-22
SHENZHEN GRADUATE SCHOOL TSINGHUA UNIV
View PDF2 Cites 54 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] Purpose of the present invention is exactly in order to solve the data migration problem from non-relational d...

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 migrating data from non-relational database to relational database
  • Method for migrating data from non-relational database to relational database
  • Method for migrating data from non-relational database to relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] This embodiment addresses the difference between the non-relational database MongoDB and the relational database, and solves the problem of data migration from MongoDB to the relational database. Solved the problem of MongoDB’s non-schema when extracting the database design model from MongoDB to the relational database, which is different from the data migration between relational databases, the problem of MongoDB’s anti-paradigm design when converting the database design model, and the unique array of MongoDB when mapping data types and handling of embedded document data type issues.

[0024] Compared with the traditional method, this embodiment can effectively solve the problem of data migration from MongoDB to relational database. Use the three methods of union compatibility, intersection compatibility, and the first data to solve the problem of MongoDB's modeless feature in migration. Use a specially designed table splitting method to solve MongoDB's unique array a...

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 relates to a method for migrating data from a non-relational database to a relational database. The method comprises the following steps: connecting the non-relational database needing data migration, and obtaining table information in the database; selecting a table needing data migration and a database mode definition method, wherein the selectable database mode definition method comprises user definition, union set compatibility, intersection compatibility, and first article data; guiding the information from the non-relational database to a defined xml document; converting the database design mode of the non-relational database to a design mode of the corresponding relational database; connecting the corresponding relational database, and setting up a corresponding data table according to the database design mode in the xml document; setting up a corresponding index according to index information in the index element. The method for migrating data solves the problems of a denormalization design, non-modeling and special data types when data are migrated from the non-relational database (such as a MonogDB) to the relational database.

Description

technical field [0001] The invention relates to a data migration method from a non-relational database to a relational database. Background technique [0002] In current applications, there is a common problem of dealing with heterogeneous data from multiple databases. The existing technology mainly solves data migration between several commonly used relational databases, such as Oracle, MySQL, and Microsoft SQL Server. With the emergence and development of non-relational databases, more and more applications use relational databases and non-relational databases at the same time, and it is necessary to solve the problem of data migration between non-relational databases and relational databases. [0003] Compared with data migration between relational databases, the data migration between MongoDB and relational databases mainly has the following problems: [0004] 1. MongoDB database design often adopts anti-paradigm design, which is different from the paradigmatic design o...

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
IPC IPC(8): G06F17/30
CPCG06F16/214G06F16/284
Inventor 李秀闫天翔高福信余谨
Owner SHENZHEN GRADUATE SCHOOL TSINGHUA UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap