Invention Grant
- Patent Title: Grouping in analytical databases
-
Application No.: US16424308Application Date: 2019-05-28
-
Publication No.: US11238040B2Publication Date: 2022-02-01
- Inventor: Felix O. Beier , Andreas Brodt , Oliver Schiller
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Rakesh Roy
- Main IPC: G06F16/24
- IPC: G06F16/24 ; G06F16/2453 ; G06F16/951 ; G06F16/22 ; G06F16/242

Abstract:
Attribute value information on data blocks of a data table is provided that indicates upper and lower bounds of extreme values for an attribute of the data table. In response to determining that processing of a received data table query involves grouping of records according to a grouping attribute, it is determined whether the attribute value information reflects upper and lower bounds of extreme values of the grouping attribute. If the attribute value information indicates the upper and lower bounds of extreme values of the grouping attribute, a scan list is determined that defines which data blocks are to be scanned in a determined scan order. A set of distinct value ranges of the grouping attribute is determined based on the scan order, the data blocks are scanned using the scan list, and the query is processed.
Public/Granted literature
- US20190278773A1 GROUPING IN ANALYTICAL DATABASES Public/Granted day:2019-09-12
Information query