Isolation is a sufficient but not necessary condition to achieve correctness. Consider an application that reserves seats for a concert. Each reservation transaction (1) reads the list of seats that have not yet been reserved, (2) presents them to a potential customer who selects one of them, and (3) marks the selected seat as reserved. An integrity constraint asserts that the same seat cannot be reserved by two different customers. Describe a situation in which two such transactions that reserve two different seats execute in a nonisolated fashion but are nevertheless correct.
What will be an ideal response?
Assume there are two unreserved seats, Sa and Sb. T1 reads that both are unreserved and while its customer is thinking which seat she wants to reserve, T2 also reads that Sa and Sb are unreserved. Then the customer at T1 reserves Sa and the customer at T2 reserves Sb . That is a perfectly correct execution, but T1 and T2 cannot be serialized in either order because neither sawthe results of the other’s execution. (The system must guarantee that if both customers had tried to reserve the same seat, only one would have been allowed to.)
You might also like to view...
The child axis returns XElements from the set of nodes which are _______ the current node.
a) lower in the hierarchy than b) direct children of c) Both (a) and (b). d) None of the above.
________ properties are settings that control how imported data in cells connect to their source data
Fill in the blank(s) with correct word
Zach, a network engineer, is troubleshooting poor wireless throughput for a group of 15 users in a large office. Many of the computers are showing moderate to weak signals even though there are two APs less then 15 feet (4 meters) away in either direction. Which of the following is MOST likely the cause?
A. The local antennas are not powerful enough. B. There is an SSID mismatch. C. The receiver sensitivity is too high. D. The closest APs are down.
Critical Thinking Questions Case 8-2 ? In your role as production manager, you want to make sure that all of the artwork in a new publication is okay to use. You have a checklist with all of the images that were taken from external sources (as opposed to having been created by the design team). ? One of the images is an illustration accompanied by a business contract that stipulates that the artist will not sell that image to anyone else without your permission. Into what category of art does that illustration fall? a.sharedc.editorial-rightsb.rights-protectedd.royalty-free
What will be an ideal response?