Invention Application
- Patent Title: CACHE CONSCIOUS TECHNIQUES FOR GENERATION OF QUASI-DENSE GROUPING CODES OF COMPRESSED COLUMNAR DATA IN RELATIONAL DATABASE SYSTEMS
-
Application No.: US17537591Application Date: 2021-11-30
-
Publication No.: US20220083553A1Publication Date: 2022-03-17
- Inventor: Shasank Kisan Chavan , William Martinez Cortes , Weiwei Gong
- 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
- Main IPC: G06F16/2455
- IPC: G06F16/2455 ; G06F16/28 ; G06F16/22

Abstract:
Herein are techniques for dynamic aggregation of results of a database request, including concurrent grouping of result items in memory based on quasi-dense keys. Each of many computational threads concurrently performs as follows. A hash code is calculated that represents a particular natural grouping key (NGK) for an aggregate result of a database request. Based on the hash code, the thread detects that a set of distinct NGKs that are already stored in the aggregate result does not contain the particular NGK. A distinct dense grouping key for the particular NGK is statefully generated. The dense grouping key is bound to the particular NGK. Based on said binding, the particular NGK is added to the set of distinct NGKs in the aggregate result.
Public/Granted literature
Information query