发明授权
- 专利标题: Preserving a query plan cache
- 专利标题(中): 保留查询计划缓存
-
申请号: US11870118申请日: 2007-10-10
-
公开(公告)号: US07831569B2公开(公告)日: 2010-11-09
- 发明人: Robert Joseph Bestgen , Shantan Kethireddy , John Matthew Santosuosso
- 申请人: Robert Joseph Bestgen , Shantan Kethireddy , John Matthew Santosuosso
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理机构: Wood, Herron & Evans, LLP
- 主分类号: G06F7/00
- IPC分类号: G06F7/00
摘要:
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.
公开/授权文献
- US20090100114A1 Preserving a Query Plan Cache 公开/授权日:2009-04-16
信息查询