US 2024/0394263 A1 · AUTOMATED TRACKING OF OLDEST RUNNING STATEMENT IN DISTRIBUTED MVCC DATABASES

Abstract

The subject technology initializes a statement for execution. The subject technology determines that the statement has been executing for longer than a minimum statement timeout. The subject technology periodically updates a read timestamp table with a new update timestamp for an entry corresponding to the statement. The subject technology determines whether the entry corresponding to the statement has been removed from the read timestamp table. The subject technology, in response to determining that the entry has not been removed from the read timestamp table, removes the entry from the read timestamp table. The subject technology provides a set of results from completing execution of the statement.

Claims30

Dependent claims

A system comprising:

at least one hardware processor;
and
a memory storing instructions that cause the at least one hardware processor to perform operations comprising:
initializing a statement for execution;
determining that the statement has been executing for longer than a minimum statement timeout;
periodically updating a read timestamp table with a new update timestamp for an entry corresponding to the statement;
determining whether the entry corresponding to the statement has been removed from the read timestamp table;
in response to determining that the entry has not been removed from the read timestamp table, removing the entry from the read timestamp table;
and
providing a set of results from completing execution of the statement.

7 more elements

Dependencies are inferred from the claim text.

Automated tracking of oldest running statement in distributed mvcc databases

Life of this patent

Automated tracking of oldest running statement in distributed mvcc databases

Life of this patent

Abstract

Claims30