Invention Application
- Patent Title: Preserving a Query Plan Cache
- Patent Title (中): 保留查询计划缓存
-
Application No.: US11870118Application Date: 2007-10-10
-
Publication No.: US20090100114A1Publication Date: 2009-04-16
- Inventor: Robert Joseph Bestgen , Shantan Kethireddy , John Matthew Santosuosso
- Applicant: Robert Joseph Bestgen , Shantan Kethireddy , John Matthew Santosuosso
- Main IPC: G06F17/30
- IPC: G06F17/30

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.
Public/Granted literature
- US07831569B2 Preserving a query plan cache Public/Granted day:2010-11-09
Information query