Data synchronism method, data synchronism device and computer-readable storage medium
A data synchronization and computer technology, applied in the field of databases, can solve problems such as unavailability, data backlog, large data differences between source databases and target databases, and achieve the effect of timely cleaning, improving execution efficiency, and ensuring efficient and correct operation.
Inactive Publication Date: 2018-04-24
BEIJING THUNISOFT INFORMATION TECH
View PDF4 Cites 5 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] However, the main problem at present is that when the records in the source database are updated concurrently and the data is updated frequently, the updates from the source database to the target database are performed serially, and the data in the target database is updated slowly. It will be backlogged, and the data difference between the source database and the target database will become larger and larger
If you simply change the serial execution to parallel execution, the order of transactions will be out of order, and the data update in the target database will be wrong and unavailable
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 Construction
[0026] In order to enable those skilled in the art to better understand the present invention, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.
[0027] figure 2 is a schematic flowchart of a method for synchronizing data between a source database and a target database according to an embodiment of the present invention. It should be noted that the method described below is only a preferred embodiment for realizing the present invention, and it does not necessarily include all the steps for implementing the present invention, and not every step is a necessary step for realizing the present invention That is to say, the present invention may also include other steps in addition to the following steps, and / or the present invention may also omit one or more of the following steps. In addition, the following steps are not necessarily performed in the order described, but can also be performed ...
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 relates to a data synchronism method. The method comprises the steps of reading a transaction log of a source database; decoding a transaction into a database operational statement according to the read transaction log, and marking a predetermined key of a record involved by the transaction; establishing a queue mapping table according to the marked predetermined key, wherein the queue mapping table marks a corresponding relation between the predetermined key of the record and the queue in which the transaction corresponding to the record is put; constructing at least one queue according to the queue mapping table; and distributing one thread for each queue, and executing the database operational statement of the transaction in at least one queue in a target database. The invention also relates to a data synchronism device and a computer-readable storage medium. According to the data synchronism method, the data synchronism device and the computer-readable storage medium,on the basis of guaranteeing the correctness of data, the change of data in the source database can be synchronized to the target database rapidly.
Description
technical field [0001] The present invention generally relates to the technical field of databases, in particular to a data synchronization method, a data synchronization device and a computer-readable storage medium for synchronizing data between a source database and a target database. Background technique [0002] At present, when replicating changed data or updating data synchronously between the source database and the target database, usually as figure 1 As shown, firstly, the transaction log of the source database is read, and then the changes in the records of the source database are parsed into corresponding SQL statements for adding, deleting, and modifying, and serially executed in the target database in units of complete transactions The parsed SQL statement ensures that the data changes in the source database are completely copied to the target database, or that the data is updated synchronously between the source database and the target database. [0003] Howe...
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/30G06F9/46
CPCG06F9/466G06F16/2423G06F16/27
Inventor 张升玺余杨华
Owner BEIJING THUNISOFT INFORMATION TECH