US 2019/0163753 A1 · Load Committed Isolation Processing

Abstract

A database table is defined as a load isolated table (LDI table) that supports a current table version number, multiple row versions, and special load protocols. An isolated loading statement on the LDI table is identified in a Data Manipulation Language (DML), causing the table to be placed in an isolated loading state associated with an incremented new value of the table's current version number. A designated group of DML operations in one or more sessions are then used to load/modify rows in the table, and affected rows are marked with the uncommitted new version. Read-committed queries supported for LDIs ignore the uncommitted rows during an isolated load, seeing only previously committed versions of the rows. When an end isolated loading on the table is identified, the table's version is updated to the new incremented value, causing the newly loaded/modified rows to be recognized as committed by subsequent read-committed queries.

Claims20

Dependent claims

A method, comprising:

identifying a begin load isolation statement in instructions for a table;
setting the table to an isolated load state;
with the table in the isolated load state, processing operations defined in the instructions against the table creating new uncommitted versions of rows in the table while maintaining previously committed old versions of the rows;
when an end load isolation statement is encountered within the instructions, committing the new uncommitted version of the rows to the table and transitioning the table out of the isolated load state.

1 more element

Dependencies are inferred from the claim text.

Load Committed Isolation Processing

Life of this patent

Load Committed Isolation Processing

Life of this patent

Abstract

Claims20