公开(公告)号：EP1298543A3

公开(公告)日：2008-03-26

申请号：EP02256224.3

申请日：2002-09-09

申请人： NCR International, Inc.

发明人： Pham, Son ,  Pham, Thu K.

IPC分类号： G06F17/30

CPC分类号： G06F17/30466 ,  G06F17/30489 ,  Y10S707/99934 ,  Y10S707/99935

摘要： A database system includes an enhanced optimizer module that is able to consider group-by operations as part of the optimization of a join. Given a query that performs a join of multiple tables and that includes an aggregation function as well as at one of a Where clause and a Group-by clause, a partial group-by is performed on at least one of the tables of the join query to reduce the number of rows for the join. Group-by can also be performed on intermediate results of intermediate joins.

公开(公告)号：EP1298543A2

公开(公告)日：2003-04-02

申请号：EP02256224.3

申请日：2002-09-09

申请人： NCR International, Inc.

发明人： Pham, Son ,  Pham, Thu K.

IPC分类号： G06F17/30

CPC分类号： G06F17/30466 ,  G06F17/30489 ,  Y10S707/99934 ,  Y10S707/99935

摘要： A database system includes an enhanced optimizer module that is able to consider group-by operations as part of the optimization of a join. Given a query that performs a join of multiple tables and that includes an aggregation function as well as at one of a Where clause and a Group-by clause, a partial group-by is performed on at least one of the tables of the join query to reduce the number of rows for the join. Group-by can also be performed on intermediate results of intermediate joins.

摘要翻译： 数据库系统包括增强型优化器模块，能够将分组运算视为优化连接的一部分。 给出执行多个表的连接并且包括聚合函数以及Where子句和Group-by子句之一的查询，对连接查询的至少一个表执行部分分组 以减少连接的行数。 也可以对中间连接的中间结果执行分组。

公开(公告)号：EP1403788A3

公开(公告)日：2007-05-02

申请号：EP03255226.7

申请日：2003-08-23

申请人： NCR INTERNATIONAL INC.

发明人： Pham, Son ,  Pham, Thu K.

IPC分类号： G06F17/30

CPC分类号： G06F17/30454 ,  G06F17/30457 ,  G06F17/30466 ,  G06F17/30489 ,  Y10S707/99932 ,  Y10S707/99935

摘要： A database system includes a storage that contains plural tables as well as a predefined data structure. The database system is able to, in response to a join query, perform a join of two or more tables. The database system also is able to determine, based on values contained in the predefined data structure, whether a group-by operation can be skipped.

公开(公告)号：EP1403788A2

公开(公告)日：2004-03-31

申请号：EP03255226.7

申请日：2003-08-23

申请人： NCR INTERNATIONAL INC.

发明人： Pham, Son ,  Pham, Thu K.

IPC分类号： G06F17/30

CPC分类号： G06F17/30454 ,  G06F17/30457 ,  G06F17/30466 ,  G06F17/30489 ,  Y10S707/99932 ,  Y10S707/99935

摘要： A database system includes a storage that contains plural tables as well as a predefined data structure. The database system is able to, in response to a join query, perform a join of two or more tables. The database system also is able to determine, based on values contained in the predefined data structure, whether a group-by operation can be skipped.

摘要翻译： 存储预定义的数据结构和表。 部分分组操作的跳过是根据数据结构中的数据元素来确定的。 还包括以下独立权利要求：（1）包含计算机可读介质存储表加入程序的文章; 和（2）数据库系统。