Database system and method with improved locks

• US 20090254560A1
• Filed: 06/10/2009
• Published: 10/08/2009
• Est. Priority Date: 03/24/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Volker, Paul, Klein, Udo
• Granted Patent: US 7,882,085 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• 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-22. -22. (canceled)

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

determining whether a first database administrator has a chance to be authorized to access a first set of database records, wherein the determination further includes determining (a) if the first database administrator has write authorization for the 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 likely to create a 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 the first database administrator has a chance to be authorized to access the first set of database records;

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 associating 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 associating 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 associating 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.

24. A computer readable media 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 whether a first database administrator has a chance to be authorized to access a first set of database records, wherein the determination further includes determining (a) if the first database administrator has write authorization for the 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 likely to create a conflict of interest, (c) if the first database administrator is organizationally permitted to access the first set of records;

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

attempting to acquire a lock, after determining the first database administrator has a chance to be authorized to access the first set of database records;

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 associating 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 associating 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 associating 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.

25-29. -29. (canceled)

30. A database system comprising:

a plurality of administrator terminals;

a database server capable of being accessed by a plurality of administrators associated with the plurality of administrator terminals, the database server including, at least in part, a database program capable of managing a plurality of records that may be grouped into sets of records, the database program including the functionality of;

(a) detecting a new query from a new administrator at a new administrator terminal for a set of database records capable that is associated with a new lock;

(b) determining whether the new administrator has any chance to be authorized to acquire the new lock, wherein the determination further includes determining (a) if the new administrator has write authorization for the first set of database records;

(b) if the set of database records are personal database records of the new administrator of a type likely to create a 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;

(c) attempting to acquire the new lock if the new administrator has a chance to be authorized; and

(d) 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, after denying to grant the new lock to the new administrator, the new administrator with information relating to the identification of a prior administrator, in accordance with the level of the new administrator.

31. A database system as recited in claim 30 wherein informing the new administrator includes identifying, on the new administrator station, the prior administrator.

32. A database system as recited in claim 31 wherein informing the new administrator includes, on the new administrator station, providing contact information for the prior administrator.

33. A database system as recited in claim 30 further comprising informing the new administrator on the new administrator station that the new administrator is not authorized to acquire the new lock if it is determined that the new administrator has no chance of acquiring the new lock.

34. A database system as recited in claim 30 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.