Invention Grant
- Patent Title: Data-aware scalable parallel execution of rollup operations
- Patent Title (中): 数据感知可扩展并行执行汇总操作
-
Application No.: US13754770Application Date: 2013-01-30
-
Publication No.: US09235621B2Publication Date: 2016-01-12
- Inventor: Jianhua Liang , Srikanth Bellamkonda
- Applicant: Oracle International Corporation
- 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:
According to one aspect of the invention, for a database statement that specifies rollup operations, a data distribution key may be selected among a plurality of candidate keys. Numbers of distinct values of the candidate keys may be monitored with respect to a particular set of rows. Hash values may also be generated by column values in the candidate keys. The data distribution key may be determined based on results of monitoring the numbers of distinct values of the candidate keys as well as the frequencies of hash values computed based on column values of the candidate keys. Rollup operations may be shared between different stages of parallel executing processes and data may be distributed between the different stages of parallel executing processes based on the selected data distribution key.
Public/Granted literature
- US20140214800A1 Data-Aware Scalable Parallel Execution of Rollup Operations Public/Granted day:2014-07-31
Information query