System, method and program instructions for tying together a media URL and multimedia in a database

• US 9,740,779 B2
• Filed: 10/01/2014
• Issued: 08/22/2017
• Est. Priority Date: 10/01/2013
• Status: Active Grant

• Current Assignee: Asteriondb, Inc
• Original Assignee: Asteriondb, Inc
• Inventors: Guilford, Steven
• Primary Examiner(s): MOSER, BRUCE M
• Application Number:
  US14/504,409
• Publication Number:
  US 20150095362A1
• Time in Patent Office: 1,056 Days
• Field of Search: None
• 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 a URL request for BLOB data from a web client;

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

Parsing the URL to determine a database function and any parameters;

Making a call to the database function specified in the URL and with any parameters specified in the URL and with the dynamic client values;

Streaming to the web client, BLOB data returned from the database function.

2. The method of claim 1 further comprising:

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

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

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

5. The method of claim 1 further comprising:

After parsing the URL, validating the database function to determine that the database function returns either a BLOB datatype or an object that contains at least one BLOB datatype.

6. The method of claim 5, wherein if it is determined that the database function returns an object that contains at least one BLOB datatype, the first BLOB will be used for a return value;

Otherwise, if it is determined that the database function returns a BLOB datatype, the BLOB will be used for a return value.

7. The method of claim 5, wherein if it is determined that the database function returns an object that contains at least one BLOB datatype, a parameter indicates which BLOB will be used for a return value;

Otherwise, if it is determined that the database function returns a BLOB datatype, the BLOB will be used for a return value.

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

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

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

Parsing the URL to determine a database function and any parameters;

Making a call to the database function specified in the URL and with any parameters specified in the URL and with the dynamic client values;

Streaming to the web client, BLOB data returned from the database function.

9. The system of claim 8 further comprising:

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

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

11. The system of claim 8, wherein the parameters specified in the URL are designated by a key and are assigned to database function parameters matching the key.

12. The system of claim 8 further comprising:

After parsing the URL, validating the database function to determine that the database function returns either a BLOB datatype or an object that contains at least one BLOB datatype.

13. The system of claim 12, wherein if it is determined that the database function returns an object that contains at least one BLOB datatype, the first BLOB will be used for a return value;

Otherwise, if it is determined that the database function returns a BLOB datatype, the BLOB will be used for a return value.

14. The system of claim 12, wherein if it is determined that the database function returns an object that contains at least one BLOB datatype, a parameter indicates which BLOB will be used for a return value;

Otherwise, if it is determined that the database function returns a BLOB datatype, the BLOB will be used for a return value.

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

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

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

Parsing the URL to determine a database function and any parameters;

Making a call to the database function specified in the URL and with any parameters specified in the URL and with the dynamic client values;

Streaming to the web client, BLOB data returned from the database function.

16. The non-transitory computer-readable medium of claim 15 further comprising:

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

17. The non-transitory computer-readable medium of claim 15, wherein the parameters specified in the URL are singular values and are assigned to database function parameters in sequence.

18. The non-transitory computer-readable medium of claim 15, wherein the parameters specified in the URL are designated by a key and are assigned to database function parameters matching the key.

19. The non-transitory computer-readable medium of claim 15 further comprising:

After parsing the URL, validating the database function to determine that the database function returns either a BLOB datatype or an object that contains at least one BLOB datatype.