Dynamic Feed Materialization in Social Networks

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Social networking systems face significant computational demands and storage requirements due to the time-consuming process of materializing all possible feeds, which can lead to increased latency and resource utilization when users or applications access feeds.

Innovation Solution

Implementing a dynamic materialization approach where feeds are materialized on first read, using a non-relational database system to store materialized feeds, allowing for quick access and reducing computational loads by determining the feed state and processing requests accordingly, thereby maintaining data integrity and reducing reliance on relational databases for real-time data access.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Speed

If all possible feeds are materialized in advance, then feed access speed is improved, but computational demands and storage requirements increase significantly

Engineering Contradiction:
Improvefeed access speedVSAvoidcomputational demands
Core Design Contradiction:
SpeedVSUse of energy by stationary object

Solution Approach 1:

The patent applies preliminary action by materializing feeds just before they are needed rather than in advance. The system identifies feeds that are about to be requested and pre-materializes them in the background, so when a user actually requests a feed, it is already ready for immediate delivery. This resolves the contradiction by preparing data in advance of the actual need without requiring all possible feeds to be materialized simultaneously.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent implements dynamics by making the feed materialization process adaptive and dynamic rather than static. The system continuously monitors feed access patterns, user behavior, and system resources to dynamically adjust which feeds are materialized and when. This allows the system to optimize between access speed and computational demands in real-time based on actual usage conditions.

Inventive Principle:
Principle #15Dynamics

2Reliability

If all possible feeds are materialized, then feed availability is improved, but storage requirements increase significantly

Engineering Contradiction:
Improvefeed availabilityVSAvoidstorage requirements
Core Design Contradiction:
ReliabilityVSVolume of stationary object

Solution Approach 1:

The patent applies local quality by materializing only the specific feeds that are likely to be requested by particular users or applications, rather than materializing all possible feeds uniformly. The system identifies local needs based on user profiles, access patterns, and contextual information, and materializes feeds selectively for those specific contexts. This ensures feed availability where needed while minimizing overall storage requirements.

Inventive Principle:
Principle #3Local quality

3Volume of stationary object

If feeds are materialized on demand, then storage requirements are reduced, but access latency increases

Engineering Contradiction:
Improvestorage requirementsVSAvoidaccess latency
Core Design Contradiction:
Volume of stationary objectVSLoss of time

Solution Approach 1:

The patent resolves this contradiction by performing preliminary materialization actions in the background before users actually need the feeds. The system proactively identifies feeds that will be requested soon and materializes them ahead of time, so when access is needed, the feeds are already ready. This eliminates access latency while avoiding the need to store all possible feeds permanently.

Inventive Principle:
Principle #10Preliminary action

4Reliability

If a relational database system is used for feed materialization, then data integrity is maintained, but computational complexity and processing time increase

Engineering Contradiction:
Improvedata integrityVSAvoidcomputational complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent applies segmentation by dividing the feed materialization process into separate, independent stages that can be processed differently. The system segments feeds into categories based on access patterns, importance, and resource requirements, and applies different materialization strategies to each segment. This reduces computational complexity by avoiding uniform complex processing of all feeds while maintaining data integrity for critical feeds.

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS11275806B2Dynamic materialization of feeds for enabling access of the feed in an online social network
Publication Date: 2022.03.15 SALESFORCE INC
  • US11275806B2 patent drawing
  • US11275806B2 patent drawing
  • US11275806B2 patent drawing

AI summary

Dynamic materialization of a feed is described. A request for a feed is received. A state of the feed is determined. Responsive to determining that the state is the inactive state, causing materialization of the feed in a second non-relational database system with feed items of the feed from the first relational database system, where the second database system is separate from the first database system, and setting the state of the feed to the activating state. Responsive to determining that the state is the active state, causing the request for the feed to be processed from the second non-relational database system.