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:
“What else has been English news for so long a season? What else, of late years, has been England to us,—to us who read books, we mean?... Carlyle alone, since the death of Coleridge, has kept the promise of England. It is the best apology for all the bustle and the sin of commerce, that it has made us acquainted with the thoughts of this man.”
—Henry David Thoreau (1817–1862)
“The manifestation of poetry in external life is formal perfection. True sentiment grows within, and art must represent internal phenomena externally.”
—Franz Grillparzer (1791–1872)