Invention Grant
- Patent Title: Locking concurrent commands in a database management system
-
Application No.: US15224696Application Date: 2016-08-01
-
Publication No.: US10585874B2Publication Date: 2020-03-10
- Inventor: Bjoern Broll , Sabine Perathoner-Tschaffler , Stefan Renner , Knut Stolze
- 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: Cantor Colburn LLP
- Agent Robert Bunker
- Priority: GB1607147.4 20160425
- Main IPC: G06F16/21
- IPC: G06F16/21 ; G06F16/23

Abstract:
Disclosed herein are methods for receiving a command for adding or removing a resource in a database and acquiring an exclusive lock for the database in response the command. In response to obtaining the exclusive lock, the method comprises determining a first number indicating the number of resources currently existing in the database and a second number indicating the number of resources subject to concurrent further commands for adding or removing a resource; comparing the first and the second number for determining whether the received command will remove the last existing resource or add a first resource to the database; and obtaining an exclusive or a shared lock for the received command in dependence on the determination. The method further includes releasing the exclusive lock for the database and adding or removing the resource while holding the lock obtained for the received command.
Public/Granted literature
- US20170308565A1 LOCKING CONCURRENT COMMANDS IN A DATABASE MANAGEMENT SYSTEM Public/Granted day:2017-10-26
Information query