Talk:Isolation (database systems)
From Wikipedia, the free encyclopedia
Yeah it will be better if we could know the isolation levels supported by various RDBMS - Shanoof Basheer
Its great feature of DBMS which remove the data access problems -Rajesh ruhil-sapient —Preceding unsigned comment added by 202.144.61.68 (talk) 10:58, 1 February 2008 (UTC)
Proposal for last section of "Repeatable reads (phantom reads)":
In the SERIAZABLE isolation mode, Query 1 would have the result that the range "age BETWEEN 10 AND 30" itself is locked, not the currently available records within this range, thus... --Joachim58 (talk) 11:35, 10 May 2008 (UTC)
SQL specification "serializability" does not require the transactions to be fully serializable; in particular, they need not be serializable with respect to reads for which "read for update" is not specified. It would be nice if someone could update the article to discuss this properly with a full set of details, as it can be a surprising result for some (for example myself when this was first demonstrated to me). Warren Dew (talk) 17:00, 15 May 2008 (UTC)