Invention Grant
US09563658B2 Hardware implementation of the aggregation/group by operation: hash-table method
有权
通过操作对汇聚/组的硬件实现:hash-table方法
- Patent Title: Hardware implementation of the aggregation/group by operation: hash-table method
- Patent Title (中): 通过操作对汇聚/组的硬件实现:hash-table方法
-
Application No.: US13590057Application Date: 2012-08-20
-
Publication No.: US09563658B2Publication Date: 2017-02-07
- Inventor: Philip Amberg , Justin Schauer , Robert David Hopkins
- Applicant: Philip Amberg , Justin Schauer , Robert David Hopkins
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
Techniques are described for performing grouping and aggregation operations. In one embodiment, a request is received to aggregate data grouped by a first column. In response to receiving the request, a group value in a row of a first column is mapped to an address. A pointer is stored for a first group at a first location identified by the address. The pointer identifies a second location of a set of aggregation data for the first group. An aggregate value included in the set of aggregation data is updated based on a value in the row of a second column.
Public/Granted literature
- US20140052726A1 HARDWARE IMPLEMENTATION OF THE AGGREGATION/GROUP BY OPERATION: HASH-TABLE METHOD Public/Granted day:2014-02-20
Information query