CODEWITHSUNDEEP
databasetransactionstransaction-isolation
Vadim Samokhin
Vadim Samokhin

Reputation: 3456

Database transaction isolation in MVCC model

I have read about transaction isolation in MVCC model here and 2 questions arose.

Upvotes: 1

Views: 140

Answers (1)

usr
usr

Reputation: 171188

The author of the table confused guarantees from isolation levels with the mechanism used to implement them. It is not required to implement isolation using locks.

Optimistic models like MVCC can provide the same guarantees without locks. They can even provide serializability by validating the read and write sets at commit time (this isn't implement in any RDBMS AFAIK, but SQL Server Hekaton will use this technique).

Upvotes: 1

Related Questions