/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 postgresql.verite.pro
Isolation Repeatable Read in PostgreSQL versus MySQL
| | sookocheff.com
Paper Review: Generalized Isolation Level Definitions | Kevin Sookocheff
1.9 parsecs away

Travel
| | Title and Author of Paper Generalized Isolation Level Definitions, Adya et al. Summary The ANSI SQL standard defines isolation levels allowing database users to trade off between performance and consistency when running transactions. Unfortunately, the wording in the SQL standard is geared towards locking as the sole supported concurrency method. This paper presents alternative definitions to the isolation levels specified in the ANSI SQL standard that are general enough to allow for any concurrency method (multi-version, optimistic, etc.) to be used.
| | pavan-kalyan.dev
Pavan Kalyan's Blog | Transaction Isolation Levels Are A Confusing Mess
2.4 parsecs away

Travel
| |
| | surfingcomplexity.blog
Extending MVCC to be serializable, in TLA+ - Surfing Complexity
2.2 parsecs away

Travel
| | In the previous blog post, we saw how a transaction isolation strategy built on multi-version concurrency control (MVCC) does not implement the serializable isolation level. Instead, it implements a weaker isolation level called snapshot isolation. In this post, I'll discuss how that MVCC model can be extended in order to achieve serializability, based on work...
| | ordep.dev
What you should know about database storage and retrieval.
24.4 parsecs away

Travel
| [AI summary] A transcript of a talk comparing log-structured storage engines like LSM-Trees with traditional B-Trees, discussing their architectures, performance trade-offs, and underlying data structures.