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

A method for automatically generating code for data migration from a relational database to a mongodb database

An automatic generation and database technology, applied in relational databases, database models, database design/maintenance, etc., can solve problems such as difficult to reflect, high concurrent read and write performance, low amplification, etc., to reduce manual operations and facilitate migration.

Active Publication Date: 2019-07-09
山东中创软件商用中间件股份有限公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although the traditional relational database has been mature and stable after years of development, its advantages, such as transaction consistency and powerful SQL query capabilities, are difficult to reflect when facing emerging big data.
However, the shortcomings of relational databases, low scalability and availability, and low performance of high concurrent read and write are magnified

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
  • A method for automatically generating code for data migration from a relational database to a mongodb database
  • A method for automatically generating code for data migration from a relational database to a mongodb database
  • A method for automatically generating code for data migration from a relational database to a mongodb database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The present invention will be further described below in conjunction with specific examples. However, the present invention is not limited to the following embodiments. This example generates a maven project based on the Spring Data framework. figure 2 It is the main flowchart of the implementation of the present invention.

[0035] First, connect to the relational database according to the configuration file, and the connection driver depends on the database type. If it is an Oracle database, use ojdbc, if it is a MySql database, use mysql-connector-java, and so on. Then read the table names of all tables from the relational database. Such as figure 2 As shown in read metadata 202, the metadata of each table is read according to the table name, including the index information of the table, the foreign key information of the table, and the column name of each column in the table. Read column metadata based on column name. The read method uses the jdbc method pro...

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 automatically generating codes migrating from a relational database to a Mongo DB database. The method includes the following steps that step one, operation parameters are read from configuration files, and metadata are read from the relational database; step two, a model is established according to the metadata; step three, a model is customized according to the demand; step four, codes are generated according to the model and a template. The invention aims at assisting programmers to perform migration from the relational database to the Mongo DB database, mainly data migration. Compared with self-written scripts, the method is more general and also assists migration of parts of codes except data migration compared with an extract, transform and load (ETL) tool.

Description

technical field [0001] The invention relates to a method for automatically generating codes for data migration from a relational database to a MongoDB database, belonging to the fields of database migration, software aided development, and the like. Background technique [0002] According to a report by EMC Corporation, the total amount of data in the world is growing at a rate of 40% per year, and by 2020, it will reach 44ZB. In this context, big data has attracted more and more attention. Big data refers to a collection of data whose scale is so large that it greatly exceeds the capabilities of traditional database software tools in terms of acquisition, storage, management, and analysis. [0003] A relational database is a database based on a relational model, and uses mathematical concepts and methods such as set algebra to process data in the database. Although the traditional relational database has been mature and stable after years of development, its advantages, s...

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 Patents(China)
IPC IPC(8): G06F16/21
CPCG06F16/214G06F16/254G06F16/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