The ANSI/ISO standard SQL 92 refers to three different read phenomena when Transaction 1 reads data that Transaction 2 might have changed.
In the following examples, two transactions take place. In the first, Query 1 is performed. Then, in the second transaction, Query 2 is performed and committed. Finally, in the first transaction, Query 1 is performed again.
The queries use the following data table:
| id | name | age |
|---|---|---|
| 1 | Joe | 20 |
| 2 | Jill | 25 |
Read more about this topic: Isolation (database Systems)
Famous quotes containing the words read and/or phenomena:
“Who will in fairest book of Nature know
How virtue may best lodged in beauty be,
Let him but learn of love to read in thee,
Stella, those fair lines which true goodness show.
There shall he find all vices’ overthrow,
Not by rude force, but sweetest sovereignty
Of reason,”
—Sir Philip Sidney (1554–1586)
“What were the phenomena of the world today? If I knew little else, I knew the answer—war, and the preparations for new war.”
—Norman Mailer (b. 1923)