Database Notification Field Automatic Change Dissemination
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In multi-component systems, efficiently disseminating data changes to relevant components is challenging, as existing methods require pre-identification of critical information and may lead to programming errors due to missed notifications.
Innovation Solution
A database system with nodes that include a lock state and notification field, where updates trigger notifications to affected systems, ensuring automatic dissemination of change data without requiring constant system checks or pre-identified recipients.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If a network of subscriptions is created where changing components maintain a list of components needing notification, then notification can be sent to specific components, but the system requiring change notification must be identified in advance and critical information must be identified a-priori
Solution Approach 1:
Instead of having components subscribe to specific notifications by pre-identifying critical information and maintaining subscription lists, the patent inverts the approach by having all components automatically receive notifications of any data changes. The notification system broadcasts changes to all subscribers without requiring pre-configuration of which components should be notified, thereby eliminating the complexity of subscription management while ensuring reliable notification delivery.
2Loss of information
If all critical data is identified and components send notification messages through a dispatch service, then changes can be communicated, but critical information must be identified in advance and each component must send notifications
Solution Approach 1:
The patent implements a notification system where components automatically receive change notifications without needing to actively manage subscription lists or send requests. The dispatch service automatically broadcasts notifications to all components when data changes occur, eliminating the need for components to identify critical information in advance or manage their own notification subscriptions, thus reducing notification management complexity while preventing information loss.
3Reliability
If each system frequently checks to see if a change has occurred, then changes can be detected, but system efficiency decreases due to constant checking
Solution Approach 1:
The patent implements a push-based notification system where components receive automatic feedback (notifications) when data changes occur, eliminating the need for continuous polling or frequent checking. The dispatch service sends notifications proactively to components, ensuring reliable change detection while maintaining high system efficiency by removing the overhead of constant status checks.
Data Source
AI summary
A database system comprising a node value stored in a first electronic data memory device sector. A lock state and access visa associated with the node value, such that if the visa is non-zero, the visa must be presented to access the node. A notification field associated with the node value, the notification field stored in a second electronic data memory device sector. An update processor configured to electronically retrieve and process the notification field if the node value is modified.