Database Server Intelligent Data Delivery Protocol Selection
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Database servers face challenges in efficiently delivering large multimedia data, leading to increased burden and delayed user access, as they are designed to handle data of varying sizes and types within a single connection, which hampers concurrent delivery of multiple media files.
Innovation Solution
Implementing intelligent data delivery techniques where the database server identifies the data size and type to select an appropriate protocol, such as HTTP streaming, to deliver multimedia data separately from the database server, allowing incremental delivery and concurrent access to multiple media files.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If the database server delivers large multimedia data through a single database connection, then the data can be delivered, but the server burden increases and concurrent delivery of multiple media files is delayed
Solution Approach 1:
The patent segments the data delivery process by separating multimedia data delivery from the database connection. Large binary data (BLOB/CLOB) is delivered through HTTP streaming via a file server, while the database connection is reserved for metadata and control operations. This segmentation allows concurrent handling of multiple media files without competing for the same database connection resources.
Solution Approach 2:
The patent introduces an intermediary mechanism where the database server returns a URL reference to the multimedia data, and a separate HTTP server handles the actual data transfer. This intermediary approach decouples the database server from the heavy data delivery task, reducing server burden and enabling concurrent access to multiple media files through parallel HTTP connections.
2Reliability
If the database server waits to deliver complete media files, then data integrity is ensured, but user access time increases
Solution Approach 1:
The patent implements preliminary action by having the database server prepare and return the URL reference to the multimedia data immediately after querying the database, without waiting for the complete file to be ready. The actual media file delivery occurs asynchronously through HTTP streaming, allowing users to access metadata instantly while the large data transfers in the background.
Solution Approach 2:
The patent enables continuity of useful action through incremental delivery of multimedia data via HTTP streaming. Instead of waiting for complete file delivery, the system continuously streams data chunks to the user device, allowing progressive rendering of media content while maintaining data integrity through proper streaming protocols and session management.
Data Source
AI summary
Methods, program products, and systems of intelligent data delivery and storage based on data characteristics are disclosed. A database server can receive, from a user device, a request for data. The database server can determine a data size and a data type of the requested data. The database server can identify, based on the data size and data type, and from multiple candidate data delivery protocols for responding to the request, a data delivery protocol designated for delivering data having the data size and data type. The database server can deliver the data to the user device in response to the request using the identified data delivery protocol.