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.
Computer Science & Information Technology
You might also like to view...
You can use the ________ command to quickly locate and exchange every occurrence of the specified text with alternative text
Fill in the blank(s) with correct word
Computer Science & Information Technology
One tip for the effective use of tables is to use cell ____ to keep the table content from appearing too crowded.
A. padding B. tracking C. kerning D. spanning
Computer Science & Information Technology