Database system and method with improved locks

US7882085B2 · kind B2 · utility

Assignee

• SAP AG · DE

Inventors

• Udo Klein · Maximiliansau, DE
• Paul Volker · Andover, US

Key dates

• Filing date: Jun 10, 2009
• Grant date: Feb 1, 2011
• Expiry date: Jun 10, 2029

Classification

• Technology area (CPC Y): Emerging Cross-Sectional Technologies
• CPC primary: Y10S707/99939
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

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.