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:
“He was the man who of all modern, and perhaps ancient poets, had the largest and most comprehensive soul.... He needed not the spectacles of books to read Nature; he looked inwards, and found her there.”
—John Dryden (1631–1700)
“Many of the phenomena of Winter are suggestive of an inexpressible tenderness and fragile delicacy. We are accustomed to hear this king described as a rude and boisterous tyrant; but with the gentleness of a lover he adorns the tresses of Summer.”
—Henry David Thoreau (1817–1862)