Difference between latches and locks
> Usually, latches are used to guarantee physical consistency of data, while locks
are used to assure logical consistency of data.
Hierarchical locking
> The intention locks (IX, IS, and SIX) are generally obtained on the higher
levels of the hierarchy (e.g., table), and the S