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:
“Nothing is so galling to a people not broken in from the birth as a paternal, or in other words a meddling government, a government which tells them what to read and say and eat and drink and wear.”
—Thomas Babington Macaulay (1800–1859)
“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)