公开(公告)号：US20090055350A1

公开(公告)日：2009-02-26

申请号：US11845031

申请日：2007-08-24

申请人： Edward Gust BRANISH, II ,  John F. Hornibrook ,  Dieu Quang La ,  Calisto Paul Zuzarte

发明人： Edward Gust BRANISH, II ,  John F. Hornibrook ,  Dieu Quang La ,  Calisto Paul Zuzarte

IPC分类号： G06F17/30

CPC分类号： G06F17/30454

摘要： A method, computer program product, and system for optimizing aggregate queries are provided. The method, computer program product, and system provide for receiving an aggregate query comprising a GROUP BY operation and an aggregate function, creating an access plan for executing the aggregate query, the access plan including a join between an outer relation and an inner relation, and designating the join included in the access plan as an early out join.

摘要翻译： 提供了一种优化聚合查询的方法，计算机程序产品和系统。 所述方法，计算机程序产品和系统提供用于接收包括GROUP BY操作和聚合函数的聚合查询，创建用于执行所述聚合查询的访问计划，所述访问计划包括外部关系和内部关系之间的连接， 并将访问计划中包含的连接指定为早期连接。

公开(公告)号：US09524317B2

公开(公告)日：2016-12-20

申请号：US11845031

申请日：2007-08-24

申请人： Edward Gust Branish, II ,  John F. Hornibrook ,  Dieu Quang La ,  Calisto Paul Zuzarte

发明人： Edward Gust Branish, II ,  John F. Hornibrook ,  Dieu Quang La ,  Calisto Paul Zuzarte

IPC分类号： G06F17/30

CPC分类号： G06F17/30454

摘要： A method, computer program product, and system for optimizing aggregate queries are provided. The method, computer program product, and system provide for receiving an aggregate query comprising a GROUP BY operation and an aggregate function, creating an access plan for executing the aggregate query, the access plan including a join between an outer relation and an inner relation, and designating the join included in the access plan as an early out join.

摘要翻译： 提供了一种优化聚合查询的方法，计算机程序产品和系统。 所述方法，计算机程序产品和系统提供用于接收包括GROUP BY操作和聚合函数的聚合查询，创建用于执行所述聚合查询的访问计划，所述访问计划包括外部关系和内部关系之间的连接， 并将访问计划中包含的连接指定为早期连接。