Dynamic optimization of prepared statements in a statement pool

Details Dynamic optimization of prepared statements in a statement pool Dynamic optimization of prepared statements in a statement pool

2011-03-22

2011-03-22

Truong, Cam Y T (Department: 2169)

Data processing: database and file management or data structures

Database and file access

Record, file, and data search and comparisons

C707S769000

Reexamination Certificate

active

07912848

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.

REFERENCES:
patent: 5668987 (1997-09-01), Schneider
patent: 5701461 (1997-12-01), Dalal et al.
patent: 5765147 (1998-06-01), Mattos et al.
patent: 5857188 (1999-01-01), Douglas
patent: 5875334 (1999-02-01), Chow et al.
patent: 5940845 (1999-08-01), Prager et al.
patent: 5956706 (1999-09-01), Carey et al.
patent: 6003022 (1999-12-01), Eberhard et al.
patent: 6003050 (1999-12-01), Silver et al.
patent: 6044442 (2000-03-01), Jesionowski
patent: 6115703 (2000-09-01), Bireley et al.
patent: 6134540 (2000-10-01), Carey et al.
patent: 6182133 (2001-01-01), Horvitz
patent: 6195653 (2001-02-01), Bleizeffer et al.
patent: 6199063 (2001-03-01), Colby et al.
patent: 6233578 (2001-05-01), Machihara et al.
patent: 6236997 (2001-05-01), Bodamer et al.
patent: 6266658 (2001-07-01), Adya et al.
patent: 6275820 (2001-08-01), Navin-Chandra et al.
patent: 6363371 (2002-03-01), Chaudhuri et al.
patent: 6366901 (2002-04-01), Ellis
patent: 6370522 (2002-04-01), Agarwal et al.
patent: 6411951 (2002-06-01), Galindo-Legaria et al.
patent: 6438537 (2002-08-01), Netz et al.
patent: 6496843 (2002-12-01), Getchius et al.
patent: 6519604 (2003-02-01), Acharya et al.
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 6546382 (2003-04-01), Amor et al.
patent: 6601073 (2003-07-01), Robare
patent: 6629094 (2003-09-01), Colby et al.
patent: 6678674 (2004-01-01), Saeki
patent: 6718320 (2004-04-01), Subramanian et al.
patent: 6728720 (2004-04-01), Lenzie
patent: 6732360 (2004-05-01), Seo et al.
patent: 6772411 (2004-08-01), Hayes et al.
patent: 6795817 (2004-09-01), Agarwal et al.
patent: 6795826 (2004-09-01), Flinn et al.
patent: 6801914 (2004-10-01), Barga et al.
patent: 6879990 (2005-04-01), Boyer et al.
patent: 6901582 (2005-05-01), Harrison
patent: 6941451 (2005-09-01), Rudy et al.
patent: 7058622 (2006-06-01), Tedesco
patent: 7096219 (2006-08-01), Karch
patent: 7127463 (2006-10-01), Arnold et al.
patent: 7185001 (2007-02-01), Burdick et al.
patent: 7272589 (2007-09-01), Guay et al.
patent: 2001/0029542 (2001-10-01), Nishimura
patent: 2002/0007384 (2002-01-01), Ushioda et al.
patent: 2002/0091712 (2002-07-01), Martin et al.
patent: 2003/0110153 (2003-06-01), Shee
patent: 2003/0126232 (2003-07-01), Mogul et al.
patent: 2004/0205062 (2004-10-01), Brown et al.
patent: 2004/0205065 (2004-10-01), Petras et al.
Oracle8i Designing and Tuning for Performance, 2000, pp. 1-36.
Bernstein et al., “Context-Based Prefetch for Implementing Objects on Relations,” Proceedings of the 25th VLDB Conference Edinburgh, Scotland, 1999.
Palmer et al., “Fido: A cache that learns to fetch,”Proceedings of the 17th International Conference on VLDB, Sep. 1991.
J. Heidebrecht, “developerWorks : Java™ Technology : What's new in JDBC 3.0”, http://www-106.ibm.com/developerworks/library/j-jdbcnew/index.html, Jul. 25, 2001.

Affiliated with

Also associated with

Rating

Dynamic optimization of prepared statements in a statement pool does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Dynamic optimization of prepared statements in a statement pool, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamic optimization of prepared statements in a statement pool will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2756396