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

Data synchronization method and device, electronic device and storage medium

A data synchronization and data technology, applied in the computer field, can solve problems such as difficulty in ensuring data integrity and failure to capture

Active Publication Date: 2018-01-16
TAIKANG LIFE INSURANCE CO LTD +1
View PDF5 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, when data synchronization between databases is performed through the synchronization function of the database, the data inserted manually with SQL (Structured Query Language, Structured Query Language) statements cannot be captured, making it difficult to ensure data integrity

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
  • Data synchronization method and device, electronic device and storage medium
  • Data synchronization method and device, electronic device and storage medium
  • Data synchronization method and device, electronic device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0049] refer to image 3 As shown, in step S310, the first thread captures the data operation record, and distributes the captured data operation record to at least one second thread; in step S320, the at least one second thread according to The distributed data operation records are synchronized between the source database and the target database.

[0050] It should be noted that, in this embodiment of the present invention, the first thread may be a main thread, the second thread may be a sub-thread, and the main thread may be a daemon thread.

[0051] For example, the daemon thread can grab data operation records from the above synchronous log table, such as grabbing 1000 data operation records, and the daemon thread will distribute the captured data operation records to sub-threads, such as 20 sub-threads, sub-threads Synchronize the source database A with the target database B according to the distributed data operation records.

[0052] In an embodiment of the present ...

Embodiment 2

[0054] Grab the data operation records, and put the captured data operation records into the message queue; sequentially, according to each data operation record in the message queue, the source database and the target database are synchronized.

[0055] It should be noted that, in the second embodiment, the thread for capturing data operation records may be the main thread, and the thread for synchronizing according to the data operation records in the message queue may be a sub-thread. Of course, the embodiments of the present invention are not limited thereto. For example, the main thread can grab the data operation records from the synchronous log table, put the captured data operation records into the message queue, and use the sub-threads to update the source database according to the order of the data operation records in the message queue. A synchronizes with target database B.

[0056] Further, for the above-mentioned first and second embodiments, a predetermined num...

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 provides a data synchronization method and device, an electronic device and a storage medium, and relates to the technical field of computers. The data synchronizationmethod includes the steps of monitoring data operation events occurring in a source database by a trigger arranged in the source database, generating corresponding data operation records based on themonitored data operation events, and synchronizing the source database with a target database according to the data operation records. According to the technical scheme, various data operation eventsoccurring in the source database can be monitored, and meanwhile the synchronization between the source database and the target database can be achieved under the precondition of maintaining data integrity.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a data synchronization method, a data synchronization device, electronic equipment, and a computer-readable storage medium. Background technique [0002] With the development of Internet technology, the amount of data to be processed is increasing, and many business processing systems use two or more databases to process business data. Therefore, data synchronization between databases has become the focus of attention. [0003] Taking the insurance business as an example, at present, most insurance companies have a front-end database and a back-end database, refer to figure 1 As shown in the insurance business system, the underwriting core area at the back end of the insurance business system is as follows: figure 1 The core area on the left side of the center is generally used by internal personnel. The core database in this core area contains many and complex informa...

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
Inventor 黄志兵潘高峰昃宗亮王鑫
Owner TAIKANG LIFE INSURANCE CO LTD
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