Orthogonal key-value locking is simple and efficient yet supports both fine and coarse granularities of locking.

Orthogonal key-range locking is somewhat similar to key-range locking in SQL Server, but with a complete set of lock modes and completely orthogonal locks on ...

[0055] In summary, orthogonal key-value locking combines all the advantages of locking a distinct key value and all its index entries in a single lock manager ...

Experiments show that the new technique reduces the number of lock requests yet increases transactional concurrency, improving transaction throughput for both ...

The proposed design combines principal elements of orthogonal key-range locking. (complete separation of lock modes for key value and gap) and of ARIES key- ...

This paper devised new algorithms and methods to improve all components of database locking, including key range locking, intent locks, detection and recovery ...

For example, orthogonal key-value locking in ordered indexes such as B-trees protects distinct key values with all their index entries, partitions of index ...

Orthogonal key-value locking is simple and efficient yet supports both fine and coarse granularities of locking. A lock request may cover (i) a key value ...

Overview. OKVL is a more concurrent and simple lock mode design compared to ARIES KVL (Key Value Locking), Lomet's KRL (Key Range Locking), and Graefe's OKRL ( ...

Feb 27, 2015 · Is this actually true? • Too little concurrency. Poorly chosen lock modes. Poorly chosen granules. Excessive lock duration.