G - Physics – 06 – F
Patent
G - Physics
06
F
G06F 17/30 (2006.01) G06F 7/00 (2006.01)
Patent
CA 2425033
A multi-level locking hierarchy for a relational database includes a first locking level applied to a multi-dimensionally clustering table, a second locking level applied to blocks within the table, and a third locking level applied to rows within the blocks. The hierarchy leverages the multi-dimensional clustering of the table data for efficiency and to reduce lock overhead. Data is normally locked in order of coarser to finer granularity to limit deadlock. When data of finer granularity is locked, data of coarser granularity containing the finer granularity data is also locked. Block lock durations may be employed to ensure that a block remains locked if any contained row remains locked. Block level lock attributes may facilitate detection of at least one of a concurrent scan and a row deletion within a block. Detection of the emptying of a block during a scan of the block may bar scan completion in that block.
Bhattacharjee Bishwaranjan
Cranston Leslie A.
Huras Matthew A.
Malkemus Timothy R.
Mcarthur Catherine S.
Ibm Canada Limited - Ibm Canada Limitee
Rosen Arnold
LandOfFree
Multi-level locking hierarchy in a database with... 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-level locking hierarchy in a database with..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Multi-level locking hierarchy in a database with... will most certainly appreciate the feedback.
Profile ID: LFCA-PAI-O-2024077