Invention Grant
- Patent Title: Dynamic optimization of prepared statements in a statement pool
-
Application No.: US11870218Application Date: 2007-10-10
-
Publication No.: US09146974B2Publication Date: 2015-09-29
- Inventor: Jeremy Alan Arnold , Eric Lawrence Barsness , Richard Dean Dettinger , John Matthew Santosuosso
- Applicant: Jeremy Alan Arnold , Eric Lawrence Barsness , Richard Dean Dettinger , John Matthew Santosuosso
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Middleton Reutlinger
- Main IPC: G06F17/30
- IPC: G06F17/30

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.
Public/Granted literature
- US20080027999A1 DYNAMIC OPTIMIZATION OF PREPARED STATEMENTS IN A STATEMENT POOL Public/Granted day:2008-01-31
Information query