×

Dynamic optimization of prepared statements in a statement pool

  • US 7,653,620 B2
  • Filed: 10/10/2007
  • Issued: 01/26/2010
  • Est. Priority Date: 05/23/2002
  • Status: Expired due to Term
First Claim
Patent Images

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;

    with at least one hardware-implemented processor, 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;

    replacing the unoptimized representation of the statement with the optimized representation of the statement in the statement pool;

    associating with the optimized representation of the statement a statement signature for the unoptimized representation of the statement; and

    accessing the optimized representation of the statement in response to a user request to access the statement having the statement signature corresponding to the unoptimized representation of the statement, wherein the generating the optimized representation of the statement includes modifying the unoptimized representation of the statement to instruct the database to convert returned data to a different format prior to returning the data, wherein the generating the optimized representation of the statement further includes determining that the unoptimized representation of the statement requests data in a first format from a field in the database that stores the data in a second format, and wherein the modifying the unoptimized representation of the statement includes modifying the unoptimized representation of the statement to instruct the database to convert the data to the first format prior to returning the data.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×