Database Event Transmission via Multicast Datagram
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database systems face challenges in efficiently transmitting information about events, such as insert, delete, or update operations, across a network to multiple recipients, particularly for users or applications that are not capable of using platform-specific messaging systems like Java Messaging System (JMS).
Innovation Solution
The method involves preparing datagram packets containing event information from database triggers and sending them to a multicast group over a network, allowing any program or system to receive and process these packets, ensuring statelessness and broad compatibility.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If platform-specific messaging systems like JMS are used to transmit database event information, then the information can be sent to subscribed systems, but only systems capable of employing such messaging systems can send and receive information
Solution Approach 1:
The patent introduces a mediator component that translates database event information into a universal format that can be transmitted over standard network protocols. This intermediary layer enables systems without JMS capabilities to receive and process database events by converting the information into a compatible format for transmission and reception across heterogeneous systems.
2Speed
If triggers are used to send messages about database events, then real-time information can be transmitted, but the system requires specific messaging infrastructure and platform capabilities
Solution Approach 1:
The patent extracts the messaging infrastructure requirement from the trigger mechanism by separating the event detection function from the transmission function. The trigger detects the database event and passes the information to a transmission component that uses standard network protocols instead of requiring a full messaging system, thereby maintaining real-time transmission while reducing infrastructure complexity.
3Loss of information
If history tables are polled to obtain database changes, then information about events can be retrieved, but the system requires continuous polling which consumes resources and time
Solution Approach 1:
The patent applies preliminary action by having the trigger mechanism prepare and transmit event information immediately when a database change occurs, rather than waiting for polling cycles. This proactive transmission ensures that event information is available to subscribers without requiring continuous polling, reducing both time loss and resource consumption while maintaining complete event information retrieval.
Data Source
AI summary
A method for sending information regarding an event in a critical table in a database. A receiver receives information regarding an event from a trigger corresponding to the event. The event may be one of an insert row, delete row or update row. Thereafter, a processor prepares one or more datagram packets containing the information regarding the event. Then, an event dispatcher sends the one or more datagram packets to a multicast group over a network. Finally, the multicast group forwards the datagram packets to a destination host device subscribed to the multicast group, without storing the datagram packets.