Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for generating custom message structure by custom monitoring of database changes and control device

A technology for customizing messages and control devices, applied in the database field, can solve problems such as difficult to meet fast and efficient needs, and achieve the effect of accurate configuration

Pending Publication Date: 2020-09-01
HAOYUN TECH CO LTD
View PDF1 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, only data synchronization can be performed in this scheme. If further operations are required, additional data loading modules are required, such as protocol configuration units and data transmission units.
These units must be designed individually according to the actual situation. When the business changes frequently, it is difficult to meet the needs of fast and efficient

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
  • Method for generating custom message structure by custom monitoring of database changes and control device
  • Method for generating custom message structure by custom monitoring of database changes and control device
  • Method for generating custom message structure by custom monitoring of database changes and control device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] The present disclosure will be further described in detail below with reference to the drawings and embodiments. It can be understood that the specific implementation manners described here are only used to explain relevant content, rather than to limit the present disclosure. It should also be noted that, for ease of description, only parts related to the present disclosure are shown in the drawings.

[0033] It should be noted that, in the case of no conflict, the implementation modes and the features in the implementation modes in the present disclosure can be combined with each other. The present disclosure will be described in detail below with reference to the drawings and embodiments.

[0034] In order to make the purpose, technical solutions and advantages of the embodiments of the present disclosure clearer, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the drawings in th...

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

Aiming at the defects in the prior art, the invention relates to a method and a device for generating a custom message structure by custom monitoring of database change, and aims to monitor change message notifications of different message structures issued by Mysql database table change. In order to achieve the purpose, the invention is realized through the following technical scheme: the methodfor generating the custom message structure by custom monitoring of the database change comprises the following steps: 1, a configuration stage; 2, subscribing binlog log data from the Mysql, and analyzing the binlog to obtain a library name, a table name and change content of the database; 3, according to filtering rule configuration of the library table, filtering matching operation types, fields and field condition values; 4, performing structure conversion to obtain a brand-new data structure; and step 5, publishing the data to a message queue theme. By means of the technical scheme, configuration is flexible and rapid, the configuration process is dynamic, configuration and use are achieved immediately, the method takes effect in time, and recompilation and restarting are not needed.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and a control device for generating a custom message structure by custom monitoring changes in a database. Background technique [0002] The data in the database is constantly changing during the application process, and technicians need to continuously monitor the data changes in the database in order to achieve certain requirements. Take the Mysql database as an example. The library table change and data change monitoring of the Mysql database usually uses the analysis of the Mysql binlog (database log) to obtain the change message. According to the business application, the software code is written to filter different library tables and data changes, and the analysis becomes different. The message structure meets different applications as a data-driven source. [0003] However, in the prior art, even if it corresponds to the same database, different software codes ...

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/21G06F16/23G06F16/27
CPCG06F16/21G06F16/23G06F16/27Y02P90/02
Inventor 温凌敏林晓华
Owner HAOYUN TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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