发明申请
US20100036803A1 ADAPTIVE FILTER INDEX FOR DETERMINING QUERIES AFFECTED BY A DML OPERATION
有权
用于确定DML操作影响的自适应滤波器索引
- 专利标题: ADAPTIVE FILTER INDEX FOR DETERMINING QUERIES AFFECTED BY A DML OPERATION
- 专利标题(中): 用于确定DML操作影响的自适应滤波器索引
-
申请号: US12326822申请日: 2008-12-02
-
公开(公告)号: US20100036803A1公开(公告)日: 2010-02-11
- 发明人: Srinivas S. Vemuri , Atrayee Mullick , Bipul Sinha , Amit Ganesh , Dieter Gawlick
- 申请人: Srinivas S. Vemuri , Atrayee Mullick , Bipul Sinha , Amit Ganesh , Dieter Gawlick
- 申请人地址: US CA Redwood Shores
- 专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人地址: US CA Redwood Shores
- 主分类号: G06F7/06
- IPC分类号: G06F7/06 ; G06F17/30
摘要:
Techniques are disclosed for creating and using a filter index in order to identify registered queries whose result sets are likely to have been changed by changes made to tables. The filter index entries are based on filter conditions. The filter conditions are created based on predicates contained in the registered queries. The filter conditions may include exclusive predicates and join predicates. Join predicates that join a table T1 with a table T2 may be instantiated by replacing references to table T2 with values extracted from table T2. Various techniques are described for recognizing situations in which a query can be included in, or excluded from, the set of likely-changed queries, without fully evaluating the filter conditions that correspond to the queries.