Self-maintaining effective value range synopsis in presence of deletes in analytical databases

Patent metadata

Field	Value
Publication number	US-10671592-B2
Application number	US-201815880826-A
Country	US
Kind code	B2
Filing date	Jan 26, 2018
Priority date	Oct 17, 2016
Publication date	Jun 2, 2020
Grant date	Jun 2, 2020

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.

First claim

What is claimed is:

1. A method, in a data processing system comprising a processor and a memory coupled to the processor, for updating attribute value information for a data table in a disk storage device, the method comprising:
the data table involving a set of attributes, the data table having multiple data blocks and each data block being associated with multiple records, wherein each data block has a one-to-multiple correlation of a data block that corresponds to multiple records;
associating attribute value information with each data block of the multiple data blocks of the data table in the disk storage device, the attribute value information being descriptive of at least one attribute of the data block;
in response to a delete process for deleting from a first data block of the multiple data blocks of the data table in the disk storage device a record having at least one attribute value that is used for generating the attribute value information of the first data block, marking the first data block as modified using a mark; and
in response to scanning the marked first data block:
storing the mark in a transaction log comprising a history of actions executed on the first data block;
performing the update in response to reading the mark and determining that the mark is the last entry in the transaction log;
adding an entry in the transaction log indicating the update; and
updating the attribute value information associated with the first data block based on the scan results.

2. The method of claim 1 , wherein the deleting of the record from the first data block of the multiple data blocks of the data table in the disk storage device comprises:
while performing and committing the deleting of the record of the first data block, marking the first data block as being modified.

3. The method of claim 1 , further comprising:
adding a timestamp of the delete process to the mark for indicating when the deletion was started, wherein the scanning comprises: reading the timestamp for determining whether the deleting is committed after a predefined time period and, in response to determining that the deleting is committed, performing the update of the attribute value information of the first data block.

4. The method of claim 3 , further comprising:
in response to determining that the deleting is not committed, performing the update of the attribute value information of the first data block by generating new attribute value information using attribute values of the first data block excluding the attribute values of the record to be deleted.

5. The method of claim 1 , further comprising:
assigning to each attribute value information of the multiple data blocks of the data table in the disk storage device a version number, wherein the updating of the attribute value information of the first data block comprises incrementing the version number of the first data block and maintaining the attribute value information existing before and after the update.

6. The method of claim 5 , further comprising:
receiving a request for accessing the first data block, in response to determining that the request is pending while the deletion was started using the attribute value information of the first data block that existed before the update for executing the received request.

7. The method of claim 1 , wherein the attribute value information of the first data block comprises the at least one attribute value.

8. The method of claim 1 , wherein the attribute value information of the first data block comprises a maximum value and minimum value of the at least one attribute, wherein the at least one attribute value of the deleted record comprises the minimum value or the maximum value.

Assignees

• IBM

Inventors

• Boehme Thomas F
• Brodt Andreas
• Lang Alexander
• Schiller Oliver

Classifications

• G06F16/2358 Primary

  Change logging, detection, and notification (replication G06F16/27) · CPC title