Selective automatic refreshing of stored execution plans

Details Selective automatic refreshing of stored execution plans Selective automatic refreshing of stored execution plans

2007-03-05

2010-11-09

Ehichioya, Fred I (Department: 2156)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707SE17075, C707SE17132

Reexamination Certificate

active

07831593

ABSTRACT:
A system and method for selectively recompiling stored execution plans within a database system. In one technique the execution plans include respective version numbers of database software operable within the database system during compilation of the respective plans. A request is received to execute one of the stored execution plans, and the stored execution plan is retrieved from computer memory. A version number is obtained of database software operable within the database system during retrieval of the stored execution plan. The obtained version number is compared with the version number associated with the retrieved execution plan. On detecting a mismatch between the obtained version number and the retrieved version number, the stored execution plan is recompiled. In another technique the stored execution plans include respective cost parameters representing the hardware capabilities of the system at the time of plan compilation. A set of cost parameters representing the cost of executing the stored execution plan within the database system is compared with the stored cost parameters associated with the retrieved execution plan. On detecting a significant difference between the defined cost parameters and the retrieved cost parameters, the stored execution plan is recompiled.

REFERENCES:
patent: 5572673 (1996-11-01), Shurts
patent: 5717911 (1998-02-01), Madrid et al.
patent: 6704724 (2004-03-01), Ellmann et al.
patent: 7185000 (2007-02-01), Brown et al.
patent: 7624094 (2009-11-01), Ellis et al.
patent: 2005/0097078 (2005-05-01), Lohman et al.
patent: 2006/0294058 (2006-12-01), Zabback et al.
Kabra et al., Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans, 1998, ACM, pp. 106-117.
Steve McConnell, The Basics, 1998, Microsoft Press, pp. 1-48.
Ilyas et al., Estimating Compilation Time of a Query Optimizer, 2003, ACM, pp. 373-384.
Suganuma et al., A Region-Based Compilation Technique for Dynamic Compilers, Jan. 2006, ACM, pp. 134-174.
Randy H. Katz, Performance enhancement for relational systems through query compilation, 1979, National Computer Conference, pp. 741-747.
Kalen Delaney, Tracking Recompiles, 2005, SQL Server Magazine, pp. 1-2.
Kalen Delaney, Conditional Recompile, 2005, SQL Server Magazine, pp. 1-3.
Kalen Delaney, Reusing Query Plans, 2005, SQL Server Magazine, pp. 1-2.

Affiliated with

Also associated with

Rating

Selective automatic refreshing of stored execution plans does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Selective automatic refreshing of stored execution plans, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Selective automatic refreshing of stored execution plans will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4208762