Client-Side Statement Cache

• US 20120158770A1
• Filed: 12/16/2010
• Published: 06/21/2012
• Est. Priority Date: 12/16/2010
• Status: Active Grant

• Current Assignee: Sybase Incorporated (SAP SE)
• Original Assignee: Sybase Incorporated (SAP SE)
• Inventors: SCHNEIDER, Peter, BENADJAOUD, Ghazi Nourdine
• Granted Patent: US 8,832,143 B2
• Time in Patent Office: Days
• US Class Current: 707/769
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/24539 using cached or materialised query results
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising

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.

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.

2. The method of claim 1, wherein the first instruction is dynamic structured query language (Dynamic SQL) and the second instruction is embedded SQL.

3. The method of claim 1,

wherein the second instruction has a parameter, and

wherein the sending the associated identifier to the database server comprises sending the associated identifier and the parameter to the database server,

wherein, upon receiving the identifier and the parameter, the database server executes the first instruction using the parameter.

4. The method of claim 1, wherein the cache is a client-side statement cache.

5. The method of claim 1, wherein the storing of the representation of the first instruction in a cache comprises:

storing the representation in both a memory and in a file, wherein upon next starting of the database client the memory is loaded from the file.

6. The method of claim 1, wherein each application that uses the database client has a different identifier associated with the first instruction.

7. The method of claim 1, wherein each application that uses the database client has the same identifier associated with the first instruction.

8. The method of claim 1, before the receiving a representation of a first instruction from a database server, further comprising:

receiving a plurality of instructions from the application, wherein one of the plurality of instructions is the second instruction;

sending the plurality of instructions to the database server, wherein the database server analyzes the plurality of instructions, and

wherein the receiving of the representation of a first instruction from a database server is based on the analyzing by the database server.

9. The method of claim 1, wherein the first instruction is a processed version of the second instruction.

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.

11. The apparatus of claim 10, wherein the first instruction is dynamic structured query language (Dynamic SQL) and the second instruction is embedded SQL.

12. The apparatus of claim 10, wherein the second instruction has a literal value, further comprising:

a paramatizer configured to generate a parameter by identifying and parameterizing the literal value in the second instruction;

wherein the sending of the identifier to the database server comprises sending the identifier and the parameter to the database server, and

wherein, upon receiving the identifier and the parameter, the database server executes the first instruction using the parameter.

13. The apparatus of claim 10, wherein the cache is a client-side statement cache.

14. The apparatus of claim 10, wherein the storing of the representation of the first instruction in a cache comprises:

storing the representation in both a memory and in a file, wherein upon next starting of the database client the memory is loaded from the file.

15. The apparatus of claim 10, wherein each application that uses the database client has a different identifier associated with the first instruction.

16. The apparatus of claim 10, wherein each application that uses the database client has the same identifier associated with the first instruction.

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.

18. The method of claim 17, before the assigning of the identifier to the processed instruction, further comprising

analyzing a database instruction received from a database client;

and

determining whether to create the processed version of the database instruction based on the analyzing.

19. The method of claim 17, after the receiving the value that corresponds to the identifier from the database client, further comprising:

receiving a parameter,

wherein the processed version of the database instruction is a parameterized version of the database instruction, and

wherein the executing of the processed version of the database instruction is based on the received identifier and the received parameter.

20. The method of claim 17, wherein the processed version of the database instruction is dynamic SQL (DSQL).

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.