Intelligent data delivery and storage based on data characteristics

• US 9,047,288 B2
• Filed: 01/06/2012
• Issued: 06/02/2015
• Est. Priority Date: 01/06/2012
• Status: Active Grant

• Current Assignee: Apple Inc.
• Original Assignee: Apple Inc.
• Inventors: Zaydman, Oleg, Wang, Hui Carl
• Primary Examiner(s): TRUONG, LAN DAI T
• Application Number:
  US13/345,603
• Publication Number:
  US 20130179542A1
• Time in Patent Office: 1,243 Days
• Field of Search: 709/219, 709/201, 709/202, 709/203, 709/238
• US Class Current: 1/1
• CPC Class Codes: G06F 16/40 of multimedia data, e.g. slideshows comprising image and additional audio data retrieval of still image data G06F16/50; retrieval of audio data G06F16/60; retrieval of video data G06F16/70
• CPC Class Codes: G06F 16/48 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 16/957 Browsing optimisation, e.g. caching or content distillation
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 67/06 specially adapted for file transfer, e.g. file transfer protocol [FTP]
• CPC Class Codes: H04L 69/18 Multiprotocol handlers, e.g. single devices capable of handling multiple protocols

Abstract

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.

Claims

1. A method comprising:

receiving, by a database server and from a user device, a request for data, the data being stored in a database;

determining a data size of the requested data;

identifying, based on the data size, and from a plurality of candidate data delivery protocols for responding to the request, a data delivery protocol designated for delivering data having the data size, wherein identifying the data delivery protocol comprises;

determining, from a plurality of pre-stored filter parameter sets and using an identifier of the database, a filter parameter set, the filter parameter set being associated with the identifier of the database and specifying a first data delivery protocol, a second data delivery protocol, and a data size condition, the data size condition specifying that the first data delivery protocol is to be used to deliver the data when the data size does not satisfy a threshold, and that the second data delivery protocol is to be used to deliver the data when the data size does satisfy the threshold; and

identifying one of the first data delivery protocol or the second delivery protocol for delivering the data by applying the data size condition of the filter parameter set to the data size; and

delivering the data to the user device in response to the request using the identified data delivery protocol.

2. The method of claim 1, comprising determining a data type of the requested data, wherein identifying the data delivery protocol is further based on the data type.

3. The method of claim 2, wherein determining the data type comprises determining that the requested data have a container data type, the container data type being a data type for a database table column designated for multimedia data or data objects.

4. The method of claim 2, wherein delivering the data comprises:

delivering the data through a first connection when the first data delivery protocol is identified;

or

delivering the data through a second connection when the second data delivery protocol is identified.

5. The method of claim 4, wherein:

the first connection is a database connection between the user device and the database server, and

the second connection is a hypertext transfer protocol (HTTP) connection between the user device and an HTTP server.

6. The method of claim 5, comprising, upon determining that the data size satisfies the threshold:

sending, from the database server to the user device, an address of the HTTP server.

7. The method of claim 5, wherein delivering the data comprises:

delivering the data to the user device using an HTTP streaming protocol through the HTTP connection between the user device and the HTTP server.

8. A non-transitory storage device storing computer instructions configured to cause one or more computers to perform operations comprising:

receiving, by a database server and from a user device, a request for data, the data being stored in a database;

determining a data size of the requested data;

identifying, based on the data size, and from a plurality of candidate data delivery protocols for responding to the request, a data delivery protocol designated for delivering data having the data size, wherein identifying the data delivery protocol comprises;

determining, from a plurality of pre-stored filter parameter sets and using an identifier of the database, a filter parameter set, the filter parameter set being associated with the identifier of the database and specifying a first data delivery protocol, a second data delivery protocol, and a data size condition, the data size condition specifying that the first data delivery protocol is to be used to deliver the data when the data size does not satisfy a threshold, and that the second data delivery protocol is to be used to deliver the data when the data size does satisfy the threshold; and

identifying one of the first data delivery protocol or the second delivery protocol for delivering the data by applying the data size condition of the filter parameter set to the data size; and

delivering the data to the user device in response to the request using the identified data delivery protocol.

9. The non-transitory storage device of claim 8, the operations comprising determining a data type of the requested data, wherein identifying the data delivery protocol is further based on the data type.

10. The non-transitory storage device of claim 9, wherein determining the data type comprises determining that the requested data have a container data type, the container data type being a data type for a database table column designated for multimedia data or data objects.

11. The non-transitory storage device of claim 9, wherein delivering the data comprises:

delivering the data through a first connection when the first data delivery protocol is identified;

or

delivering the data through a second connection when the second data delivery protocol is identified.

12. The non-transitory storage device of claim 11, wherein:

the first connection is a database connection between the user device and the database server, and

the second connection is a hypertext transfer protocol (HTTP) connection between the user device and an HTTP server.

13. The non-transitory storage device of claim 12, the operations comprising, upon determining that the data size satisfies the threshold:

sending, from the database server to the user device, an address of the HTTP server.

14. The non-transitory storage device of claim 12, wherein delivering the data comprises:

delivering the data to the user device using an HTTP streaming protocol through the HTTP connection between the user device and the HTTP server.

15. A system comprising:

one or more computers configured to perform operations comprising;

receiving, by a database server and from a user device, a request for data, the data being stored in a database;

determining a data size of the requested data;

identifying, based on the data size, and from a plurality of candidate data delivery protocols for responding to the request, a data delivery protocol designated for delivering data having the data size, wherein identifying the data delivery protocol comprises;

determining, from a plurality of pre-stored filter parameter sets and using an identifier of the database, a filter parameter set, the filter parameter set being associated with the identifier of the database and specifying a first data delivery protocol, a second data delivery protocol, and a data size condition, the data size condition specifying that the first data delivery protocol is to be used to deliver the data when the data size does not satisfy a threshold, and that the second data delivery protocol is to be used to deliver the data when the data size does satisfy the threshold; and

identifying one of the first data delivery protocol or the second delivery protocol for delivering the data by applying the data size condition of the filter parameter set to the data size; and

delivering the data to the user device in response to the request using the identified data delivery protocol.

16. The system of claim 15, the operations comprising determining a data type of the requested data, wherein identifying the data delivery protocol is further based on the data type.

17. The system of claim 16, wherein determining the data type comprises determining that the requested data have a container data type, the container data type being a data type for a database table column designated for multimedia data or data objects.

18. The system of claim 16, wherein delivering the data comprises:

delivering the data through a first connection when the first data delivery protocol is identified;

or

delivering the data through a second connection when the second data delivery protocol is identified.

19. The system of claim 18, wherein:

the first connection is a database connection between the user device and the database server, and

the second connection is a hypertext transfer protocol (HTTP) connection between the user device and an HTTP server.

20. The system of claim 19, the operations comprising, upon determining that the data size satisfies the threshold:

sending, from the database server to the user device, an address of the HTTP server.

21. The system of claim 19, wherein delivering the data comprises:

delivering the data to the user device using an HTTP streaming protocol through the HTTP connection between the user device and the HTTP server.