Related Table Notification System for Live Feed Data Updates

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

In networked computing systems, particularly in cloud computing, it is challenging to efficiently notify users of changes to data across related tables without overwhelming users with irrelevant information, as traditional methods often require manual intervention or rule-based systems that are cumbersome and resource-intensive.

Innovation Solution

Implementing a system that allows users to configure notifications for live feeds based on specific data changes across related tables, enabling simultaneous publication of notifications to multiple feeds associated with relevant fields, thereby ensuring timely and targeted information dissemination to interested users.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If manual intervention or rule-based systems are used to notify users of data changes, then users can be notified of changes, but the system becomes cumbersome and resource-intensive

Engineering Contradiction:
Improvenotification deliveryVSAvoidsystem complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The system automatically identifies and notifies relevant users of data changes without manual intervention. The publication module autonomously determines which live feeds should receive notifications based on the data change and table relationships, eliminating the need for manual notification management while reducing system complexity

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system pre-configures live feeds and their associations with tables and fields before data changes occur. By establishing these relationships in advance, the system can immediately notify appropriate users when changes happen, avoiding the need for complex rule-based evaluation at notification time

Inventive Principle:
Principle #10Preliminary action

2Loss of information

If notifications are sent to all users or multiple feeds, then comprehensive coverage is achieved, but users experience information overload

Engineering Contradiction:
Improveinformation completenessVSAvoidinformation overload
Core Design Contradiction:
Loss of informationVSObject-affected harmful factors

Solution Approach 1:

The system sends notifications to specific live feeds based on their local relevance to the data change. Each feed receives notifications only when changes occur in tables or fields it is associated with, ensuring that each user receives appropriate information without being overwhelmed by irrelevant updates from unrelated tables

Inventive Principle:
Principle #3Local quality

Solution Approach 2:

The notification system is segmented into multiple specialized live feeds, each monitoring specific tables or fields. This segmentation allows the system to deliver comprehensive information coverage across all feeds while keeping individual feed notifications focused and relevant to their specific domain

Inventive Principle:
Principle #1Segmentation

3Speed

If real-time notifications are published to multiple related tables, then timely information dissemination is achieved, but system resources are consumed

Engineering Contradiction:
Improvenotification speedVSAvoidsystem resource consumption
Core Design Contradiction:
SpeedVSUse of energy by moving object

Solution Approach 1:

The system publishes notifications to only those live feeds that are relevant to the specific data change, rather than broadcasting to all feeds. By taking partial action only where needed, the system achieves timely notification delivery while conserving system resources by avoiding unnecessary notification publications

Inventive Principle:
Principle #16Partial or excessive action

Data Source

PatentUS10162874B2Related table notifications
Publication Date: 2018.12.25 SERVICENOW INC
  • US10162874B2 patent drawing
  • US10162874B2 patent drawing
  • US10162874B2 patent drawing

AI summary

Systems, apparatuses, and methods for related table notifications are disclosed. Notifications are configured for at least two live feeds. Each of the live feeds is associated with a table of a plurality of tables. When data is changed within the table, the notifications are published to the live feeds as long as conditions established for the notifications are met.