Single-source multi-node data synchronization method and system

A data synchronization, multi-node technology, applied in the direction of database indexing, database updating, structured data retrieval, etc., can solve problems such as garbage data, achieve both timeliness, reduce garbage data and database pressure, and quickly and efficiently meet business needs Effect

Pending Publication Date: 2021-03-05
北京思特奇信息技术股份有限公司
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Then, if you need to synchronize multiple copies of data, there are two ways: how many copies of data need to be synchronized, how many changes are triggered in the trigger, or in cascading mode, after the data of the first change table is synchronized, insert the record of the change table The second change table is synchronized downwards in turn; both methods will generate unnecessary garbage data

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
  • Single-source multi-node data synchronization method and system
  • Single-source multi-node data synchronization method and system
  • Single-source multi-node data synchronization method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The principles and features of the present invention will be described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0038] Such as figure 1 As shown, a single-source multi-node data synchronization method provided by the embodiment of the present invention, the method includes: S1, creating a change data table through a trigger;

[0039] It should be noted that when synchronizing the changed data of tables in the database to the memory database or application, a trigger is created on the source table, and a changed data table is created through the trigger. The changed data table can contain the primary key field of the source table and a Flow field;

[0040] S2, inserting multiple changed data into the changed data table;

[0041] S3, read multiple changed data through multiple nodes, and select data to be synchronized in ...

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 single-source multi-node data synchronization method and system, and relates to the field of data synchronization. The method comprises the following steps: establishing a change data table through a trigger, inserting a plurality of change data into the change data table, respectively reading the plurality of change data through a plurality of nodes, and selecting to-be-synchronized data in the change data for synchronization. According to the method, multiple change data in the change data table are read through multiple nodes; and to-be-synchronized data in the change data are selected for synchronization, so that trigger data of only one data source is generated. Therefore, the data can be synchronized to any node, the timeliness of data synchronization is considered, and junk data generated by a database and the pressure of the database are reduced.

Description

technical field [0001] The invention relates to the field of data synchronization, in particular to a single-source multi-node data synchronization method and system. Background technique [0002] At present, when synchronizing the changed data of tables in the database to the memory database or application, a trigger is generally built on the source table to insert the changed data into the changed table, and the application reads the data in the changed table for data synchronization. After synchronization, the data in the change table will be deleted at the same time. Then, if multiple copies of data need to be synchronized, there are two ways: how many copies of data need to be synchronized, how many changes are triggered in the trigger or cascade method, after the first change table data is synchronized, insert the change table record The second change table is synchronized downwards in turn; both methods will generate unnecessary garbage data. Contents of the invent...

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/22G06F16/27G06F16/23
CPCG06F16/2282G06F16/23G06F16/27
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
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