All of the transactions in some particular application write all of the data items they read. Showthat if that application executes under SNAPSHOT isolation, all schedules of committed transactions will be serializable.
What will be an ideal response?
If two concurrently executing transactions both commit at SNAPSHOT isolation, they
have written disjoint sets of data items. If they have written all the items they have
read, then they have also read disjoint sets of data items. Therefore all their operations have been on disjoint sets of data items, and hence all operations commute — thus they are serializable.
You might also like to view...
Which type of memory is used by the computer when it starts up?
A) DDR2 B) SDRAM C) ROM D) RAM
Match the following terms to their meanings:
I. Aggregate functions II. Expression III. Field names IV. String V. Property Sheet A. Series of characters B. Included in square brackets in expressions C. Group and perform calculations on multiple fields D. Begins with an equal sign (=) E. Displays the properties that affect the appearance and behavior of the form