Invention Grant
- Patent Title: Partial group by for eager group by placement query plans
-
Application No.: US16797507Application Date: 2020-02-21
-
Publication No.: US11704317B2Publication Date: 2023-07-18
- Inventor: Pit Fender , Benjamin Schlegel , Nipun Agarwal
- 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 Becker Bingham Ledesma LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453 ; G06F12/12 ; G06F16/2455

Abstract:
A partial group by operator is a group by operator that implements a fallback mechanism. The fallback mechanism is triggered whenever memory pressure reaches a certain threshold. When the fallback mechanism is triggered, a row is included in an output of the partial group by operator without including an aggregation value for a grouping value for the row to an aggregation data structure. A final group by operator computes a final aggregate value of all results, including pre-grouped results and passed through results, from the partial group by operator.
Public/Granted literature
- US20210263930A1 PARTIAL GROUP BY FOR EAGER GROUP BY PLACEMENT QUERY PLANS Public/Granted day:2021-08-26
Information query