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

Data synchronization method and device of heterogeneous database and electronic equipment

A data synchronization and database technology, applied in the computer field, can solve the problems of unreliability in the transmission process and low efficiency of data synchronization, and achieve the effects of improving data synchronization efficiency, reducing the amount of data operations, and high data synchronization performance

Pending Publication Date: 2021-10-08
PEOPLE'S INSURANCE COMPANY OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Due to the unreliability of the transmission process, the consumer program needs to reconstruct all insert operations to ensure the idempotency of the data. Obviously, this method has the problem of low data synchronization efficiency, especially when receiving a large number of insert operations

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 of heterogeneous database and electronic equipment
  • Data synchronization method and device of heterogeneous database and electronic equipment
  • Data synchronization method and device of heterogeneous database and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the purpose, technical solution and advantages of the application clearer, the technical solution of the application will be clearly and completely described below in conjunction with specific embodiments of the application and corresponding drawings. Apparently, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0028] In order to improve the efficiency of data synchronization between heterogeneous databases, one or more embodiments of the present application provide a data synchronization method for heterogeneous databases. By performing conflict detection on the insert operation corresponding to the data change information of the source database, there will be A target insert op...

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 data synchronization method and device for heterogeneous databases and electronic equipment, and aims to improve the data synchronization efficiency between the heterogeneous databases. The method comprises the following steps: acquiring data operation information corresponding to data change information in a source database, wherein the data operation information comprises data for data operation and an execution sequence; performing conflict detection on an insertion operation in the data operations corresponding to the data change information to identify whether a primary key conflict exists between data aiming at the insertion operation and existing data in a target database or not; reconstructing the target insertion operation into a corresponding deletion operation and a new insertion operation on the basis of the data corresponding to the target insertion operation with the primary key conflict, so as to obtain reconstructed data operation information; and based on the reconstructed data operation information, executing corresponding data operation on the target database so as to synchronize the data change information to the target database.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a data synchronization method, device and electronic equipment for heterogeneous databases. Background technique [0002] Any changes to the database are recorded in the logical log file as binary files. At present, data synchronization between heterogeneous databases is usually based on the synchronization of the logical log files of the source database, that is, the logical log files of the source database are parsed into corresponding data operations and sent to the consumer program at the data synchronization end. Execute the corresponding data operations on the target database in the sequence, so as to realize data synchronization between heterogeneous databases. [0003] Due to the unreliability of the transmission process, the consumer program needs to reconstruct all insertion operations to ensure the idempotency of the data. Obviously, this method has the pr...

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): G06F16/27G06F16/215
CPCG06F16/273G06F16/215
Inventor 雷周纯
Owner PEOPLE'S INSURANCE COMPANY OF CHINA
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