Database Notification Service for Real-Time Social Network Updates

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

In cloud computing environments, conventional database management techniques make it difficult to track the activities of users or notify relevant parties about updates to records in a timely and efficient manner, leading to inefficiencies and incomplete information sharing within online social networks.

Innovation Solution

Implementing a system that generates and tracks updates to records in a database, allowing followers to automatically receive feed tracked updates, which include changes to records and actions of users, through a multi-tenant database system that integrates with online social networks to provide real-time notifications and feed generation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Speed

If conventional database management techniques are used in cloud computing environments, then system simplicity and ease of operation are maintained, but the ability to track user activities and notify relevant parties in a timely manner deteriorates

Engineering Contradiction:
Improvenotification speedVSAvoidsystem complexity
Core Design Contradiction:
SpeedVSDevice complexity

Solution Approach 1:

The patent introduces an intermediary notification service that sits between the database system and users. This service subscribes to database events, processes notifications, and delivers them to relevant parties. The intermediary handles the complexity of tracking and notification logic centrally, allowing the core database system to remain simple while achieving timely notifications through the dedicated notification infrastructure.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Loss of information

If manual reporting methods are used to share user activity information, then system complexity is minimized, but information sharing completeness and timeliness deteriorate

Engineering Contradiction:
Improveinformation completenessVSAvoidautomation level
Core Design Contradiction:
Loss of informationVSExtent of automation

Solution Approach 1:

The database system automatically generates and publishes activity information through the notification service without requiring manual intervention. Users define their subscription criteria once, and the system automatically tracks relevant activities, generates notifications, and delivers them. This self-service approach ensures complete information capture while minimizing manual reporting efforts.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The notification system establishes a feedback loop where user activities are automatically tracked and information is fed back to relevant parties in real-time. This continuous feedback mechanism ensures that information about user actions, record updates, and system events is consistently captured and communicated, eliminating information gaps associated with manual reporting.

Inventive Principle:
Principle #23Feedback

3Loss of time

If real-time notification systems are implemented to track user activities, then information sharing timeliness is improved, but system complexity and resource consumption increase

Engineering Contradiction:
Improveinformation delayVSAvoidsystem resource consumption
Core Design Contradiction:
Loss of timeVSUse of energy by moving object

Solution Approach 1:

The notification service implements partial action by selectively notifying only about specific types of events that match user-defined criteria. Rather than broadcasting all database activities to all users, the system filters and delivers only relevant notifications. This approach maintains real-time responsiveness for important events while reducing overall system resource consumption by avoiding unnecessary notification processing.

Inventive Principle:
Principle #16Partial or excessive action

4Loss of information

If comprehensive user activity tracking is implemented, then information availability is improved, but system complexity and processing overhead increase

Engineering Contradiction:
Improveinformation availabilityVSAvoidtracking system complexity
Core Design Contradiction:
Loss of informationVSDevice complexity

Solution Approach 1:

The notification system segments tracking by organizing users into groups with different subscription criteria and permissions. Rather than implementing a single comprehensive tracking mechanism for all users, the system divides tracking responsibilities into manageable segments based on user roles, data sensitivity, and notification preferences. This segmentation reduces overall system complexity while maintaining comprehensive information availability through coordinated segment tracking.

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS10715525B2Computer implemented methods and apparatus for providing access to an online social network
Publication Date: 2020.07.14 SALESFORCE INC
  • US10715525B2 patent drawing
  • US10715525B2 patent drawing
  • US10715525B2 patent drawing

AI summary

Disclosed are systems, apparatus, methods, and computer-readable storage media for providing access to an online social network. The online social network can be specific to an organization having one or more internal users. In some implementations, a request message is received from a requesting user to access social network data of the online social network. The requesting user is identified as an external user of the organization, and it is determined that the requesting user has an authorized status. Access to only a portion of the social network data is provided to the authorized requesting user.