Invention Grant
- Patent Title: Execution of operations on partitioned tables
-
Application No.: US17826974Application Date: 2022-05-27
-
Publication No.: US11940972B2Publication Date: 2024-03-26
- Inventor: Xiaoke Liu , Zhilong Hao , Weimin Qi , Zhe Qu , Jiaxin Liu , Qingwei Ren
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fountainhead Law Group P.C.
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/22 ; G06F16/2455

Abstract:
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.
Public/Granted literature
- US20230385263A1 IMPROVED EXECUTION OF OPERATIONS ON PARTITIONED TABLES Public/Granted day:2023-11-30
Information query