Invention Grant
- Patent Title: Grouping in analytical databases
-
Application No.: US15452303Application Date: 2017-03-07
-
Publication No.: US10346398B2Publication Date: 2019-07-09
- 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
- Agency: Lee Law, PLLC
- Agent Christoper B. Lee
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453 ; G06F16/951 ; G06F16/22 ; G06F16/242

Abstract:
Attribute value information on data blocks, of a data table with multiple data blocks, is provided that indicates upper and lower bounds of extreme values for at least one attribute of the data table. In response to determining that processing of a received data table query involves grouping of records with respect 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 of the data table are to be scanned and a scan order is determined. 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
- US20180260439A1 GROUPING IN ANALYTICAL DATABASES Public/Granted day:2018-09-13
Information query