Database Record Update Feed Selection Scoring
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In cloud computing environments, conventional database management techniques make it difficult for users to track the activities of other users or receive timely and complete updates about changes in database records, leading to inefficiencies and incomplete information sharing.
Innovation Solution
The implementation of a system that allows for the tracking and publication of updates to records in a database system, enabling users to follow records and receive feed updates about changes, with features like child-to-parent services and customizable rules for selecting and displaying relevant updates in an on-demand database service environment.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If conventional database management techniques are used, then users can access and modify database records, but users cannot efficiently track the activities of other users or receive timely updates about changes in database records
Solution Approach 1:
The system pre-establishes feed subscriptions and update mechanisms when users follow records or when records are created. Update feeds are proactively generated and pushed to subscribers whenever changes occur, eliminating the need for users to manually check for updates and reducing both information loss and time loss.
2Productivity
If users manually create and send reports about their activities, then information can be shared with others, but the process is inefficient, not timely, and incomplete
Solution Approach 1:
The system automatically generates and distributes update feeds about user activities and record changes without requiring manual intervention. When a user performs an action on a record, the system self-service creates a feed update and pushes it to all subscribers, ensuring complete and timely information sharing while dramatically improving productivity.
Solution Approach 2:
The system implements a feedback mechanism where users who follow records receive automatic notifications about changes. This creates a closed-loop information flow where activity updates are continuously pushed to interested parties, ensuring completeness and timeliness without manual report creation.
3Loss of information
If all updates to associated records are published to parent record feeds, then complete information is provided, but the feed becomes cluttered and difficult to navigate
Solution Approach 1:
The system applies different quality levels of information presentation to different contexts. Individual child record updates are published with full detail on their respective feeds, while parent record feeds use selective aggregation with summary information and configurable filtering. This allows complete information to be available locally where needed while maintaining ease of operation at the parent level through controlled information density.
Solution Approach 2:
The feed system segments information by record hierarchy level and user preferences. Instead of publishing all child record updates uniformly to parent feeds, the system segments updates based on configured rules, allowing users to selectively follow specific child records or receive aggregated summaries, thus maintaining completeness while improving navigability.
4Adaptability or versatility
If customizable rules are implemented for selecting updates to publish, then information can be tailored to user needs, but the system complexity increases
Solution Approach 1:
The system implements dynamic, configurable rules for feed publication that can be adjusted without system redesign. Users and administrators can modify subscription criteria, filtering rules, and publication preferences through configurable interfaces. The underlying system architecture remains flexible enough to accommodate varying levels of customization, providing adaptability while managing complexity through modular configuration rather than hard-coded complexity.
Data Source
AI summary
Disclosed are systems, apparatus, methods, and computer readable media for selecting updates to associated records to publish on an information feed in an on-demand database service environment. In one embodiment, one or more updates associated with a data record are stored in a database. One or more criteria are applied to the one or more updates to generate a score associated with each update. The score is compared with a designated threshold. When the score is identified as meeting or exceeding the designated threshold, the one or more updates are provided as one or more candidates for publication on an information feed associated with the data record, where the information feed is capable of being displayed on a display device.