DB2 database data synchronization method, device and system

A data synchronization and database technology, which is applied in the computer field, can solve problems such as inability to realize synchronization process breakpoint resume, inability to achieve data synchronization, inability to realize db2 data incremental synchronization, etc., and achieve low synchronization delay and high analysis efficiency Effect

Pending Publication Date: 2020-01-31
SUNING CLOUD COMPUTING CO LTD
View PDF5 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, many of the existing database data synchronization products only support mysql synchronization and cannot realize incremental synchronization of db2 data; in addition, synchronization tools such as GoldenGate and CDC can only realize single-source synchronization, and cannot achieve complete synchronization of source databases. Data synchronization in the scenario of sub-database and sub-table; furthermore, the existing synchronization products cannot realize the resuming of the synchronization process

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
  • DB2 database data synchronization method, device and system
  • DB2 database data synchronization method, device and system
  • DB2 database data synchronization method, device and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0089] Such as figure 1 As shown, the application provides a DB2 database data synchronization method, comprising the following steps:

[0090] S22. Obtain a data synchronization request for the source database to be synchronized and the corresponding target database to be synchronized.

[0091] In this solution, the source database to be synchronized is a DB2 database, and the target database can be a DB2 database, or other relational databases, such as: mysql, oracle, sybase, etc.; in addition, the source database and target database to be synchronized can be a or more. Before this step, it is necessary to configure the source library and the target library to be synchronized to realize the communication connection between the source library and the target library.

[0092] Now take multiple source databases and multiple target databases as an example to describe the configuration process of the source database and target database, including the following steps:

[0093] ...

Embodiment 2

[0153] Such as image 3 As shown, the application provides a DB2 database data synchronization device, including:

[0154] An acquisition module 30, configured to acquire a data synchronization request for a source library to be synchronized and a corresponding target library to be synchronized;

[0155] The first synchronization module 31 is used to perform full synchronization on the target database according to the data of the source database if the request is a full synchronization request;

[0156] The second synchronization module 32 is configured to obtain and analyze the log data generated by the source database in real time if the request is an incremental synchronization request, and perform incremental synchronization on the target database according to the analysis result.

[0157] Preferably, the above-mentioned device also includes:

[0158] The configuration module 33 is used to determine the sub-library information of the source library and the sub-library in...

Embodiment 3

[0186] Corresponding to the above method and device, Embodiment 3 of the present application provides a computer system, including:

[0187] one or more processors; and

[0188] A memory associated with one or more processors. The memory is used to store program instructions. When the program instructions are read and executed by one or more processors, they perform the following operations:

[0189] Obtain a data synchronization request for the source database to be synchronized and the corresponding target database to be synchronized;

[0190] If the request is a full synchronization request, the target database will be fully synchronized according to the data of the source database;

[0191] If the request is an incremental synchronization request, the log data generated by the source database will be obtained in real time and analyzed, and the target database will be incrementally synchronized based on the analysis results.

[0192] in, Figure 4The architecture of the ...

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 embodiment of the invention discloses a DB2 database data synchronization method, device and system. The method comprises the steps of obtaining a data synchronization request for a to-be-synchronized source library and a corresponding to-be-synchronized target library; if the request is a full-amount synchronization request, performing full-amount synchronization on the target library according to the data of the source library; if the request is an incremental synchronization request, acquiring log data generated by the source library in real time, analyzing the log data, and performingincremental synchronization on the target library according to an analysis result. According to the method, full-amount and incremental synchronization of the DB2 database can be realized, and the incremental synchronization mode of the method does not invade the source library and does not influence the service; besides, by expanding the cluster, sub-library and sub-table scene synchronization and sub-library and sub-table synchronization monitoring and coordination can be achieved, mapping relation configuration is conducted on the source library and the target library through middleware, data synchronization from the source library M to the target library N can be achieved, and more complex synchronization scenes are met; furthermore, the full-quantity and incremental synchronization process of the method supports breakpoint resume.

Description

technical field [0001] The invention belongs to the technical field of computers, and in particular relates to a DB2 database data synchronization method, device and system. Background technique [0002] Data synchronization is not a new concept in the database field. Many companies have their own open source or closed source data synchronization products, such as Oracle's GoldenGate, Pentaho's kettle, IBM's CDC, domestic Ali's canal, open source debezium and confluent jdbc connector. However, many of the existing database data synchronization products only support mysql synchronization and cannot realize incremental synchronization of db2 data; in addition, synchronization tools such as GoldenGate and CDC can only realize single-source synchronization, and cannot fully synchronize the source database. The scenario of sub-database and sub-table is used for data synchronization; furthermore, the existing synchronization products cannot realize the resuming of the synchroniza...

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): G06F16/27
CPCG06F16/27
Inventor 张义强周虎吴杰胡睿哲姜浩
Owner SUNING CLOUD COMPUTING CO LTD
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