Method and apparatus for dynamically disabling and enabling tabl

Details Method and apparatus for dynamically disabling and enabling tabl Method and apparatus for dynamically disabling and enabling tabl

1996-04-08

1998-08-11

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

G06F 700

Patent

active

057942412

ABSTRACT:
Method for dynamically enabling and disabling table locking for a table in a database in a relational database management system. A table locking state is associated with the table and can be set to either enabled or disabled to indicate the current state of table locking for the table. To disable table locking, a user must first acquire an exclusive table lock. To re-enable table locking, a user must wait for any user currently accessing the table to perform e.g., a query, to finish accessing the table before table locking is enabled.

REFERENCES:
patent: 4399504 (1983-08-01), Obermarck et al.
patent: 4574350 (1986-03-01), Starr
patent: 4604694 (1986-08-01), Hough
patent: 4821175 (1989-04-01), Hikita et al.
patent: 5202990 (1993-04-01), Saikawa
patent: 5261069 (1993-11-01), Wilkinson et al.
patent: 5287521 (1994-02-01), Nitta et al.
patent: 5459862 (1995-10-01), Garliepp et al.
patent: 5502840 (1996-03-01), Barton
patent: 5526524 (1996-06-01), Madduri
Lock Management Architecture Overview, IBM Technical Disclosure Bulletin, vol. 31, No. 5, pp. 125-128, Oct. 1988.
Conditional Locking of Nonroot Index Pages, IBM Technical Disclosure Bulletin, vol. 32, No. 3, pp. 57-58, Aug. 1989.

Affiliated with

Also associated with

Rating

Method and apparatus for dynamically disabling and enabling tabl does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for dynamically disabling and enabling tabl, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for dynamically disabling and enabling tabl will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-403930