Invention Grant
- Patent Title: Management of long-running locks and transactions on database tables
-
Application No.: US15268401Application Date: 2016-09-16
-
Publication No.: US09836493B2Publication Date: 2017-12-05
- Inventor: Justin T. Fries , Venkataraghavan Lakshminarayanachar , Rajesh C. Lalgowdar , Lohitashwa Thyagaraj
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agency: Lee Law, PLLC
- Agent Christopher B. Lee
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Establishment of an exclusive lock on each of an outer database ownership table and an inner database ownership table is attempted. In response to establishing the exclusive lock on each of the outer database ownership table and the inner database ownership table, a switch is made to a pair of overlapping shared locks on each of the outer database ownership table and the inner database ownership table. Release and re-acquisition of each of the pair of overlapping shared locks on the outer database ownership table and the inner database ownership table is alternated.
Public/Granted literature
- US20170004165A1 MANAGEMENT OF LONG-RUNNING LOCKS AND TRANSACTIONS ON DATABASE TABLES Public/Granted day:2017-01-05
Information query