Data synchronization method

A data synchronization and data technology, applied in the field of data processing, can solve the problems of data rollback, data cannot be added, deleted and modified, affecting system performance, etc., to achieve the effect of asynchronous processing

Pending Publication Date: 2018-06-22
SUZHOU JINGYIHUI INFORMATION TECH
View PDF3 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] However, for the data synchronization method using the Trigger trigger mechanism, real-time transaction processing data must also process addition, deletion and modification of its own data when processing its own data, which increases its own business processing time and load, and affects For the performance of the own system, if the transactional database is down or cannot be connected, the data in the real-time transactional database cannot be added, deleted, or modified, resulting in data rollback
Data synchronization through ETL tools and application system queries will affect the performance of CPU, memory and hard disk IO due to querying real-time transactional databases, and ultimately affect the data synchronization process

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] In view of the deficiencies in the prior art, the inventor of this case was able to propose the technical solution of the present invention after long-term research and extensive practice. The technical solution, its implementation process and principle will be further explained as follows.

[0026] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0027] figure 1 A schematic diagram of a data synchronization method proposed by a typical embodiment of the present invention, such as figure 1 As shown, the method specifically includes:

[0028] Create a trigger Trigger in the relevant data table of the source database. When the relevant data tabl...

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. The method is realized through a trigger, a publishing and subscribing system and a connection module, and comprises the following steps of: receiving data change information in a related business table in a source database by the trigger in real time, and sending the data change information to the connection module; carrying out connection communication on the publishing and subscribing system by the connection module so as to send the data change information to the publishing and subscribing system; and after the data change informationis received by the publishing and subscribing system, publishing the change information to a business system which subscribes a business table change operation theme. By adoption of the method, asynchronous processing of the data synchronization process can be realized, so that the problem of database performance reduction caused by real-time query and real-time writing is avoided.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a data synchronization method. Background technique [0002] In software application scenarios, data synchronization between associated data of different systems is often encountered, such as data synchronization between the source database and the target database, data synchronization between the source database and the target business system, and so on. The application scenarios of the database can be divided into real-time transaction processing and analytical transaction processing. The former is used to realize real-time addition, deletion, modification and query of data, emphasizing timeliness, while the latter focuses on data writing and query, which requires high query speed, so that Realize analysis statistics. [0003] Commonly used data synchronization methods in the prior art include: [0004] 1.Triger trigger mechanism to synchronize data [0005] By adding a Trigge...

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
CPCG06F16/273
Inventor 牟春林
Owner SUZHOU JINGYIHUI INFORMATION TECH
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