Unlock instant, AI-driven research and patent intelligence for your innovation.

A method and system for real-time synchronization of a database using a message bus

A technology of message bus and real-time synchronization, applied in the field of computer

Inactive Publication Date: 2019-03-26
中国经济信息社有限公司
View PDF6 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Decouple the connection between data synchronization and database system to solve the problem of real-time database synchronization in distributed and other complex application scenarios

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
  • A method and system for real-time synchronization of a database using a message bus
  • A method and system for real-time synchronization of a database using a message bus
  • A method and system for real-time synchronization of a database using a message bus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0012] like Figure 1-2 As shown, a system that uses a message bus for real-time database synchronization. The main database in the system interacts with the monitoring service module. The monitoring service module interacts with each consumer service through the message bus, and each consumer service corresponds to each slave database.

[0013] like image 3 As shown, the monitoring service module determines the master database instance that needs to be synchronized from the main database, that is, the database that needs to be monitored. First, the listening service module pretends to be a slave database or monitors the operation log file of the main database to obtain the operation statement; then the monitoring service module will The operation statement is encapsulated, or the operation is serialized, and sent to the message bus.

[0014] like Figure 4 As shown, the data of the message bus is obtained by the consumer service, and each consumer service is in a parallel ...

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 method and a system for real-time synchronization of a database by using a message bus, include listening to databases that need to be synchronized, Obtains the write operation message of the database in real time, Parse or get the DML of the write operation, DDL, DCL statement, The statement is encapsulated as a message and sent to the message bus. The target database consumption system obtains the message from the message bus, parses out the DML, DDL and DCL statements, converts them into the target database SQL, connects the target data and executes the statement,completes the data writing operation, and achieves the effect of the database data real-time synchronization. The invention can synchronize the database in real time, and can be used in distributed service scene or disaster preparedness and other application scenes requiring real-time synchronization of data.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a method and system for real-time database synchronization using a message bus Background technique [0002] With the advent of the era of the Internet, big data, and artificial intelligence, data as a basic information resource carrier is becoming more and more important. As a data storage system, database systems have become increasingly important in their high availability in information systems. Key technologies in information systems. In general application scenarios, a database serves one application system or several application systems, and its own replication and synchronization mechanism can basically meet the needs. However, with the continuous development of information technology, application scenarios are becoming more and more complicated. Sometimes a The database needs to be used by more systems, and the database systems are also different, such as the ...

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/27
Inventor 曹海旺
Owner 中国经济信息社有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com