Systems and methods for caching of SQL responses using integrated caching
First Claim
1. A method for caching by a device intermediary to a client and a database a result of a structured query language (SQL) query request, the method comprising:
- (a) receiving, by a device intermediary to a plurality of clients and a database, a SQL response from the database to a first structured query language (SQL) query request of a client of the plurality of clients, the device maintaining a cache of SQL responses from the database;
(b) identifying, by the device, that the first SQL query request matches a rule of a policy for caching SQL responses from the database, the policy comprising a cache action to take on a response to a query when the rule is matched; and
(c) performing, by the device responsive to the policy, on the SQL response received from the database the cache action identified by the policy matching the first SQL query request.
7 Assignments
0 Petitions
Accused Products
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.
20 Citations
20 Claims
-
1. A method for caching by a device intermediary to a client and a database a result of a structured query language (SQL) query request, the method comprising:
-
(a) receiving, by a device intermediary to a plurality of clients and a database, a SQL response from the database to a first structured query language (SQL) query request of a client of the plurality of clients, the device maintaining a cache of SQL responses from the database; (b) identifying, by the device, that the first SQL query request matches a rule of a policy for caching SQL responses from the database, the policy comprising a cache action to take on a response to a query when the rule is matched; and (c) performing, by the device responsive to the policy, on the SQL response received from the database the cache action identified by the policy matching the first SQL query request. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A system for caching by a device intermediary to a client and a database a result of a structured query language (SQL) query request, the system comprising:
-
a device intermediary to a plurality of clients and a database; a cache of the device configured to cache SQL responses from the database; a database proxy of the device receiving an SQL response from the database to a first structured query language (SQL) query request of a client of the plurality of clients; a policy engine configured to identify that the first SQL query request matches a rule of a policy for caching SQL responses from the database, the policy comprising a cache action to take on a response to a query when the rule is matched; and wherein the device, responsive to the policy, is configured to perform on the SQL response received from the database the cache action identified by the policy matching the first SQL query request. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
-
Specification