Data synchronization method and system and storage medium

A data synchronization and database technology, applied in database indexing, structured data retrieval, special data processing applications, etc., can solve the problems of unstable synchronization and data loss, and achieve the effect of preventing data loss, fast performance, and good fault tolerance.

Inactive Publication Date: 2019-10-25
广州市正盟计算机科技有限公司
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, government departments at all levels have self-built or vertically built many government affairs applications. In some cases, some departments need to share government affairs data of other departments. For analysis and judgment, it is necessary to synchronize the business data of each

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 system and storage medium
  • Data synchronization method and system and storage medium
  • Data synchronization method and system and storage medium

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment 1

[0058] The following combination image 3 The above method is explained in detail.

[0059] A data synchronization method includes the following steps:

[0060] Step 101: The main database event is triggered externally, which can be through the system application operating data or directly triggering the event in the database.

[0061] Step 102: After the trigger listens to the main database operation event, it inserts a piece of data into the synchronous queue library according to the event type. The data includes the data primary key value of the event, the self-increment sequence (queue primary key), and the event (addition, deletion, modification) , Status (to be synchronized, abnormal), trigger event identification (insert, update, delete).

[0062] Step 103: The synchronization program cyclically reads the primary key of the data waiting to be synchronized from the queue library, then finds the data in the table with the same name in the main database, and then writes it to the ...

specific Embodiment 2

[0067] The following combination Figure 4 The above system is explained in detail.

[0068] A data synchronization system includes a main database, a database trigger, a data configuration program to be synchronized, a trigger generation program, a synchronization queue, a synchronization program and at least one client database. The system can realize data synchronization configuration flexibly and quickly, and is compatible with most popular databases in the market.

[0069] The data configuration program to be synchronized is configured by the program to configure the database table names and synchronization conditions that need to be synchronized. The trigger generation program needs to configure the main database connection and the synchronization queue connection. After the program is started, the synchronization trigger is generated according to the database table name and synchronization conditions configured by the data configuration program to be synchronized. At the sa...

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 system and a storage medium, the system comprises a main database, a database trigger, a synchronization queue and at least one client database, a plurality of synchronization data are stored in the main database, and the synchronization queue is provided with database tables corresponding to the synchronization data; wherein the database trigger is used for monitoring a main database, triggering to generate trigger information when a synchronous data sending event operation of the main database is monitored, and sending the trigger information to a corresponding database table; wherein the synchronization queue is used for acquiring synchronization data from the main database in combination with the trigger information and the database table, and performing synchronization operation on the client database according to the acquired synchronization data. Synchronization is carried out in a monitoring and queue synchronizing mode,namely data synchronization is carried out on the basis of a database layer, performance is high, fault tolerance is good, data can be prevented from being lost in data synchronization, and the method can be widely applied to the technical field of data synchronization.

Description

Technical field [0001] The present invention relates to the field of data synchronization technology, in particular to a data synchronization method, system and storage medium. Background technique [0002] At present, government departments at all levels have built or vertically built many government affairs applications. In some cases, some departments need to share the government affairs data of other departments. For example, the supervision platform of the disciplinary committee needs to supervise the government affairs service efficiency of each department and needs to extract the business data of each department. For analysis and judgment, it is necessary to synchronize the business data of various departments to the supervision platform of the Commission for Discipline Inspection. At present, the commonly used data synchronization solutions in the market have the problem of losing data after synchronization failure, or the problem of unstable synchronization after a long p...

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