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:
“We thought it would be worth the while to read the epitaphs where so many were lost at sea; however, as not only their lives, but commonly their bodies also, were lost or not identified, there were fewer epitaphs of this sort than we expected, though there were not a few. Their graveyard is the ocean.”
—Henry David Thoreau (1817–1862)
“The method of scientific investigation is nothing but the expression of the necessary mode of working of the human mind. It is simply the mode in which all phenomena are reasoned about, rendered precise and exact.”
—Thomas Henry Huxley (1825–95)