REVIEW 3 cited by
A Critique of ANSI SQL Isolation Levels
Not yet reviewed by Pith; the record is open.
This paper has not been read by Pith yet. Machine review is queued; the pith claim, tier, and objections will appear here once it completes.
SPECIMEN: schema-true, not a live event
T0 review · schema-true
One-sentence machine reading of the paper's core claim.
pith:XXXXXXXX · record.json · timestamp
A Critique of ANSI SQL Isolation Levels
read the original abstract
ANSI SQL-92 defines Isolation Levels in terms of phenomena: Dirty Reads, Non-Repeatable Reads, and Phantoms. This paper shows that these phenomena and the ANSI SQL definitions fail to characterize several popular isolation levels, including the standard locking implementations of the levels. Investigating the ambiguities of the phenomena leads to clearer definitions; in addition new phenomena that better characterize isolation types are introduced. An important multiversion isolation type, Snapshot Isolation, is defined.
Forward citations
Cited by 3 Pith papers
-
MemTX: Transactional Belief Commit for Stateful Agent Memory
Staging agent-memory writes through a validate-and-commit pipeline with maturity-gated irreversible actions and typed cascading repair yields zero realized downstream harm on five LLM backbones, where eight baselines ...
-
Versioned Late Materialization for Ultra-Long Sequence Training in Recommendation Systems at Scale
Versioned late materialization stores user histories once and reconstructs sequences just-in-time during training to cut redundancy and enable longer sequences in large-scale recommendation systems.
-
Versioned Late Materialization for Ultra-Long Sequence Training in Recommendation Systems at Scale
Introduces versioned late materialization to eliminate data redundancy in ultra-long sequence training for DLRMs by storing histories once and reconstructing via pointers at training time.
discussion (0)
Sign in with ORCID, Apple, or X to comment. Anyone can read and Pith papers without signing in.