Invention Grant
- Patent Title: Database system and method with improved locks
- Patent Title (中): 数据库系统和方法具有改进的锁
-
Application No.: US12457437Application Date: 2009-06-10
-
Publication No.: US07882085B2Publication Date: 2011-02-01
- Inventor: Udo Klein , Paul Volker
- Applicant: Udo Klein , Paul Volker
- Applicant Address: DE Walldorf
- Assignee: SAP AG
- Current Assignee: SAP AG
- Current Assignee Address: DE Walldorf
- Agency: Finnegan, Henderson, Farabow, Garrett & Dunner LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

Abstract:
A method for handling database locks includes detecting a new query from an administrator for a set of database records. Next, it is determined whether the administrator has any chance of being authorized to acquire a new lock. If so, an attempt is made to acquire the new lock and, on the failure to acquire, the administrator is informed that the lock has already been acquired by a prior administrator. Optionally, the new administrator is also provided with identifying information of the prior administrator and contact information for the prior administrator. The new administrator is therefore pre-screened to determine whether there is any chance to acquire a new lock to reduce the chance that an unauthorized new administrator could lock the set of database records. Also, should the new administrator be authorized but not able to access the set of database records due to a prior lock, the new administrator can be informed of the identity and contact information concerning the holder of the prior lock.
Public/Granted literature
- US20090254560A1 Database system and method with improved locks Public/Granted day:2009-10-08
Information query