The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jan. 26, 2010
Filed:
Oct. 10, 2007
Jeremy Alan Arnold, Rochester, MN (US);
Eric Lawrence Barsness, Pine Island, MN (US);
Richard Dean Dettinger, Rochester, MN (US);
John Matthew Santosuosso, Rochester, MN (US);
Jeremy Alan Arnold, Rochester, MN (US);
Eric Lawrence Barsness, Pine Island, MN (US);
Richard Dean Dettinger, Rochester, MN (US);
John Matthew Santosuosso, Rochester, MN (US);
International Business Machines Corporation, Armonk, NY (US);
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.