Preserving a query plan cache

Details Preserving a query plan cache Preserving a query plan cache

2007-10-10

2010-11-09

LeRoux, Etienne P (Department: 2166)

Data processing: database and file management or data structures

File or database maintenance

Database recovery

C707S601000, C707S610000, C707S616000, C707S618000, C707S624000, C707S634000, C707S637000, C707S641000, C707S649000, C707S650000, C707S670000, C707S678000, C707S686000

Reexamination Certificate

active

07831569

ABSTRACT:
A method, apparatus, and program product are provided for preserving a query plan cache on a backup system having a dataspace containing a copy of data and a copy of a query plan cache from a production system. An update is initiated of at least a portion of the copy of the data on the backup system with a portion of the data on the production system. A merge is initiated of updated query plans in the query plan cache from the production system with corresponding query plans in the copy of the query plan cache on the backup system. Objects are correlated in the updated query plans in the copy of the query plan cache with the updated copy of the data on the backup system.

REFERENCES:
patent: 6269431 (2001-07-01), Dunham
patent: 6353833 (2002-03-01), Bird et al.
patent: 6466931 (2002-10-01), Attaluri et al.
patent: 6957435 (2005-10-01), Armstrong et al.
patent: 7051174 (2006-05-01), Ash et al.
patent: 7133861 (2006-11-01), Day et al.
patent: 2003/0065644 (2003-04-01), Horman et al.
patent: 2004/0087300 (2004-05-01), Lewis
patent: 2004/0243799 (2004-12-01), Hacigumus et al.
patent: 2005/0028134 (2005-02-01), Zane et al.
patent: 2005/0097078 (2005-05-01), Lohman et al.
patent: 2005/0131878 (2005-06-01), Chen et al.
patent: 2005/0131879 (2005-06-01), Ghosh et al.
patent: 2005/0149505 (2005-07-01), Bossman et al.
patent: 2005/0234900 (2005-10-01), Bossman et al.
patent: 2005/0267877 (2005-12-01), Chaudhuri et al.
patent: 2006/0195416 (2006-08-01), Ewen et al.
patent: 2006/0230016 (2006-10-01), Cunningham et al.
patent: 2007/0078825 (2007-04-01), Bornhoevd et al.
patent: 2008/0133458 (2008-06-01), Zabback et al.
Bonnet, Philippe et al., “Partial Answers for Unavailable Data Sources” (12 pages), 1998.
Raman, Vijayshankar et al., “Progressive Optimization in Action,” 2004 (4 pages).
U.S. Patent and Trademark Office, Office Action issued in related U.S. Appl. No. 11/735,095, dated Aug. 21, 2009.
U.S. Patent and Trademark Office, Final Office Action issued in related U.S. Appl. No. 11/735,095, dated Mar. 31, 2010.
U.S. Patent and Trademark Office, Office Action issued in related U.S. Appl. No. 11/735,133, dated Apr. 30, 2009.
U.S. Patent and Trademark Office, Office Action issued in related U.S. Appl. No. 11/735,133, dated Nov. 25, 2009.
U.S. Patent and Trademark Office, Final Office Action issued in related U.S. Appl. No. 11/735,133, dated Jun. 9, 2010.

Affiliated with

Also associated with

Rating

Preserving a query plan cache does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4244494