Unified Database Query Optimization for Video Delivery Traffic
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The video delivery system experiences a spike in backend network traffic due to simultaneous queries from multiple engines during live programming events, leading to slowed processing times and delayed queries for other engines.
Innovation Solution
A transformation engine generates an online database with transformed data from separate databases, indexing user interests, entitlements, and location information in an inverted format, allowing for efficient querying and reducing network traffic spikes.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If multiple engines send queries to separate databases simultaneously during live programming events, then comprehensive data retrieval is achieved, but backend network traffic spikes and processing time increases
Solution Approach 1:
The patent combines data from multiple separate databases (user interests, entitlements, location) into a single unified online database. This consolidation allows engines to retrieve all necessary data through a single query rather than multiple separate queries, reducing network traffic and improving processing speed while maintaining data retrieval completeness.
Solution Approach 2:
The system pre-loads and stores user profile data including interests, entitlements, and location information into the online database before queries are needed. This preliminary action ensures that when live programming events occur and queries are executed, the data is already available in an optimized format, eliminating the need for simultaneous multi-database access during peak times.
2Measurement precision
If engines query multiple separate databases for user data, then accurate user profiling is achieved, but network traffic increases and other engines experience delays
Solution Approach 1:
By merging user interests, entitlements, and location data into a single online database with unified user profiles, the system maintains accurate user profiling while enabling single-database queries. This eliminates the time delays caused by sequential access to multiple separate databases while preserving the completeness and accuracy of user profile information.
3Ease of manufacture
If the system stores user data in separate indexed databases, then data organization efficiency is improved, but simultaneous access by multiple engines causes network congestion
Solution Approach 1:
The patent merges multiple separate databases into a single online database that maintains organized user profiles with all necessary attributes. This consolidation simplifies the backend network architecture by eliminating the need for multiple database services and complex inter-service communication, while preserving efficient data organization through unified indexing and profile structures.
Data Source
AI summary
In one embodiment, a method uses a notification of a programming event to determine an entity of a media program and an availability pair. The availability pair identifies an entitlement and a location combination for viewing the media program. the method queries a database using the entity and the availability pair in a query to determine a first set of user profiles associated with the entity and a second set of user profiles associated with the availability pair. The first list of user profiles and the second list of user profiles are analyzed to select at least the portion of the first set of user profiles and the second set of user profiles. Then, the method performs an action for the at least the portion of the first set of user profiles and the second set of user profiles based on an occurrence of the programming event.