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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
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
[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
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
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 Eureka
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Social media
Try Eureka
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