Chapter 8: Transactions — DDIA References

Reference 1 in Chapter 8: What Went Wrong with Horizon: Learning from the Post Office Trial

Steven J. Murdoch

2021

benthamsgaze.org

Reference 2 in Chapter 8: A History and Evaluation of System R

Donald D. Chamberlin, Morton M. Astrahan, Michael W. Blasgen and 13 others

Communications of the ACM 1981

dsf.berkeley.edu PDF doi

Reference 3 in Chapter 8: Granularity of Locks and Degrees of Consistency in a Shared Data Base

Jim N. Gray, Raymond A. Lorie, Gianfranco R. Putzolu and Irving L. Traiger

Modelling in Data Base Management Systems: Proceedings of the IFIP Working Conference on Modelling in Data Base Management Systems 2005

citeseerx.ist.psu.edu

Reference 4 in Chapter 8: CockroachDB: The Resilient Geo-Distributed SQL Database

Rebecca Taft, Irfan Sharif, Andrei Matei and 14 others

ACM SIGMOD International Conference on Management of Data 2020

dl.acm.org doi

Reference 5 in Chapter 8: TiDB: A Raft-Based HTAP Database

Dongxu Huang, Qi Liu, Qiu Cui and 19 others

Proceedings of the VLDB Endowment 2020

vldb.org PDF doi

Reference 6 in Chapter 8: Spanner: Google’s Globally-Distributed Database

10th USENIX Symposium on Operating System Design and Implementation 2012

research.google

Reference 7 in Chapter 8: FoundationDB: A Distributed Unbundled Transactional Key Value Store

Jingyu Zhou, Meng Xu, Alexander Shraer and 18 others

ACM International Conference on Management of Data 2021

foundationdb.org PDF doi

Reference 8 in Chapter 8: Principles of Transaction-Oriented Database Recovery

Theo Härder and Andreas Reuter

ACM Computing Surveys 1983

citeseerx.ist.psu.edu doi

Reference 9 in Chapter 8: HAT, not CAP: Towards Highly Available Transactions

Peter Bailis, Alan Fekete, Ali Ghodsi and 2 others

14th USENIX Workshop on Hot Topics in Operating Systems 2013

usenix.org PDF

Reference 10 in Chapter 8: Cluster-Based Scalable Network Services

Armando Fox, Steven D. Gribble, Yatin Chawathe and 2 others

16th ACM Symposium on Operating Systems Principles 1997

people.eecs.berkeley.edu PDF gone doi

Reference 11 in Chapter 8: Enforcing Complex Constraints in Oracle

Tony Andrews

tonyandrews.blogspot.co.uk 2004

tonyandrews.blogspot.com

Reference 12 in Chapter 8: Concurrency Control and Recovery in Database Systems

Philip A. Bernstein, Vassos Hadzilacos and Nathan Goodman

1987

microsoft.com

Reference 13 in Chapter 8: Making Snapshot Isolation Serializable

Alan Fekete, Dimitrios Liarokapis, Elizabeth O'Neil and 2 others

ACM Transactions on Database Systems 2005

cse.iitb.ac.in PDF doi

Reference 14 in Chapter 8: Understanding the Robustness of SSDs Under Power Fault

Mai Zheng, Joseph Tucek, Feng Qin and Mark Lillibridge

11th USENIX Conference on File and Storage Technologies 2013

usenix.org PDF

Reference 15 in Chapter 8: SSDs: A Gift and a Curse

Laurie Denness

2015

laur.ie gone archived copy

Reference 16 in Chapter 8: When Solid State Drives Are Not That Solid

Adam Surak

blog.algolia.com 2015

algolia.com

Reference 17 in Chapter 8: Bulletin: (Revision) HPE SAS Solid State Drives—Critical Firmware Upgrade Required for Certain HPE SAS Solid State Drive Models to Prevent Drive Failure at 32,768 Hours of Operation

Hewlett Packard Enterprise

2019

support.hpe.com

Reference 18 in Chapter 8: PostgreSQL's Handling of fsync() Errors Is Unsafe and Risks Data Loss at Least on XFS

Craig Ringer et al

pgsql-hackers 2018

postgresql.org

Reference 19 in Chapter 8: Can Applications Recover from fsync Failures?

Anthony Rebello, Yuvraj Patel, Ramnatthan Alagappan and 2 others

USENIX Annual Technical Conference 2020

usenix.org

Reference 20 in Chapter 8: Crash Consistency: Rethinking the Fundamental Abstractions of the File System

Thanumalayan Sankaranarayana Pillai, Vijay Chidambaram, Ramnatthan Alagappan and 3 others

ACM Queue 2015

dl.acm.org doi

Reference 21 in Chapter 8: All File Systems Are Not Created Equal: On the Complexity of Crafting Crash-Consistent Applications

Thanumalayan Sankaranarayana Pillai, Vijay Chidambaram, Ramnatthan Alagappan and 3 others

11th USENIX Symposium on Operating Systems Design and Implementation 2014

usenix.org PDF

Reference 22 in Chapter 8: Unix's File Durability Problem

Chris Siebenmann

2016

utcc.utoronto.ca

Reference 23 in Chapter 8: Redundancy Does Not Imply Fault Tolerance: Analysis of Distributed Storage Reactions to Single Errors and Corruptions

Aishwarya Ganesan, Ramnatthan Alagappan, Andrea C. Arpaci-Dusseau and Remzi H. Arpaci-Dusseau

15th USENIX Conference on File and Storage Technologies 2017

usenix.org

Reference 24 in Chapter 8: An Analysis of Data Corruption in the Storage Stack

Lakshmi N. Bairavasundaram, Garth R. Goodson, Bianca Schroeder and 2 others

6th USENIX Conference on File and Storage Technologies 2008

usenix.org PDF

Reference 25 in Chapter 8: How We Discovered, and Recovered from, Postgres Corruption on the matrix.org Homeserver

Richard van der Hoff

2025

matrix.org

Reference 26 in Chapter 8: Flash Reliability in Production: The Expected and the Unexpected

Bianca Schroeder, Raghav Lagisetty and Arif Merchant

14th USENIX Conference on File and Storage Technologies 2016

usenix.org

Reference 27 in Chapter 8: SSD Storage—Ignorance of Technology Is No Excuse

Don Allison

2015

blog.korelogic.com

Reference 28 in Chapter 8: Debunked: Your SSD Won’T Lose Data If Left Unplugged After All

Gordon Mah Ung

2015

pcworld.com

Reference 29 in Chapter 8: Hermitage: Testing the 'I' in ACID

Martin Kleppmann

2014

martin.kleppmann.com

Reference 30 in Chapter 8: The Race Condition That Led to Flexcoin Bankruptcy

Vlad Mihalcea

2025

vladmihalcea.com

Reference 31 in Chapter 8: ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications

Todd Warszawski and Peter Bailis

ACM International Conference on Management of Data 2017

bailis.org PDF doi

Reference 32 in Chapter 8: BTC Stolen from Poloniex

Tristan D'Agosta

2014

bitcointalk.org

Reference 33 in Chapter 8: How I Stole Roughly 100 BTC from an Exchange and How I Could Have Stolen More!

bitcointhief2

2014

reddit.com

Reference 34 in Chapter 8: Automating the Detection of Snapshot Isolation Anomalies

Sudhir Jorwekar, Alan Fekete, Krithi Ramamritham and S. Sudarshan

33rd International Conference on Very Large Data Bases 2007

vldb.org PDF

Reference 35 in Chapter 8: Transactions: The Limits of Isolation

Michael Melanson

2014

michaelmelanson.net

Reference 36 in Chapter 8: How ACH Works: A Developer Perspective—Part 1

Edward Kim

2014

engineering.gusto.com

Reference 37 in Chapter 8: A Critique of ANSI SQL Isolation Levels

Hal Berenson, Philip A. Bernstein, Jim N. Gray and 3 others

ACM International Conference on Management of Data 1995

microsoft.com PDF doi

Reference 38 in Chapter 8: Weak Consistency: A Generalized Theory and Optimistic Implementations for Distributed Transactions

Atul Adya

1999

pmg.csail.mit.edu PDF

Reference 39 in Chapter 8: Highly Available Transactions: Virtues and Limitations

Peter Bailis, Aaron Davidson, Alan Fekete and 3 others

Proceedings of the VLDB Endowment 2013

vldb.org PDF

Reference 40 in Chapter 8: Seeing Is Believing: A Client-Centric Specification of Database Isolation

Natacha Crooks, Youer Pu, Lorenzo Alvisi and Allen Clement

ACM Symposium on Principles of Distributed Computing 2017

cs.cornell.edu PDF doi

Reference 41 in Chapter 8: MVCC Unmasked

Bruce Momjian

2014

momjian.us PDF

Reference 42 in Chapter 8: MySQL 8.0.34

Peter Alvaro and Kyle Kingsbury

2023

jepsen.io

Reference 43 in Chapter 8: PostgreSQL 14 Internals

Egor Rogov

2023

postgrespro.com

Reference 44 in Chapter 8: The Internals of PostgreSQL

Hironobu Suzuki

2017

interdb.jp

Reference 45 in Chapter 8: Internals of MVCC in Postgres: Hidden Costs of Updates vs Inserts

Rohan Reddy Alleti

2025

medium.com

Reference 46 in Chapter 8: The Part of PostgreSQL We Hate the Most

Andy Pavlo and Bohan Zhang

2023

cs.cmu.edu

Reference 47 in Chapter 8: An Empirical Evaluation of In-Memory Multi-Version Concurrency Control

Yingjun Wu, Joy Arulraj, Jiexi Lin and 2 others

Proceedings of the VLDB Endowment 2017

vldb.org PDF doi

Reference 48 in Chapter 8: Unofficial Guide to Datomic Internals

Nikita Prokopov

2014

tonsky.me

Reference 49 in Chapter 8: A Practical Guide to Taming Postgres Isolation Anomalies

Daniil Svetlov

2025

dansvetlov.me

Reference 50 in Chapter 8: An Atomic Rant

Nate Wiger

2010

nateware.com

Reference 51 in Chapter 8: Reading and Writing, Part 3: Web Applications

James Coglan

2020

blog.jcoglan.com

Reference 52 in Chapter 8: Feral Concurrency Control: An Empirical Investigation of Modern Application Integrity

Peter Bailis, Alan Fekete, Michael J. Franklin and 3 others

ACM International Conference on Management of Data 2015

bailis.org PDF doi

Reference 53 in Chapter 8: Things I Wished More Developers Knew About Databases

Jaana Dogan

2020

rakyll.medium.com

Reference 54 in Chapter 8: Serializable Isolation for Snapshot Databases

Michael J. Cahill, Uwe Röhm and Alan Fekete

ACM International Conference on Management of Data 2008

cs.cornell.edu PDF doi

Reference 55 in Chapter 8: Serializable Snapshot Isolation in PostgreSQL

Dan R. K. Ports and Kevin Grittner

Proceedings of the VLDB Endowment 2012

drkp.net PDF

Reference 56 in Chapter 8: Managing Update Conflicts in Bayou, a Weakly Connected Replicated Storage System

Douglas B. Terry, Marvin M. Theimer, Karin Petersen and 3 others

15th ACM Symposium on Operating Systems Principles 1995

pdos.csail.mit.edu PDF gone doi

Reference 57 in Chapter 8: Constraints over Multiple Rows in PostgreSQL

Hans-Jürgen Schönig

2021

cybertec-postgresql.com

Reference 58 in Chapter 8: The End of an Architectural Era (It’s Time for a Complete Rewrite)

Michael Stonebraker, Samuel Madden, Daniel J. Abadi and 3 others

33rd International Conference on Very Large Data Bases 2007

vldb.org PDF

Reference 59 in Chapter 8: H-Store/VoltDB Architecture vs. CEP Systems and Newer Streaming Architectures

John Hugg

Data @Scale Boston 2014

youtube.com

Reference 60 in Chapter 8: H-Store: A High-Performance, Distributed Main Memory Transaction Processing System

Robert Kallman, Hideaki Kimura, Jonathan Natkins and 9 others

Proceedings of the VLDB Endowment 2008

vldb.org PDF

Reference 61 in Chapter 8: The Architecture of Datomic

Rich Hickey

2012

infoq.com

Reference 62 in Chapter 8: Debunking Myths About the VoltDB In-Memory Database

John Hugg

2014

dzone.com

Reference 63 in Chapter 8: Lotus: Scalable Multi-Partition Transactions On Single-Threaded Partitioned Databases

Xinjing Zhou, Xiangyao Yu, Goetz Graefe and Michael Stonebraker

Proceedings of the VLDB Endowment 2022

vldb.org PDF doi

Reference 64 in Chapter 8: Architecture of a Database System

Joseph M. Hellerstein, Michael Stonebraker and James Hamilton

Foundations and Trends in Databases 2007

dsf.berkeley.edu PDF doi

Reference 65 in Chapter 8: Serializable Isolation for Snapshot Databases

Michael J. Cahill

2009

ses.library.usyd.edu.au PDF

Reference 66 in Chapter 8: Hekaton: SQL Server's Memory-Optimized OLTP Engine

Cristian Diaconu, Craig Freedman, Erik Ismert and 5 others

ACM SIGMOD International Conference on Management of Data 2013

microsoft.com PDF doi

Reference 67 in Chapter 8: Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems

Thomas Neumann, Tobias Mühlbauer and Alfons Kemper

ACM SIGMOD International Conference on Management of Data 2015

db.in.tum.de PDF doi

Reference 68 in Chapter 8: Correctness of Concurrency Control and Implications in Distributed Databases

D. Z. Badal

3rd International IEEE Computer Software and Applications Conference 1979

ieeexplore.ieee.org doi

Reference 69 in Chapter 8: Concurrency Control Performance Modeling: Alternatives and Implications

Rakesh Agrawal, Michael J. Carey and Miron Livny

ACM Transactions on Database Systems 1987

people.eecs.berkeley.edu PDF gone doi

Reference 70 in Chapter 8: Snapshot Isolation vs. Serializability

Marc Brooker

2024

brooker.co.za

Reference 71 in Chapter 8: Notes on Distributed Databases

B. G. Lindsay, P. G. Selinger, C. Galtieri and 6 others

1979

dominoweb.draco.res.ibm.com PDF gone archived copy

Reference 72 in Chapter 8: Transaction Management in the R* Distributed Database Management System

C. Mohan, Bruce G. Lindsay and Ron Obermarck

ACM Transactions on Database Systems 1986

cs.brown.edu PDF doi

Reference 73 in Chapter 8: Distributed Transaction Processing: The XA Specification

X/Open Company Ltd

1991

pubs.opengroup.org PDF

Reference 74 in Chapter 8: Lessons Learned from Implementing WS-Coordination and WS-AtomicTransaction

Ivan Silva Neto and Francisco Reverbel

7th IEEE/ACIS International Conference on Computer and Information Science 2008

ime.usp.br PDF doi

Reference 75 in Chapter 8: Formal Specification of a Web Services Protocol

James E. Johnson, David E. Langworthy, Leslie Lamport and Friedrich H. Vogt

1st International Workshop on Web Services and Formal Methods 2004

microsoft.com doi

Reference 76 in Chapter 8: The Transaction Concept: Virtues and Limitations

Jim Gray

7th International Conference on Very Large Data Bases 1981

jimgray.azurewebsites.net PDF

Reference 77 in Chapter 8: Nonblocking Commit Protocols

Dale Skeen

ACM International Conference on Management of Data 1981

cs.utexas.edu PDF doi

Reference 78 in Chapter 8: Your Coffee Shop Doesn’t Use Two-Phase Commit

Gregor Hohpe

IEEE Software 2005

martinfowler.com PDF doi

Reference 79 in Chapter 8: Life Beyond Distributed Transactions: An Apostate’s Opinion

Pat Helland

3rd Biennial Conference on Innovative Data Systems Research 2007

cidrdb.org PDF

Reference 80 in Chapter 8: My Beef with MSDTC and Two-Phase Commits

Jonathan Oliver

2011

blog.jonathanoliver.com

Reference 81 in Chapter 8: The Fallacy of Distributed Transactions

Oren Eini (Ahende Rahien)

2014

ayende.com

Reference 82 in Chapter 8: Transactions in Windows Azure (with Service Bus)—An Email Discussion

Clemens Vasters

2012

learn.microsoft.com

Reference 83 in Chapter 8: Orphaned MSDTC Transactions (-2 spids)

Ajmer Dhariwal

2008

eraofdata.com

Reference 84 in Chapter 8: Real World Story of DBCC PAGE Saving the Day

Paul Randal

2013

sqlskills.com

Reference 85 in Chapter 8: Consistency and Completeness: Rethinking Distributed Stream Processing in Apache Kafka

Guozhang Wang, Lei Chen, Ayusman Dikshit and 9 others

ACM International Conference on Management of Data 2021

dl.acm.org doi