- 专利标题: DYNAMIC OPTIMIZATION OF PREPARED STATEMENTS IN A STATEMENT POOL
-
申请号: US11870189申请日: 2007-10-10
-
公开(公告)号: US20080028382A1公开(公告)日: 2008-01-31
- 发明人: Jeremy Arnold , Eric Barsness , Richard Dettinger , John Santosuosso
- 申请人: Jeremy Arnold , Eric Barsness , Richard Dettinger , John Santosuosso
- 申请人地址: US NY Armonk
- 专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人地址: US NY Armonk
- 主分类号: G06F9/45
- IPC分类号: G06F9/45
摘要:
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.
公开/授权文献
信息查询