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 to instruct the database to convert the data to the first format prior to returning the data.
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.
54 Citations
18 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 to instruct the database to convert the data to the first format prior to returning the data. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. 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. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A program product, comprising:
-
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; and
a recordable medium bearing the program code. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification