•What is a data
item (on which a lock is obtained)?
–Most times,
in most systems: item is a tuple in a table
–Sometimes:
item is a page (with several tuples)
–Sometimes:
item is a whole table
•In order to manage
conflicts properly, system gets “intention”
mode locks on larger granules before getting
actual R/W locks on smaller granules