Saved Bookmarks
| 1. |
Use Of Multiple-granularity Locking May Require More Or Fewer Locks Than An Equivalent System With A Single Lock Granularity. Provide Examples Of Both Situations, And Compare The Relative Amount Of Concurrency Allowed. |
|
Answer» If a transaction needs to access a large a set of items, multiple granularity locking requires FEWER locks, whereas if only ONE ITEM needs to be ACCESSED, the single lock granularity system allows this with just one lock. Because all the desired data items are locked and unlocked together in the multiple granularity SCHEME, the locking overhead is low, but concurrency is also reduced. If a transaction needs to access a large a set of items, multiple granularity locking requires fewer locks, whereas if only one item needs to be accessed, the single lock granularity system allows this with just one lock. Because all the desired data items are locked and unlocked together in the multiple granularity scheme, the locking overhead is low, but concurrency is also reduced. |
|