DBScholar

Back to papers

The Dangers of Replication and a Solution

Summary: Update-anywhere replication becomes unstable as workload scales; 10x nodes/traffic yields 1000x deadlocks and reconciliations. A master-copy, two-tier algorithm lets mobile/disconnected clients propose tentative updates later applied to the master; commutative updates avoid instability, per a simple analytic model. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hbe584c4d3f2cfd93
Venue
SIGMOD
Year
1996
Pagerank
0.00027270353
Overall Rank
165 | 98.90%
DOI
10.1145/233269.233330

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{gray_sigmod96,
        title = {{The Dangers of Replication and a Solution}},
        author = {Gray, Jim and Helland, Pat and O'Neil, Patrick and Shasha, Dennis},
        series = {{SIGMOD} '96},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/233269.233330},
        url = {https://dl.acm.org/doi/10.1145/233269.233330},
        year = {1996}
}

Incoming Citations (Sorted by Pagerank)

Showing 48 of 48 citing papers.

Rank Citing Paper Year Venue Pagerank
127 The Design of the Borealis Stream Processing Engine 2005 CIDR 0.00030427614
139 Megastore: Providing Scalable, Highly Available Storage for Interactive Services 2011 CIDR 0.00029480065
543 Socrates: The New SQL Server in the Cloud 2019 SIGMOD 0.0001663263
775 Lazy Database Replication with Snapshot Isolation 2006 VLDB 0.00014081697
781 The Case for Determinism in Database Systems 2010 VLDB 0.000140247
1,125 FlashLogging: Exploiting Flash Devices for Synchronous Logging Performance 2009 SIGMOD 0.00011926907
1,168 Fast Algorithms for Maintaining Replica Consistency in Lazy Master Replicated Databases 1999 VLDB 0.00011729718
1,245 Consistency Analysis in Bloom: a CALM and Collected Approach 2011 CIDR 0.00011353116
1,430 Middleware-based Database Replication: The Gaps Between Theory and Practice 2008 SIGMOD 0.00010685477
1,577 Blockchain Meets Database: Design and Implementation of a Blockchain Relational Database 2019 VLDB 0.00010189541
1,693 Aria: A Fast and Practical Deterministic OLTP Database 2020 VLDB 9.8567076e-05
1,704 SLOG: Serializable, Low-latency, Geo-replicated Transactions 2019 VLDB 9.8314656e-05
1,755 Offering a Precision-Performance Tradeoff for Aggregation Queries over Replicated Data 2000 VLDB 9.7206727e-05
1,787 Middleware based Data Replication providing Snapshot Isolation 2005 SIGMOD 9.6323981e-05
1,828 Fault-Tolerance in the Borealis Distributed Stream Processing System 2005 SIGMOD 9.5516021e-05
1,939 Performance and Resource Modeling in Highly-Concurrent OLTP Workloads 2013 SIGMOD 9.3331247e-05
2,411 Towards Elastic Transactional Cloud Storage with Range Query Support 2010 VLDB 8.5108707e-05
2,489 FAS - a Freshness-Sensitive Coordination Middleware for a Cluster of OLAP Components 2002 VLDB 8.3968758e-05
2,529 Update Propagation Protocols For Replicated Databases 1999 SIGMOD 8.3391988e-05
2,922 Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads 2017 VLDB 7.8519075e-05
3,071 Database Replication: a Tale of Research across Communities 2010 VLDB 7.6809448e-05
3,093 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD 7.6559585e-05
3,270 Rethinking Database High Availability with RDMA Networks 2019 VLDB 7.475162e-05
3,454 Locating Data Sources in Large Distributed Systems 2003 VLDB 7.2892132e-05
3,496 How to Build a Non-Volatile Memory Database Management System 2017 SIGMOD 7.2557397e-05
4,013 Quantifying Isolation Anomalies 2009 VLDB 6.8548837e-05
4,261 MorphoSys: Automatic Physical Design Metamorphosis for Distributed Database Systems 2020 VLDB 6.6992113e-05
4,975 RemusDB: Transparent High Availability for Database Systems 2011 VLDB 6.3313133e-05
5,173 Cache-and-Query for Wide Area Sensor Databases 2003 SIGMOD 6.243639e-05
5,806 Fine-Grained Replication and Scheduling with Freshness and Correctness Guarantees 2005 VLDB 5.988633e-05
6,024 Replication, Consistency, and Practicality: Are These Mutually Exclusive? 1998 SIGMOD 5.9120453e-05
6,272 Replication and Consistency: Being Lazy Helps Sometimes 1997 PODS 5.8278403e-05
6,611 Madeus: Database Live Migration Middleware under Heavy Workloads for Cloud Environment 2015 SIGMOD 5.7349419e-05
6,948 Serializable Snapshot Isolation for Replicated Databases in High-Update Scenarios 2011 VLDB 5.6368322e-05
7,221 Two Birds With One Stone: Designing a Hybrid Cloud Storage Engine for HTAP 2024 VLDB 5.5828002e-05
7,414 FoundationDB Record Layer: A Multi-Tenant Structured Datastore 2019 SIGMOD 5.533302e-05
8,292 Scalar DL: Scalable and Practical Byzantine Fault Detection for Transactional Database Systems 2022 VLDB 5.3612871e-05
8,452 How can we support Grid Transactions? Towards Peer-to-Peer Transaction Processing* 2005 CIDR 5.3350162e-05
9,075 Vertically Autoscaling Monolithic Applications with CaaSPER: Scalable Container-as-a-Service Performance Enhanced Resizing Algorithm for the Cloud 2024 SIGMOD 5.2283159e-05
9,465 Executing Long-Running Transactions in Synchronization-Free Main Memory Database Systems 2013 CIDR 5.1726081e-05
11,104 CRDV: Conflict-free Replicated Data Views 2025 SIGMOD 4.9793485e-05
11,462 Chablis: Fast and General Transactions in Geo-Distributed Systems 2024 CIDR 4.9793485e-05
11,658 Eventual Durability 2024 VLDB 4.9793485e-05
11,844 Confidence Bounded Replica Currency Estimation 2022 SIGMOD 4.9793485e-05
12,410 Purity: Building Fast, Highly-Available Enterprise Flash Storage from Commodity Components 2015 SIGMOD 4.9793485e-05
12,825 Pangea: An Eager Database Replication Middleware guaranteeing Snapshot Isolation without Modification of Database Servers 2009 VLDB 4.9793485e-05
13,012 A Scalability Service for Dynamic Web Applications 2005 CIDR 4.9793485e-05
14,506 Lessons from Wall Street: case studies in configuration, tuning, and distribution 1997 SIGMOD -
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
19 A Critique of ANSI SQL Isolation Levels 1995 SIGMOD 0.00058781151
810 The Datacycle Architecture for Very High Throughput Database Systems 1987 SIGMOD 0.00013757316
Previous Page 1 / 1 Next

Semantically Similar Papers