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

1. 发明申请

US20110082856A1 SYSTEM AND METHOD FOR OPTIMIZING QUERIES 有权
标题翻译：用于优化查询的系统和方法
公开(公告)号：US20110082856A1
公开(公告)日：2011-04-07
申请号：US12574911
申请日：2009-10-07
申请人： Suresh Subbiah , Lars Fredriksen , Murali Mallela Krishna , Hansjorg Zeller
发明人： Suresh Subbiah , Lars Fredriksen , Murali Mallela Krishna , Hansjorg Zeller
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： There is provided a computer-implemented method of optimizing a query. An exemplary method comprises receiving a first query configured to generate a result set. The query may comprise an operation for an outer table, a first predicate, and a second predicate. The second predicate may comprise a subquery correlated to the operation. Additionally, the first predicate and the second predicate may be disjunctive. The exemplary method also comprises generating a first query tree representing the first query, and generating a second query tree representing a second query. The second query may be configured to generate the result set, and may not comprise the subquery. The exemplary method additionally comprises generating a query plan based on the second query tree.
摘要翻译：提供了一种优化查询的计算机实现的方法。一种示例性方法包括接收配置成生成结果集的第一查询。该查询可以包括外部表，第一谓词和第二谓词的操作。第二谓词可以包括与该操作相关的子查询。另外，第一谓词和第二谓词可能是分离的。该示例性方法还包括生成表示第一查询的第一查询树，以及生成表示第二查询的第二查询树。可以将第二查询配置为生成结果集，并且可以不包括子查询。该示例性方法还包括基于第二查询树生成查询计划。

2. 发明授权

US08554760B2 System and method for optimizing queries 有权
标题翻译：用于优化查询的系统和方法
公开(公告)号：US08554760B2
公开(公告)日：2013-10-08
申请号：US12574911
申请日：2009-10-07
申请人： Suresh Subbiah , Lars Fredriksen , Murali Mallela Krishna , Hansjorg Zeller
发明人： Suresh Subbiah , Lars Fredriksen , Murali Mallela Krishna , Hansjorg Zeller
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： There is provided a computer-implemented method of optimizing a query. An exemplary method comprises receiving a first query configured to generate a result set. The query may comprise an operation for an outer table, a first predicate, and a second predicate. The second predicate may comprise a subquery correlated to the operation. Additionally, the first predicate and the second predicate may be disjunctive. The exemplary method also comprises generating a first query tree representing the first query, and generating a second query tree representing a second query. The second query may be configured to generate the result set, and may not comprise the subquery. The exemplary method additionally comprises generating a query plan based on the second query tree.
摘要翻译：提供了一种优化查询的计算机实现的方法。一种示例性方法包括接收配置成生成结果集的第一查询。该查询可以包括外部表，第一谓词和第二谓词的操作。第二谓词可以包括与该操作相关的子查询。另外，第一谓词和第二谓词可能是分离的。该示例性方法还包括生成表示第一查询的第一查询树，以及生成表示第二查询的第二查询树。可以将第二查询配置为生成结果集，并且可以不包括子查询。该示例性方法还包括基于第二查询树生成查询计划。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式