Invention Grant
- Patent Title: Self-maintaining effective value range synopsis in presence of deletes in analytical databases
-
Application No.: US15880826Application Date: 2018-01-26
-
Publication No.: US10671592B2Publication Date: 2020-06-02
- Inventor: Thomas F. Boehme , Andreas Brodt , Alexander Lang , 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 Francis Lammes; Stephen J. Walder, Jr.; Robert G. Bunker
- Main IPC: G06F16/23
- IPC: G06F16/23

Abstract:
A mechanism is provided for updating attribute value information for a data table. The data table involves a set of attributes. The data table has multiple records associated with multiple data blocks. Attribute value information is associated with each data block of the multiple data blocks. The attribute value information is descriptive of at least one attribute of the set of attributes. A first data block may be marked as modified in response to a delete process for deleting from a first data block of the multiple data blocks a record having at least one attribute value that is used for generating the attribute value information of the first data block. In response to scanning the marked first data block, the attribute value information associated with the first data block may be updated based on the scan results.
Public/Granted literature
- US20180150502A1 Self-Maintaining Effective Value Range Synopsis in Presence of Deletes in Analytical Databases Public/Granted day:2018-05-31
Information query