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

1. 发明申请

US20080147627A1 CLUSTERED QUERY SUPPORT FOR A DATABASE QUERY ENGINE 有权
标题翻译：用于数据库查询引擎的集群查询支持
公开(公告)号：US20080147627A1
公开(公告)日：2008-06-19
申请号：US11615899
申请日：2006-12-22
申请人： Olga Natkovich , Jonathan Cao , Alan Gates
发明人： Olga Natkovich , Jonathan Cao , Alan Gates
IPC分类号： G06F17/30
CPC分类号： G06F17/3046
摘要： A device, system, and method are directed towards combining a plurality of queries to a database into a combined execution plan. The plurality of queries is received. The queries may be Structured Query Language (SQL) statements. The database may be a relational database. The plurality of queries is transformed into a plurality of parse trees. A determination is made whether the plurality of queries operates on at least the same portion of the same table. If so, then the plurality of query trees is query-optimized. The plurality of query trees are combined into a master query tree based on similar nodes in the plurality of query trees. A split node in the master query tree represents non-similarities between the plurality of query trees. The master query tree is transformed into an execution plan. The execution plan is applied to a database to return at least one result.
摘要翻译：设备，系统和方法旨在将多个查询组合到数据库到组合执行计划中。接收到多个查询。查询可以是结构化查询语言（SQL）语句。数据库可以是关系数据库。多个查询被转换成多个解析树。确定多个查询是否在同一表的至少相同部分上操作。如果是，那么多个查询树是查询优化的。基于多个查询树中的类似节点，将多个查询树组合成主查询树。主查询树中的分割节点表示多个查询树之间的非相似性。主查询树被转换为执行计划。执行计划应用于数据库以返回至少一个结果。

2. 发明授权

US07844608B2 Clustered query support for a database query engine 有权
标题翻译：数据库查询引擎的集群查询支持
公开(公告)号：US07844608B2
公开(公告)日：2010-11-30
申请号：US11615899
申请日：2006-12-22
申请人： Olga Natkovich , Jonathan Cao , Alan Gates
发明人： Olga Natkovich , Jonathan Cao , Alan Gates
IPC分类号： G06F7/00
CPC分类号： G06F17/3046
摘要： A device, system, and method are directed towards combining a plurality of queries to a database into a combined execution plan. The plurality of queries is received. The queries may be Structured Query Language (SQL) statements. The database may be a relational database. The plurality of queries is transformed into a plurality of parse trees. A determination is made whether the plurality of queries operates on at least the same portion of the same table. If so, then the plurality of query trees is query-optimized. The plurality of query trees are combined into a master query tree based on similar nodes in the plurality of query trees. A split node in the master query tree represents non-similarities between the plurality of query trees. The master query tree is transformed into an execution plan. The execution plan is applied to a database to return at least one result.
摘要翻译：设备，系统和方法旨在将多个查询组合到数据库到组合执行计划中。接收到多个查询。查询可以是结构化查询语言（SQL）语句。数据库可以是关系数据库。多个查询被转换成多个解析树。确定多个查询是否在同一表的至少相同部分上操作。如果是，那么多个查询树是查询优化的。基于多个查询树中的类似节点，将多个查询树组合成主查询树。主查询树中的分割节点表示多个查询树之间的非相似性。主查询树被转换为执行计划。执行计划应用于数据库以返回至少一个结果。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式