Multi-phase locking for partition maintenance operations

Details Multi-phase locking for partition maintenance operations Multi-phase locking for partition maintenance operations

1997-07-03

2000-08-15

Vonbuhr, Maria N.

Data processing: database and file management or data structures

Database design

Data structure types

707200, G06F 1730

Patent

active

061050261

ABSTRACT:
A method and apparatus for multi-phase locking for partition maintenance operations. In the first phase, a shared data dictionary lock is acquired on a body of metadata in a data dictionary. Next, the data dictionary is read and a list of affected partitions is generated. In the second phase, an intent exclusive data lock is acquired on the affected table. Next, an exclusive data lock is acquired on the affected partitions of the affected table. The shared data dictionary lock on the data dictionary is released and a physical attribute of the data of the affected partitions is changed. In the third phase, an exclusive data dictionary lock is acquired on the data dictionary. The metadata associated with the affected partitions in the data dictionary is updated and the exclusive data locks on the affected partitions and the intent exclusive data lock on the affected table are released. Finally, the exclusive data dictionary lock on the data dictionary is released. As a result of performing multi-phase locking for partition maintenance operations, the scope of resources locked is reduced and the efficiency of the partition maintenance operations, from a concurrency point of view, is increased.

REFERENCES:
patent: 5161227 (1992-11-01), Dias et al.
patent: 5535375 (1996-07-01), Eshel et al.
patent: 5623659 (1997-04-01), Shi et al.
patent: 5642501 (1997-06-01), Doshi et al.
patent: 5649200 (1997-07-01), LeBlang et al.
patent: 5664186 (1997-09-01), Bennett et al.
patent: 5666532 (1997-09-01), Saks et al.
patent: 5675762 (1997-10-01), Bodin et al.
patent: 5692178 (1997-11-01), Shaughnessy
patent: 5890153 (1999-03-01), Fukuda et al.
patent: 5897638 (1999-04-01), Lasser et al.
J. Gray and A. Reuter, Transaction Processing Concepts and Techniques, Morgan Kaufman Publishers, 1993, ISBN-1-55860-190-2, pp. 406-416;Table of Contents (vii-xxi);Index (pp. 1047-1070).

Affiliated with

Also associated with

Rating

Multi-phase locking for partition maintenance operations does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Multi-phase locking for partition maintenance operations, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Multi-phase locking for partition maintenance operations will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2018261