Invention Grant
- Patent Title: Value range synopsis in column-organized analytical databases
-
Application No.: US15147983Application Date: 2016-05-06
-
Publication No.: US10346403B2Publication Date: 2019-07-09
- Inventor: Thomas F. Boehme , Andreas Brodt , James L. Finnie , 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 Kenneth Han
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/28 ; G06F16/2455

Abstract:
The method may include providing, in accordance with a column-oriented storage technique, the data table as columns corresponding to the plurality of attributes, whereby each column includes a plurality of separate data blocks. The method may also include determining the plurality of records of the provided data table for which a plurality of attribute values of at least one selected column is contained in a plurality of predetermined data blocks. The method may further include determining, for each column of at least a part of the plurality of columns within the determined plurality of records, a plurality of attribute value information descriptive of an associated attribute within the column and providing an indication of the one or more data blocks for which the plurality of attribute value information is determined. The method may also include storing the determined plurality of attribute value information for enabling query processing.
Public/Granted literature
- US20170323003A1 VALUE RANGE SYNOPSIS IN COLUMN-ORGANIZED ANALYTICAL DATABASES Public/Granted day:2017-11-09
Information query