Database system and method with improved locks

• US 7,882,085 B2
• Filed: 06/10/2009
• Issued: 02/01/2011
• Est. Priority Date: 03/24/2004
• Status: Expired due to Fees

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Volker, Paul, Klein, Udo
• Primary Examiner(s): PANNALA, SATHYANARAYA R
• Application Number:
  US12/457,437
• Publication Number:
  US 20090254560A1
• Time in Patent Office: 601 Days
• Field of Search: 707999008-999009
• US Class Current: 707/694
• CPC Class Codes: G06F 16/2343 Locking methods, e.g. distributed locking or locking implementation details
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99939 Privileged access

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.

Claims

1. A method for making a preliminary determination as to whether a database administrator has authorization to access a set of database records comprising:

determining at least one of (a) if the first database administrator has write authorization for a first set of database records;

(b) if the first set of database records are personal database records of the first database administrator of a type which does not cause a potential conflict of interest, (c) if the first database administrator is organizationally permitted to access the first set of database records;

or (d) if the first database administrator is currently authorized; and

attempting to acquire a lock, after determining (a) the first database administrator has write authorization for a first set of database records;

(b) the first set of database records are personal database records of the first database administrator of a type which does not cause a potential conflict of interest, (c) the first database administrator is organizationally permitted to access the first set of database records;

or (d) the first database administrator is currently authorized;

acquiring a lock after a first query is submitted by the first database administrator, the first query relating to the first set of database records;

detecting, by a computer, whether a second query for a second set of database records is submitted by a second database administrator, the second set of database records associated with the first set of database records, wherein the second database administrator is associated with a level of an organization;

examining, after detecting the second query for the second set of database records which is submitted by the second database administrator, an employee number associated with the second set of database records submitted in the second query and an employee number associated with the second user to determine if the second database administrator is authorized to access the second set of database records;

denying the second user from accessing the second set of database records if the employee number associated with the second set of Attorney Docket database records submitted in the second query matches the employee number associated with the second user;

determining, if the employee number associated with the second set of database records submitted in the second query differs from the employee number associated with the second user, whether the lock is acquired by the first database administrator;

denying the lock to the second user if the lock is acquired by the first database administrator;

granting the lock to the second user if the lock is not acquired by the first database administrator; and

informing, after denying to grant the lock to the second database administrator, the second database administrator with information relating to the identification of the first user, in accordance with the level of the second database administrator.

2. A computer-readable medium including program code segments for making a preliminary determination as to whether a database administrator has authorization to access a set of database records according to a method, the method comprising :

determining at least one of (a) if a first database administrator has write authorization for a first set of database records;

(b) if the first set of database records are personal database records of the first database administrator of a type which does not cause a potential conflict of interest, (c) if the first database administrator is organizationally permitted to access the first set of database records;

or (d) if the first database administrator is currently authorized;

attempting to acquire a lock, after determining (a) the first database administrator has write authorization for a first set of database records;

(b) the first set of database records are personal database records of the first database administrator of a type which does not cause a potential conflict of interest, (c) the first database administrator is organizationally permitted to access the first set of database records;

or

(d) the first database administrator is currently authorized;

acquiring a lock after a first query is submitted by the first database administrator, the first query relating to the first set of database records;

detecting, by a computer, whether a second query for a second set of database records is submitted by a second database administrator, the second set of database records associated with the first set of database records, wherein the second database administrator is associated with a level of an organization;

examining, after detecting the second query for the second set of database records which is submitted by the second database administrator, an employee number associated with the second set of database records submitted in the second query and an employee number associated with the second user to determine if the second database administrator is authorized to access the second set of database records;

denying the second user from accessing the second set of database records if the employee number associated with the second set of database records submitted in the second query matches the employee number associated with the second user;

determining, if the employee number associated with the second set of database records submitted in the second query differs from the employee number associated with the second user, whether the lock is acquired by the first database administrator;

denying the lock to the second user if the lock is acquired by the first database administrator;

granting the lock to the second user if the lock is not acquired by the first database administrator; and

informing, after denying to grant the lock to the second database administrator, the second database administrator with information relating to the identification of the first user, in accordance with the level of the second database administrator.

3. A database system comprising:

a plurality of administrator terminals;

a database server accessed by a plurality of administrators associated with the terminals, the database server including a database program for managing a plurality of records grouped into sets of records, the database program;

detecting a new query from a new administrator at a new administrator terminal for a set of database records;

determining at least one of (a) if a new administrator has write authorization for the set of database records;

(b) if the set of database records are personal database records of the new administrator of a type which does not cause a potential conflict of interest, (c) if the new administrator is organizationally permitted to access the set of database records;

or (d) if the new administrator is currently authorized;

attempting to acquire the new lock if (a) the new administrator has write authorization for the set of database records;

(b) the set of database records are personal database records of the new administrator of a type which does not cause a potential conflict of interest, (c) the new administrator is organizationally permitted to access the set of database records;

or (d) the new administrator is currently authorized; and

informing the new administrator at the new administrator terminal of a failure to acquire the new lock if a prior lock has already been acquired due to a prior query by a prior administrator on a prior administrator station and, after denying to grant the new lock to the new administrator, informing the new administrator with information relating to the identification of a prior administrator, in accordance with the level of the new administrator.

4. The database system as recited in claim 3 wherein informing the new administrator includes identifying, on the new administrator station, the prior administrator.

5. The database system as recited in claim 4 wherein informing the new administrator includes, on the new administrator station, providing contact information for the prior administrator.

6. The database system as recited in claim 3 further comprising informing the new administrator on the new administrator station that the new administrator is not authorized to acquire the new lock.

7. The database system as recited in claim 3 further comprising permitting access to the set of database records via the new administrator terminal if the new administrator acquires the new lock, and designating the new administrator as a prior administrator and the new lock as a prior lock.