Chapter 18: Problem 23
Prove that the wait-die and wound-wait protocols avoid deadlock and starvation.
Chapter 18: Problem 23
Prove that the wait-die and wound-wait protocols avoid deadlock and starvation.
All the tools & learning materials you need for study success - in one app.
Get started for freeHow do optimistic concurrency control techniques differ from other concurrency control techniques? Why are they also called validation or certification tech. niques? Discuss the typical phases of an optimistic concurrency control method.
Prove that the basic two-phase locking protocol guarantees conflict serializability of schedules. (Hint: Show that, if a serializability graph for a schedule has a cycle, then at least one of the transactions participating in the schedule does not obey the two-phase locking protocol.)
Compare binary locks to exclusive/shared locks. Why is the latter type of locks preferable?
What is a phantom record? Discuss the problem that a phantom record can cause for concurrency control.
What is multiple granularity locking? Under what circumstances is it used? \(x\)
What do you think about this solution?
We value your feedback to improve our textbook solutions.