Message Queue Segmentation for Database Latency Reduction
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems face bandwidth issues and latency due to the large number of automatically triggered update messages, which overwhelm server systems and lead to inefficient message queuing.
Innovation Solution
Implementing a method to select amongst multiple processes for sending messages, allowing for the use of multiple queues to manage and prioritize message transmission, thereby preventing latency and optimizing bandwidth usage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Device complexity
If a single queue is used to manage update messages, then the system structure remains simple, but message latency increases as the number of messages grows
Solution Approach 1:
The patent divides the single message queue into multiple queues (first queue, second queue, etc.), each associated with different processes. This segmentation allows messages to be distributed across multiple processing channels, reducing latency without significantly increasing system complexity.
2Productivity
If multiple processes are used to send messages, then message processing capacity increases, but system complexity increases
Solution Approach 1:
The patent creates a universal message sending framework where multiple processes can handle multiple types of messages through a standardized interface. Each process can send messages to different queues, and the system maintains a consistent structure for message handling, reducing the complexity increase that would normally accompany multi-process architecture.
3Reliability
If automatic triggering is applied to every data change, then data update completeness is improved, but bandwidth consumption increases
Solution Approach 1:
The patent assigns different message sending processes to different queues based on specific criteria (such as message type, priority, or destination). This allows the system to optimize bandwidth usage by routing messages through appropriate processes, ensuring complete data updates while managing bandwidth consumption through selective process assignment.
Data Source
AI summary
In accordance with embodiments, there are provided mechanisms and methods for selecting amongst a plurality of processes to send a message (e.g. a message for updating an endpoint system, etc.). These mechanisms and methods for selecting amongst a plurality of processes to send a message can enable embodiments to utilize more than one queue for sending such message. The ability of embodiments to provide such multi-process feature can, in turn, prevent latency that typically accompanies a mounting number of messages.