Consider distributed optimistic concurrency control in which each server performs local backward
validation sequentially (that is, with only one transaction in the validate and update phase at one
time), in relation to your answer to Exercise 17.4. Describe the possible outcomes when the two
transactions attempt to commit. What difference does it make if the servers use parallel validation?
What will be an ideal response?
At server X, T precedes U. At server Y, U precedes T. These are not serially equivalent because there are Read/
Write conflicts.
T starts validation at server X and passes, but is not yet committed. It requests validation at server Y. If U has
not yet started validation, Y can validate T. Then U validates after T (at both). Similarly for T after U.
T starts validation at server X and passes, but is not yet committed. It requests validation at server Y. If U has
started validation, T will be blocked. When U requests validation at X, it will be blocked too. So there is a
deadlock.
If parallel validation is used, T and U can be validated (in different orders) at the two servers, which is wrong.
You might also like to view...
The best defense against malware is _____________.
A. encryption B. entropy C. antivirus software D. all of the above
This morning when Paul turned on his computer at work, it would not boot. Instead, Paul reported that he heard a loud clicking noise coming from inside his computer. What might bethe problem with Paul’s computer?
A. Magnetic hard drive failed. B. SSD hard drive failed. C. DVD drive failed. D. Video card failed.