To: AnnieK who wrote (7242 ) 6/1/1998 10:13:00 AM From: Michael Olin Respond to
Your explanation of read-consistency is almost perfect. Read-consistency guarantees that a user's view of the database does not change during a transaction. For example, if I query an order and another user changes the same order and commits their changes, my transaction still sees the old data. In Oracle, if I try to change the order, I will be told that it was changed by someone else and prompted to requery to get the new values. If I don't try to change the data, I still see the old values until my transaction finishes. Some systems will automatically update a user's view of a record once another user has committed a change to it. This does not maintain read-consistency.
