Give full details of a mechanism for concurrency control that can be used to ensure the types of problems discussed in Question 22.3 cannot occur. Show how the mechanism prevents the problems illustrated from occurring. Discuss how the concurrency control mechanism interacts with the transaction mechanism.
What will be an ideal response?
Should discuss 2PL, timestamping, or an optimistic technique. Solutions to above problems for
2PL Transaction is the unit of concurrency control.
You might also like to view...
The text boxes, labels, and buttons included in most Windows applications are objects.
Answer the following statement true (T) or false (F)
The process of taking data and making it unreadable is known as which of the following?
A. Encryption B. Decryption C. Signing D. Verifying
In the hierarchy of selectors the ______, the stronger the rule.
a. More general the selector b. More specific declaration c. More specific the selector d. More general declaration
A Table ________ controls the fill color of the header row, columns, and records in a table
Fill in the blank(s) with correct word