Systems and methods for caching of SQL responses using integrated caching

• US 10,095,739 B2
• Filed: 12/22/2015
• Issued: 10/09/2018
• Est. Priority Date: 04/06/2013
• Status: Active Grant

• Current Assignee: Citrix Systems, Inc. (Cloud Software Group)
• Original Assignee: Citrix Systems, Inc. (Cloud Software Group)
• Inventors: Sharma, Shaleen, Sah, Sudish, Joshi, Rajesh
• Primary Examiner(s): LE, HUNG D
• Application Number:
  US14/978,830
• Publication Number:
  US 20160110416A1
• Time in Patent Office: 1,022 Days
• Field of Search: None
• CPC Class Codes: G06F 16/172 Caching, prefetching or hoarding of files
• CPC Class Codes: G06F 16/24539 using cached or materialised query results

Abstract

Systems and methods of the present disclosure provide for caching, by a device intermediary to a client and a database, a result of a structured query language (SQL) query request. In some embodiments, the device intermediary to a plurality of clients and a database receives a SQL response from the database to a first SQL query request of a client of the plurality of clients. The device may maintain a cache of SQL responses from the database. The device may identify that the first SQL query request matches a rule of a policy for caching SQL responses from the database. The policy may include a cache action to take when the rule is matched. The device may perform, responsive to the policy, on the SQL response the cache action identified by the policy.

Claims

1. A method comprising:

(a) identifying, by a device intermediary to a plurality of clients and a database, a policy specifying a selector for identifying a content group of a cache of a structured query language (SQL) responses received by the device from the database in response to SQL requests, the selector used to determine a key for identifying the content group in the cache; and

(b) identifying, by the device responsive to the selector, the content group in the cache;

(c) performing, by the device responsive to the policy, a cache action of the policy on the content group of the cached identified by the selector.

2. The method of claim 1, wherein (a) further comprises using, by the device, the selector to determine the key for a hash function to calculate a value indicating where to store a SQL response in the cache.

3. The method of claim 1, wherein the content group corresponds to one or more particular objects in the database.

4. The method of claim 1, wherein the selector comprises an expression formed from a combination of portions of at least one of a SQL request from a client or an SQL response from the database.

5. The method of claim 1, wherein the expression may comprise one or more of the following:

username, database name, character set or client version.

6. The method of claim 1, wherein the expression may comprise a uniform resource locator stem and a host.

7. The method of claim 1, wherein (b) further comprising applying, by the device, the selector to an SQL response to identify the content group.

8. The method of claim 1, wherein (b) further comprising applying, by the device, the selector to an SQL request to identify the content group.

9. The method of claim 1, wherein (c) further comprises performing, by the device, the cache action to an SQL response corresponding to the content group of one of the following:

store to cache, not cache or invalidate a corresponding cache entry.

10. The method of claim 1, further comprising serving, by the device, an SQL response from the cache corresponding to the content group identified by the selector responsive to an SQL request requesting content corresponding to the content group.

11. A system comprising:

a device intermediary to a plurality of clients and a database,

a cache configured to cache structured query language (SQL) from the database,

a policy engine configured with a policy specifying a selector for identifying a content group of a cache of SQL responses received by the device from the database in response to SQL requests, wherein the selector is used to determine a key for identifying the content group in the cache;

wherein the device, responsive to the policy engine, is configured to perform a cache action of the policy on the content group of the cached identified by the selector.

12. The system of claim 11, wherein device is further configured to use the selector to determine the key for a hash function to calculate a value indicating where to store a SQL response in the cache.

13. The system of claim 11, wherein the content group corresponds to one or more particular objects in the database.

14. The system of claim 11, wherein the selector comprises an expression formed from a combination of portions of at least one of a SQL request from a client or an SQL response from the database.

15. The system of claim 11, wherein the expression may comprise one or more of the following:

username, database name, character set or client version.

16. The system of claim 11, wherein the expression may comprise a uniform resource locator stem and a host.

17. The system of claim 11, wherein the policy engine is further configured to apply the selector to an SQL response to identify the content group.

18. The system of claim 11, wherein the policy engine is further configured to apply the selector to an SQL request to identify the content group.

19. The system of claim 11, wherein the device is further configured to perform the cache action to an SQL response corresponding to the content group of one of the following:

store to cache, not cache or invalidate a corresponding cache entry.

20. The system of claim 11, wherein the device is further configured to server an SQL response from the cache corresponding to the content group identified by the selector responsive to an SQL request requesting content corresponding to the content group.