URL-Based Database Media Streaming via Function Parsing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database systems lack an efficient method to access and stream media data using a uniform resource locator (URL), which limits user access to multimedia content stored within databases without requiring extensive knowledge of the database structure or media type.
Innovation Solution
A method is developed to tie a URL request to a function in a database that returns media data, allowing users to access and stream multimedia by parsing the URL to determine the function and parameters, validating logical elements, and assigning dynamic values from the web client, ensuring secure and consistent data retrieval.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If media data is stored in a database with structured access functions, then data security and organization are improved, but user accessibility and ease of use deteriorate due to requiring extensive knowledge of database structure
Solution Approach 1:
The patent introduces a URL as an intermediary layer between users and the database structure. The URL serves as a mediator that translates user-friendly web addresses into database function calls, eliminating the need for users to directly interact with or know the underlying database structure while maintaining secure organized access to media data
Solution Approach 2:
The patent creates a universal URL interface that can access various types of media data (images, audio, video) through a consistent web-based protocol. This multi-functional URL system allows users to access different media types without needing to understand the specific database structure or media formats, providing unified access across diverse content
2Reliability
If database functions are used to retrieve media data, then data organization and security are improved, but ease of use deteriorates due to requiring detailed knowledge of media format and database structure
Solution Approach 1:
The URL acts as an intermediary that abstracts away the complexity of database functions and media formats. Users interact with media data through simple URL-based web requests rather than directly calling database functions or understanding media format specifications, maintaining data consistency while dramatically improving ease of use
Solution Approach 2:
The patent transforms the access interface by changing parameters from technical database function calls with structured parameters to URL-based web requests with query string parameters. This parameter transformation maintains the underlying data consistency and structured retrieval while presenting a much simpler, more user-friendly interface
3Productivity
If traditional database access methods are used, then data retrieval functionality is provided, but adaptability deteriorates due to inability to provide secure generalized access across different media types
Solution Approach 1:
The patent creates a universal URL-based access system that can retrieve different types of media data (images, audio, video, etc.) through a consistent interface. This multi-functional system provides generalized access capability across diverse media types while maintaining secure database-backed retrieval functionality
Solution Approach 2:
The patent segments the media data access into separate database functions organized by media type, each accessible through dedicated URL paths. This segmentation allows the system to maintain specialized secure retrieval for each media type while providing unified access through the URL interface, enhancing both functionality and adaptability
Data Source
AI summary
Apparatus and method are provided for tying together an URL request to a function in the database which returns media data. The invention provides for apparatus that receives a URL request for BLOB data from a web client and receives dynamic values specific to the web client from the web client. The URL is parsed to determine the function in a database and, if they exist, any parameters. A call is made to the function in the database specified in the URL and, if they exist, with parameters specified in the URL and with the dynamic values from the web client. The result can be streamed to the user.