US Patent Application 17826974. IMPROVED EXECUTION OF OPERATIONS ON PARTITIONED TABLES simplified abstract
Contents
IMPROVED EXECUTION OF OPERATIONS ON PARTITIONED TABLES
Organization Name
Inventor(s)
IMPROVED EXECUTION OF OPERATIONS ON PARTITIONED TABLES - A simplified explanation of the abstract
This abstract first appeared for US patent application 17826974 titled 'IMPROVED EXECUTION OF OPERATIONS ON PARTITIONED TABLES
Simplified Explanation
The patent application describes a method for improving the execution of data definition language (DDL) and data manipulation language (DML) operations on a partitioned database table using partition-based locking mechanisms.
- The method involves acquiring locks on table metadata and relevant partition table data to ensure proper execution of overlapping DDL and DML operations.
- When a DML statement is received, an intent exclusive lock is acquired on the table metadata to indicate that the table is being modified.
- When a DDL statement is received, an exclusive metadata lock is acquired on the partitioned table metadata to indicate that the table structure is being modified.
- The second transaction then acquires an intent exclusive lock for the relevant partition table data and an exclusive lock on the table metadata, waiting for the completion of the first transaction's DML operation.
- Once the first transaction is committed, exclusive locks are acquired on the table data and metadata, and the second transaction is executed and committed.
Original Abstract Submitted
Computer-readable media, methods, and systems are disclosed for utilizing partition-based locking mechanisms to improve execution of overlapping data definition language (DDL) and data manipulation language (DML) operations on a partitioned database table. A first node receives a DML statement associated with a first transaction. The first node acquires a intent exclusive lock on table metadata. A second node receives a DDL statement associated with a second transaction and acquires an exclusive metadata lock on the partitioned table metadata. Next, an intent exclusive lock is acquired for the relevant partition table data on the second node and an exclusive lock on table metadata on the second node. The second transaction waits for the DML operation of the first transaction to complete. Then the first transaction is committed. Finally exclusive locks are acquired on table data and metadata and the second transaction is executed and committed.