DYNAMIC OPTIMIZATION OF PREPARED STATEMENTS IN A STATEMENT POOL
First Claim
1. A method of managing a statement pool, the method comprising:
- accessing an unoptimized representation of a statement among a plurality of statements in a statement pool utilized by a database, wherein the unoptimized representation of the statement is a prepared statement;
generating an optimized representation of the statement from the unoptimized representation of the statement, wherein the optimized representation of the statement is a prepared statement; and
replacing the unoptimized representation of the statement with the optimized representation of the statement in the statement pool.
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.
65 Citations
23 Claims
-
1. A method of managing a statement pool, the method comprising:
-
accessing an unoptimized representation of a statement among a plurality of statements in a statement pool utilized by a database, wherein the unoptimized representation of the statement is a prepared statement;
generating an optimized representation of the statement from the unoptimized representation of the statement, wherein the optimized representation of the statement is a prepared statement; and
replacing the unoptimized representation of the statement with the optimized representation of the statement in the statement pool. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. An apparatus, comprising:
-
a processor; and
program code configured to be executed by the processor to manage a statement pool utilized by a database by accessing an unoptimized representation of statement among a plurality of statements in the statement pool, generating an optimized representation of the statement from the unoptimized representation of the statement, and replacing the unoptimized representation of the statement with the optimized representation of the statement in the statement pool, wherein each of the unoptimized and optimized representations of the statement is a prepared statement. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22)
-
-
23. A program product, comprising:
-
program code configured to be executed by the processor to manage a statement pool utilized by a database by accessing an unoptimized representation of statement among a plurality of statements in a statement pool, generating an optimized representation of the statement from the unoptimized representation of the statement, and replacing the unoptimized representation of the statement with the optimized representation of the statement in the statement pool, wherein each of the unoptimized and optimized representations of the statement is a prepared statement; and
a recordable medium bearing the program code.
-
Specification