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

Out-of-order processing method and device for multi-association real-time data stream, medium and equipment

A processing method and data flow technology, applied in the direction of electrical digital data processing, special data processing applications, relational databases, etc., can solve problems such as difficult to guarantee order, loss, data delay, etc., to solve the problem of data flow disorder in multiple association tables, achieve simple effects

Pending Publication Date: 2021-10-19
北京亿欧网盟科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] When the real-time computing framework is used to process the data flow, it is faced with the problems of data delay, loss, and duplication. Therefore, it is necessary to store the delayed data and the offset of consumption in the buffer area to ensure the accuracy of the data, but in improving the task It is difficult to guarantee the sequence problem in the case of multiple partitions with a high degree of parallelism, so in some business scenarios that need to guarantee the sequence, it will lead to deviations

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
  • Out-of-order processing method and device for multi-association real-time data stream, medium and equipment
  • Out-of-order processing method and device for multi-association real-time data stream, medium and equipment
  • Out-of-order processing method and device for multi-association real-time data stream, medium and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0047] figure 1 It is a flowchart of a method for out-of-order processing of multi-associated real-time data streams in an embodiment of the present invention. Such as figure 1 As shown, the method includes the following steps:

[0048]S110, real-time monitoring of log changes in the main table and / or associated table in the database;

[0049] S120. When the log of the main table and / or the associated table in the database changes, obtain the change record of the main table and / or the change record of the associated table, and write the change record of the main table into the main table topic of the message queue in parallel in a multi-partition manner , write the change record of the association table in parallel to the topic of the association table of the message queue in a multi-partition manner;

[0050] S130. Start the real-time process of the main table to obtain the multi-partition data stream of the main table from the subject of the main table, and start the real...

Embodiment 2

[0164] image 3 It is a functional block diagram of an out-of-order processing device for multi-associated real-time data streams according to an embodiment of the present invention. Such as image 3 As shown, the device 200 includes:

[0165] Real-time monitoring and acquisition module 210, for real-time monitoring of log changes in the main table and / or associated table in the database;

[0166] The real-time synchronization module 220 is used to obtain the change record of the main table and / or the change record of the related table when the log of the main table and / or the related table in the database changes, and write the changed record of the main table into the message queue in parallel in a multi-partition manner In the main table topic of the message queue, the associated table change records are written in parallel to the associated table topic of the message queue in a multi-partition manner;

[0167] The process start module 230 is used to start the main table...

Embodiment 3

[0177] The embodiment of the present invention also provides a computer-readable storage medium. A computer program is stored in the computer-readable storage medium. When the computer program is executed by a processor, it realizes:

[0178] Real-time monitoring of log changes in the main table and / or associated tables in the database;

[0179] When the log of the main table and / or the associated table in the database changes, obtain the main table change record and / or the associated table change record, and write the main table change record into the main table of the message queue in parallel in a multi-partition manner In the topic, the association table change records are written in parallel into the association table topic of the message queue in a multi-partition manner;

[0180] Start the main table real-time process to obtain the multi-partition data stream of the main table from the main table topic, start the real-time process of the associated table to obtain the m...

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 provides an out-of-order processing method and device for a multi-association real-time data stream, a medium and equipment. The method comprises the steps: monitoring the log changes of a main table and / or an association table in a database in real time; when the log changes, writing the main table change record and the association table change record into corresponding topics of the message queue in parallel in a multi-partition mode; acquiring multi-partition data streams of the main table and the association table; loading a service primary key of the primary table to a cache region; obtaining a service foreign key, and judging whether a corresponding service primary key can be obtained from the cache region or not; if the service main key can be obtained, combining the multi-partition data streams of the main table and the association table into independent partition data streams, grouping the independent partition data streams according to specified fields, sorting the grouped data streams, consuming the grouped data streams, and executing service logic processing on the consumed data flow. According to the method, disorder in a high-concurrency multi-association data stream real-time scene can be solved.

Description

technical field [0001] The invention relates to the field, in particular to a method, device, medium and equipment for out-of-order processing of multi-associated real-time data streams. Background technique [0002] In the era of big data, with the continuous increase of data volume, various types of data and more and more real-time big data applications, Hadoop, as an offline high-throughput and low-response framework, can no longer meet such requirements, so real-time computing framework Micro-batch or stream processing to reduce data latency to ensure that data can be presented to users efficiently. [0003] When using the real-time computing framework to process data, the specific implementation is to first store the external data in the message queue, use the real-time framework to consume the data under the corresponding topic in real time and process the business logic, so as to reduce the data delay. [0004] The inventor finds in the process of realizing the prese...

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/2455G06F16/22G06F16/27G06F16/28
CPCG06F16/24568G06F16/2282G06F16/24552G06F16/284G06F16/27Y02D10/00
Inventor 马明辉王彬宋建锋张翼
Owner 北京亿欧网盟科技有限公司
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