Database Table Storage for Video Authorization Subsets
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Video delivery services face inefficiencies in determining user access to videos due to the exponential increase in possible authorization package combinations as new packages are added, leading to longer generation times and increased storage needs.
Innovation Solution
Generating a subset of possible authorization package combinations for video entities and storing them in a database table, with a query mechanism to determine user access without storing all combinations, using bitwise arithmetic to filter relevant package groups.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Speed
If every single possible combination of authorization packages is generated and stored, then the fastest determination of user video access is achieved, but the storage space requirement increases exponentially and regeneration time increases significantly
Solution Approach 1:
The patent extracts only the necessary subset of authorization package combinations from the complete set of possible combinations. Instead of storing all 2^N combinations, the system identifies and stores only those combinations that are actually needed for current authorization decisions, significantly reducing storage requirements while maintaining fast lookup capability for relevant cases
Solution Approach 2:
The system performs partial action by generating and storing only a portion of the total possible combinations rather than all combinations. This partial set is sufficient to determine user access for current needs, avoiding the excessive storage and processing requirements of generating the complete combination space
2Speed
If every single possible combination of authorization packages is generated and stored, then the fastest determination of user video access is achieved, but the time to generate combinations increases as the number of packages increases
Solution Approach 1:
The system extracts only the essential combinations needed for current authorization decisions, avoiding the time-consuming generation of unnecessary combinations. This selective approach maintains fast access determination while significantly reducing the time required to generate and update the combination set
Solution Approach 2:
The system performs partial action by generating only the necessary subset of combinations rather than the complete set. This reduces the computational burden and time required for combination generation while still providing sufficiently fast access determination for user authorization
3Adaptability or versatility
If a large number of authorization packages are supported, then service versatility is improved, but the number of possible combinations doubles with each new package leading to increased complexity
Solution Approach 1:
The system extracts only the relevant combinations from the exponentially growing set of possible combinations. This allows the service to support a large variety of authorization packages while managing complexity by focusing only on the combinations that are actually needed for current authorization decisions
Solution Approach 2:
The patent segments the complete set of possible combinations into a manageable subset that is actually required for service operation. This segmentation approach allows the system to support diverse authorization packages while reducing complexity by dividing the problem into essential and non-essential portions
Data Source
AI summary
Particular embodiments generate a database table that keeps track of authorization package combinations for videos being offered by a video delivery service. The table may allow the video delivery service to keep track of how much content is available for a specific authorization package combination that a user might have access to In one embodiment, the video delivery service does not pre-generate every single possible authorization package combination on a per-show basis. Rather, only a subset of the authorization package combinations is generated for each show. Then, the video delivery service uses a query to the database table that can calculate which content a user is authorized to access from the subset of authorization package combinations that were generated.