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

Automatic data migration method and apparatus supporting multiple data sources

A multi-data source and data technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problem that multiple databases or servers cannot obtain results and transfer them to another database or server, and do not support Multiple different database data, SQL statement field definitions, different data formats, etc.

Inactive Publication Date: 2017-12-01
云宏信息科技股份有限公司 +1
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] For databases such as MySQL, Oracle, SQLServer, etc., which are relatively popular database systems nowadays, each enterprise or individual will choose a different database system to build their own database according to their own needs; at the same time, different databases have their own regulations. Principles, such as SQL statements, field definitions, data formats, etc. are different; moreover, the two mainstream persistence layer frameworks like Hibernate and MyBatis do not support fetching data from multiple different databases at the same time, so when two or three When transferring data between different databases, it is not possible to obtain results from multiple databases or servers at the same time and transfer them to another database or server

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
  • Automatic data migration method and apparatus supporting multiple data sources
  • Automatic data migration method and apparatus supporting multiple data sources
  • Automatic data migration method and apparatus supporting multiple data sources

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0030] The existing Java mainstream persistence layer frameworks are Hibernate and MyBatis, and these two frameworks are based on JDBC encapsulation, which simplifies the complex configuration of JDBC for different database types.

[0031] For example, for Hibernate, it works as follows:

[0032] A. Through Configuration config=new Configuration().configure(); / / Read and parse the hibernate.cfg.xml configuration file;

[0033] B. By <mapping resource="com / xx / User.hbm in hibernate.cfg.xml

[0034] .xml" / >; read and parse the mapping information

[0035] C. Through SessionFactory sf=config.buildSessionFactory(); / / Create SessionFactory

[0036] D. Session session=sf.openSession(); / / Open Sesssion

[0037] E. Transaction tx=session.beginTransaction(); / Create and start transaction Transation;

[0038] F, persistent operate; operating data, persistent operation

[0039] G. tx.commit(); / / commit the transaction

[0040] H. Close the Session; close the SesstionFactory.

[0041] Fo...

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 an automatic data migration method supporting multiple data sources. The method comprises the following steps of loading and analyzing a configuration file; obtaining information of each source database according to the configuration file and accessing each source database to obtain a source result set; obtaining corresponding target database and data conversion type according to the configuration file, and converting the source result set into a target result set according to the data conversion type; and inserting the target result set into the target database. The invention furthermore provides an automatic data migration apparatus supporting the data sources. According to the method and the apparatus, the data from different data sources or servers is automatically transferred to the target database, so that the problem that a mainstream framework does not support data transfer of the data sources in the prior art is solved.

Description

technical field [0001] The invention relates to a data migration method, in particular to a data migration method and device between multiple data sources. Background technique [0002] For databases such as MySQL, Oracle, SQLServer, etc., which are relatively popular database systems nowadays, each enterprise or individual will choose a different database system to build their own database according to their own needs; at the same time, different databases have their own regulations. Principles, such as SQL statements, field definitions, data formats, etc. are different; moreover, the two mainstream persistence layer frameworks like Hibernate and MyBatis do not support fetching data from multiple different databases at the same time, so when two or three When transferring data between different databases, it is not possible to obtain results from multiple databases or servers at the same time and transfer them to another database or server. Contents of the invention [0...

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/214
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