Systems and methods for caching of sql responses using integrated caching

Patent metadata

Field	Value
Publication number	US-2016110416-A1
Application number	US-201514978830-A
Country	US
Kind code	A1
Filing date	Dec 22, 2015
Priority date	Apr 6, 2013
Publication date	Apr 21, 2016
Grant date	—

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.

First claim

What is claimed is:

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; 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 a 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; 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 a 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.

Assignees

• Citrix Systems Inc

Inventors

• Sharma Shaleen
• Sah Sudish
• Joshi Rajesh

Classifications

• G06F16/24539 Primary

  using cached or materialised query results · CPC title

• G06F16/172

  Caching, prefetching or hoarding of files · CPC title

• G06F17/30132

  Physics · mapped topic

• G06F17/30457 Primary

  Physics · mapped topic