Invention Grant
- Patent Title: Method for computing distinct values in analytical databases
-
Application No.: US15298336Application Date: 2016-10-20
-
Publication No.: US11036699B2Publication Date: 2021-06-15
- Inventor: Andreas Brodt
- 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 Francis Lammes; Stephen J. Walder, Jr.; Steven M. Bouknight
- Main IPC: G06F16/215
- IPC: G06F16/215 ; G06F16/23

Abstract:
A mechanism is provided for determining distinct values of an attribute in a data table including the attribute and data records stored in a set of data blocks. Attribute value information is provided for each data block that comprises information indicating distinct values of the attribute in the data blocks. At least part of a current data block of the data table is scanned to determine current distinct values of the attribute. The current distinct values of the attribute of the current data block are added to a list of current distinct values of the data table. The scanning and adding are repeatedly performed for a further data block of the data table if the attribute value information of the further data block indicates at least one distinct value that is not present in the list. The list of current distinct values are then provided.
Public/Granted literature
- US20180113886A1 Method for Computing Distinct Values in Analytical Databases Public/Granted day:2018-04-26
Information query