Dynamic optimization of prepared statements in a statement pool
First Claim
1. A method of managing a statement pool, the method comprising:
- identifying, from among a plurality of statements in a statement pool utilized by a database, a statement that requests data in a first format from a field in the database that stores the data in a second format; and
modifying the identified statement in the statement pool using at least one processor to instruct the database to convert the data to the first format prior to returning the data; and
tracking usage of at least a subset of the plurality of statements, wherein the modifying the identified statement is performed based upon the tracked usage, wherein the tracking usage includes tracking at least one of a number of times and a last time that each of the subset of statements is used.
2 Assignments
0 Petitions
Accused Products
Abstract
An apparatus, program product and method dynamically optimize prepared statements resident in a statement pool to permit subsequent reuses of such statements to utilize the optimized representations of such statements. The optimization of pooled statements may be performed responsive to the tracked usage of the statements in a statement pool, to direct the overhead associated with such optimization to those statements that are more likely to be utilized in the future. Among a multitude of possible optimizations, a pooled statement that requests data in a format other than that utilized by the database being accessed may be modified to request the data in the format used by the database, thereby decreasing the overhead in the database associated with format conversions.
-
Citations
12 Claims
-
1. A method of managing a statement pool, the method comprising:
-
identifying, from among a plurality of statements in a statement pool utilized by a database, a statement that requests data in a first format from a field in the database that stores the data in a second format; and modifying the identified statement in the statement pool using at least one processor to instruct the database to convert the data to the first format prior to returning the data; and tracking usage of at least a subset of the plurality of statements, wherein the modifying the identified statement is performed based upon the tracked usage, wherein the tracking usage includes tracking at least one of a number of times and a last time that each of the subset of statements is used. - View Dependent Claims (2, 3, 4)
-
-
5. An apparatus, comprising:
-
a processor; and program code configured to be executed by the processor to manage a statement pool by identifying, from among a plurality of statements in a statement pool utilized by a database, a statement that requests data in a first format from a field in the database that stores the data in a second format, and modifying the identified statement in the statement pool to instruct the database to convert the data to the first format prior to returning the data, wherein the program code is further configured to track usage of at least a subset of the plurality of statements, and to modify the identified statement based upon the tracked usage, and wherein the program code is configured to track usage by tracking at least one of a number of times and a last time that each of the subset of statements is used. - View Dependent Claims (6, 7, 8)
-
-
9. A program product, the product comprising:
-
program code configured to be executed by a processor to manage a statement pool by identifying, from among a plurality of statements in a statement pool utilized by a database, a statement that requests data in a first format from a field in the database that stores the data in a second format, and modifying the identified statement in the statement pool to instruct the database to convert the data to the first format prior to returning the data; and a recordable medium storing the program code, wherein the program code is further configured to track usage of at least a subset of the plurality of statements, and to modify the identified statement based upon the tracked usage, and wherein the program code is configured to track usage by tracking at least one of a number of times and a last time that each of the subset of statements is used. - View Dependent Claims (10, 11, 12)
-
Specification