Client-Side Statement Cache
First Claim
1. A method of providing instructions from a database client to a database server, comprising:
- receiving, from a database server, a representation of a first instruction and an associated identifier;
storing the representation of the first instruction and the associated identifier in a cache;
receiving a second instruction from an application;
matching the representation of the first instruction and the second instruction;
retrieving the associated identifier from the cache based on the matching; and
sending the associated identifier to the database server, wherein, upon receiving the associated identifier the database server executes the first instruction.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments include a method, apparatus and computer program product for providing instructions from a database client to a database server. The method includes the steps of receiving from a database a representation of a first instruction and an associated identifier. The representation of the first instruction and the associated identifier are stored in a cache. A second instruction, from an application, is matched with the representation of the first instruction stored in the cache. The associated identifier is retrieved from the cache based on the matching and the associated identifier is sent to the database server. Upon receipt of the associated identifier, the database server executes the first instruction.
-
Citations
21 Claims
-
1. A method of providing instructions from a database client to a database server, comprising:
-
receiving, from a database server, a representation of a first instruction and an associated identifier; storing the representation of the first instruction and the associated identifier in a cache; receiving a second instruction from an application; matching the representation of the first instruction and the second instruction; retrieving the associated identifier from the cache based on the matching; and sending the associated identifier to the database server, wherein, upon receiving the associated identifier the database server executes the first instruction. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. An apparatus in a database client, comprising:
-
a cache controller configured to receive from a database server a representation of a first instruction and an associated identifier, wherein the cache controller is further configured to store the representation of the first instruction and the associated identifier in a cache; an application interface coupled to an application, wherein the application interface is configured to receive a second instruction from the application; a matcher configured to match the representation of the first instruction to the received second instruction; an identifier retriever configured to retrieve an identifier from the cache based on a result from the matcher; and a database interface configured to send the identifier to the database, wherein upon receipt of the identifier, the database server is configured to execute the first instruction. - View Dependent Claims (11, 12, 13, 14, 15, 16)
-
-
17. A method of executing database instructions, comprising:
-
processing a database instruction to create a processed version of the database instruction; assigning an identifier to the processed version of the database instruction; storing the identifier and the processed version of the database instruction; sending the identifier and a representation of the processed version of the database instruction to a cache on a database client; receiving a value that corresponds to the identifier from the database client; and wherein, based on the received identifier, a database server executes the processed version of the database instruction. - View Dependent Claims (18, 19, 20)
-
-
21. A computer-readable medium having computer-executable instructions stored thereon that, when executed by a computing device, cause the computing device to perform instructions, the instructions comprising:
-
receiving, from a database server, a representation of a first instruction and an associated identifier; storing the representation of the first instruction and the associated identifier in a cache; receiving a second instruction from an application; matching the representation of the first instruction and the second instruction; retrieving the associated identifier from the cache based on the matching; and sending the associated identifier to the database server, wherein, upon receiving the identifier the database server executes the first instruction.
-
Specification