专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20100036803A1 ADAPTIVE FILTER INDEX FOR DETERMINING QUERIES AFFECTED BY A DML OPERATION 有权
标题翻译：用于确定DML操作影响的自适应滤波器索引
公开(公告)号：US20100036803A1
公开(公告)日：2010-02-11
申请号：US12326822
申请日：2008-12-02
申请人： Srinivas S. Vemuri , Atrayee Mullick , Bipul Sinha , Amit Ganesh , Dieter Gawlick
发明人： Srinivas S. Vemuri , Atrayee Mullick , Bipul Sinha , Amit Ganesh , Dieter Gawlick
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/3051
摘要： 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.
摘要翻译：公开了用于创建和使用过滤器索引的技术，以便识别其结果集可能由于对表的改变而改变的注册查询。过滤器索引条目基于过滤器条件。过滤条件是根据注册查询中包含的谓词创建的。过滤条件可能包括排除谓词和连接谓词。可以通过用从表T2提取的值替换对表T2的引用来实例化加入具有表T2的表T1的连接谓词。描述各种技术用于识别其中可以将查询包括在可能改变的查询集合中或从可能改变的查询集合中排除的情况，而不完全评估与查询相对应的过滤条件。

2. 发明授权

US08185508B2 Adaptive filter index for determining queries affected by a DML operation 有权
标题翻译：用于确定受DML操作影响的查询的自适应过滤器索引
公开(公告)号：US08185508B2
公开(公告)日：2012-05-22
申请号：US12326822
申请日：2008-12-02
申请人： Srinivas S. Vemuri , Atrayee Mullick , Bipul Sinha , Amit Ganesh , Dieter Gawlick
发明人： Srinivas S. Vemuri , Atrayee Mullick , Bipul Sinha , Amit Ganesh , Dieter Gawlick
IPC分类号： G06F17/30
CPC分类号： G06F17/3051
摘要： 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.
摘要翻译：公开了用于创建和使用过滤器索引的技术，以便识别其结果集可能由于对表的改变而改变的注册查询。过滤器索引条目基于过滤器条件。过滤条件是根据注册查询中包含的谓词创建的。过滤条件可能包括排除谓词和连接谓词。可以通过用从表T2提取的值替换对表T2的引用来实例化加入具有表T2的表T1的连接谓词。描述各种技术用于识别其中可以将查询包括在可能改变的查询集合中或从可能改变的查询集合中排除的情况，而不完全评估与查询相对应的过滤条件。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式