Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2001-06-29
2004-02-03
Mizrahi, Diane D. (Department: 2175)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06687709
ABSTRACT:
TECHNICAL FIELD
The invention relates in general to data processing systems for database management, and in particular, to a system for locking database records in a multi-threaded, distributed, data processing environment.
BACKGROUND INFORMATION
Database management systems (or other file management system) in a multi-threaded, or similar multiple client data processing system environment must implement a scheme for avoiding record collisions or contentions. That is, the database management system (DBMS) must incorporate a scheme for locking records so that a second client does not access the record during the pendency of an operation on the records by the first client.
Typically a software component which may be referred to as a “resource manager” controls which records are locked. The resource manager may track, for each record, whether the record is locked, including a type of lock such as a shared lock or exclusive lock, for the record. Consequently, the resource manager may, for a realistically sized database, be complex, with the locking and unlocking of records involving a multiplicty of decision paths. Thus, there is a need in the art for more efficient lock management systems.
SUMMARY OF THE INVENTION
The aforementioned needs are addressed by the present invention. Accordingly there is provided a method for database record locking. A lock state is selectively set in response to a locking operation request. The lock state constitutes a class in an object-oriented locking service architecture. A locking operation corresponding to the locking operation request is performed on one or more records. The locking operation is implemented by a method of a lock state class in the object-oriented locking service architecture, the lock state class corresponding to a current lock state.
The foregoing has outlined rather broadly the features and technical advantages of the present invention in order that the detailed description of the invention that follows may be better understood. Additional features and advantages of the invention will be described hereinafter which form the subject of the claims of the invention.
REFERENCES:
patent: 5202971 (1993-04-01), Henson et al.
patent: 5339427 (1994-08-01), Elko et al.
patent: 5692178 (1997-11-01), Shaughnessy
patent: 5742813 (1998-04-01), Kavanagh et al.
patent: 5983225 (1999-11-01), Anfindsen
patent: 6052731 (2000-04-01), Holdsworth et al.
patent: 6144983 (2000-11-01), Klots et al.
patent: 6343339 (2002-01-01), Daynes
patent: 6373950 (2002-04-01), Rowney
International Business Machines - Corporation
LaBaw Jeffrey S.
Mizrahi Diane D.
Newberger Barry S.
Winstead Sechrest & Minick P.C.
LandOfFree
Apparatus for database record locking and method therefor does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Apparatus for database record locking and method therefor, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus for database record locking and method therefor will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3344727