Query access plan rebuilds

Details Query access plan rebuilds Query access plan rebuilds

2006-11-07

2006-11-07

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07133861

ABSTRACT:
A method, apparatus and system that in an embodiment detect that a trigger exists, where the trigger indicates a potential need to rebuild a saved query access plan, and determine whether a previous job associated with the trigger created a new access plan that was identical to the saved access plan. If a previous job associated with the trigger has already created the new access plan and found that it was identical to the saved access plan, then the query is performed with the saved access plan, since there is no advantage to be gained by creating the new access plan again. In this way, multiple jobs are kept from repeatedly re-creating an access plan that is identical to one that already exists.

REFERENCES:
patent: 5778364 (1998-07-01), Nelson
patent: 6366901 (2002-04-01), Ellis
patent: 6466931 (2002-10-01), Attaluri et al.
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 6615203 (2003-09-01), Lin et al.
patent: 6711560 (2004-03-01), Levy et al.
patent: 6732084 (2004-05-01), Kabra et al.
patent: 6738782 (2004-05-01), Agarwal et al.
patent: 6847978 (2005-01-01), Ellis et al.
patent: 6915290 (2005-07-01), Bestgen et al.
patent: 6917932 (2005-07-01), Chang et al.
patent: 6996556 (2006-02-01), Boger et al.
patent: 2003/0093408 (2003-05-01), Brown et al.
patent: 2004/0006561 (2004-01-01), Nica
patent: 2005/0097078 (2005-05-01), Lohman et al.
Jaideep Srivastava and Gary Elsesser disclose (1993), Optimizing Multi-Join Queries in Parallel Relational Databases, pp. 84-92.
Matthias Jarke and Jurgen Koch disclose (1984), Query Optimization in Database Systems, pp. 111-152.
R. Braumandl, M.Keidl, A. Kemper, D. Kossmann, A.Kreutz, S. Seltzsam and K.Stocker disclose (2001), ObjectGlobe: Ubiquitous query processing on the Internet, pp. 48-71.
U.S. Appl. No. 10/354,802, “Data Management System that Provides Intelligent Access Plan Caching”, Craig S. Aldrich et al., filed Jan. 30, 2003.

Affiliated with

Also associated with

Rating

Query access plan rebuilds does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query access plan rebuilds, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query access plan rebuilds will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3670459