System, Method and Program Instructions for Tying Together a Media URL and Multimedia in a Database

• US 20150095362A1
• Filed: 10/01/2014
• Published: 04/02/2015
• Est. Priority Date: 10/01/2013
• Status: Active Grant

• Current Assignee: Asteriondb, Inc
• Original Assignee: Asteriondb, Inc
• Inventors: Guilford, Steven
• Granted Patent: US 9,740,779 B2
• Time in Patent Office: Days
• US Class Current: 707/758
• CPC Class Codes: G06F 16/2219 Large Object storage; Management thereof
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 16/9538 Presentation of query results
• CPC Class Codes: G06F 16/9558 Details of hyperlinks; Management of linked annotations
• CPC Class Codes: G06F 16/9566 URL specific, e.g. using aliases, detecting broken or misspelled links
• CPC Class Codes: G06F 16/957 Browsing optimisation, e.g. caching or content distillation
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06F 40/226 Validation
• CPC Class Codes: H04L 65/60 Network streaming of media packets
• CPC Class Codes: H04L 65/612 for unicast
• CPC Class Codes: H04L 65/756 adapting media to device capabilities
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04N 21/2393 involving handling client requests scheduling or organising the servicing of application requests H04L67/60
• CPC Class Codes: H04N 21/47202 for requesting content on demand, e.g. video on demand
• CPC Class Codes: H04N 21/6175 involving transmission via Internet broadcast-related systems characterised by the transmission system being the Internet H04H60/82
• CPC Class Codes: H04N 21/6581 Reference data, e.g. a movie identifier for ordering a movie or a product identifier in a home shopping application
• CPC Class Codes: H04N 21/6582 Data stored in the client, e.g. viewing habits, hardware capabilities, credit card number arrangements where receivers interact with the broadcast H04H20/38

Abstract

Systems, methods and program instructions are described for calling a database function with a URL. Many databases have functions, also referred to as logical elements, built into the database that can be called to retrieve data. A web URL can be used to call such a programming function by formatting the URL in a specific manner. A URL and dynamic values from the client are received. The URL can be parsed to determine the resource path and parameters, if any exist. The database function specified in the URL is called using the specified parameters, if any exist, and using the dynamic values from the client. The results can be streamed to the user.

Claims

1. A method comprising:

Receiving from a web client a URL request for media data;

Receiving from a web client dynamic values specific to the client;

Parsing the URL to determine the function and, if they exist, parameters;

Making a call to the database function specified in the URL and, if they exist, with parameters specified in the URL and with the dynamic client values;

Streaming the retrieved media data to the web client.

2. The method of claim 1 further comprising:

After parsing the URL, validating the function to determine that it is a logical element within the database;

And if not a valid logical element, returning an error to the user.

3. The method of claim 1, wherein the parameters specified in the URL are singular values and are assigned to the function parameters in sequence

4. The method of claim 1, wherein the parameters specified in the URL are designated by a key and the values are assigned to the function parameters matching the key

5. The method of claim 1, wherein if the returned value is contained in a collection of datatypes, the first BLOB will be used for the return value.

6. The method of claim 1, wherein if the returned value is contained in a collection of datatypes, a parameter indicates which BLOB will be used for the return value.

7. A system comprising at least one processor, the at least one processor configured to cause the system to at least perform:

Receiving from a web client a URL request for media data;

Receiving from a web client dynamic values specific to the client;

Parsing the URL to determine the function and, if they exist, parameters;

Making a call to the database function specified in the URL and, if they exist, with parameters specified in the URL and with the dynamic client values;

Streaming the retrieved media data to the web client.

8. The system of claim 7, wherein the at least one processor is configured to cause the system to further perform:

After parsing the URL, validating the function to determine that it is a logical element within the database;

And if not a valid logical element, returning an error to the user.

9. The system of claim 7, wherein the parameters specified in the URL are singular values and are assigned to the function parameters in sequence

10. The system of claim 7, wherein the parameters specified in the URL are designated by a key and the values are assigned to the function parameters matching the key

11. The system of claim 7, wherein if the returned value is contained in a collection of datatypes, the first BLOB will be used for the return value.

12. The system of claim 7, wherein if the returned value contained in a collection datatypes, a parameter indicates which BLOB will be used for the return value.

13. A computer-readable medium for use in a computer system and holding computer-executable instructions comprising:

Receiving from a web client a URL request for media data;

Receiving from a web client dynamic values specific to the client;

Parsing the URL to determine the function and, if they exist, parameters;

Making a call to the database function specified in the URL and, if they exist, with parameters specified in the URL and with the dynamic client values;

Streaming the retrieved media data to the web client.

14. The computer readable medium of claim 13 further comprising:

After parsing the URL, validating the function to determine that it is a logical element within the database;

And if not a valid logical element, returning an error to the user.

15. The computer readable medium of claim 13, wherein the parameters specified in the URL are singular values and are assigned to the function parameters in sequence

16. The computer readable medium of claim 13, wherein the parameters specified in the URL are designated by a key and the values are assigned to the function parameters matching the key

17. The computer readable medium of claim 13, wherein if the returned value is contained in a collection of datatypes, the first BLOB will be used for the return value.

18. The computer readable medium of claim 13, wherein if the returned value is contained in a collection of datatypes, a parameter indicates which BLOB will be used for the return value.