Topic
Acid
Learn Acid as a connected topic across chapters, concepts, simulations, and interview reasoning.
10 Concepts9 Articles3h 52m
Overview
Learn Acid as a connected topic across chapters, concepts, simulations, and interview reasoning.
How this topic helps
Distributed Systems
System Design
Transactions
Databases
Learning Path in this Topic
Series that contain articles from Acid. Select a path to filter the article list.
Articles
9 matched articles
Article 1ACID Properties Explained: How SQL Databases Guarantee Atomicity, Consistency, Isolation, and DurabilityTLDR: ACID is four orthogonal guarantees that every SQL transaction must provide. Atomicity says all-or-nothing: PostgreSQL implements it via WAL rollback; MySQL InnoDB via undo logs. Consistency says38 min
Article 2ACID Transactions in Distributed Databases: DynamoDB, Cosmos DB, and Spanner ComparedTLDR: ACID transactions in distributed databases are not equal. DynamoDB provides multi-item atomicity scoped to 25 items using two-phase commit with a coordinator item, but only within a single regio39 min
Article 3Isolation Levels in Databases: Read Committed, Repeatable Read, Snapshot, and Serializable ExplainedTLDR: Isolation levels control which concurrency anomalies a transaction can see. Read Committed (PostgreSQL and Oracle's default) prevents dirty reads but still silently allows non-repeatable reads, 28 min
Article 4BASE Theorem Explained: How it Stands Against ACIDTLDR
TLDR: ACID (Atomicity, Consistency, Isolation, Durability) is the gold standard for banking. BASE (Basically Available, Soft state, Eventual consistency) is the standard for social media. BASE i14 minArticle 5Reading and Writing Data in Spark: Parquet, Delta, JSON, and JDBCTLDR: Parquet's columnar layout with row-group statistics enables predicate pushdown that can reduce a 500 GB scan to 8 GB. Delta Lake wraps Parquet with a JSON transaction log to add ACID semantics a34 min
Article 6Modern Table Formats: Delta Lake vs Apache Iceberg vs Apache HudiTLDR: Delta Lake, Apache Iceberg, and Apache Hudi are open table formats that wrap Parquet files with a transaction log (or snapshot tree) to deliver ACID guarantees, time travel, schema evolution, an24 minPage 1 of 2