Invention Grant
- Patent Title: Efficient evaluation of query expressions including grouping clauses
-
Application No.: US15702659Application Date: 2017-09-12
-
Publication No.: US10853371B2Publication Date: 2020-12-01
- Inventor: Shasank K. Chavan , Dennis Lui , Allison L Holloway , Sheldon A. K. Lewis
- 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: G06F16/2455
- IPC: G06F16/2455 ; G06F16/22 ; G06F16/2458 ; G06F16/2453 ; G06F9/30 ; G06F9/38

Abstract:
Techniques related to efficient evaluation of query expressions including grouping clauses are disclosed. Computing device(s) perform a method for aggregating a measure column vector (MCV) according to a plurality of grouping column vectors (GCVs). The MCV and each of the plurality of GCVs may be encoded. The method includes determining a plurality of actual grouping keys (AGKs) and generating a dense identifier (DI) mapping that maps the plurality of AGKs to a plurality of DIs. Each AGK occurs in the plurality of GCVs. Each DI corresponds to a respective workspace. Aggregating the MCV involves aggregating, in each workspace, one or more codes of the MCV that correspond to an AGK mapped to a DI corresponding to the workspace. For a first row of the MCV and the plurality of GCVs, aggregating the one or more codes includes generating a particular grouping key based on codes in the plurality of GCVs.
Public/Granted literature
- US20180075096A1 EFFICIENT EVALUATION OF QUERY EXPRESSIONS INCLUDING GROUPING CLAUSES Public/Granted day:2018-03-15
Information query