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.00027257943
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.00030414379
139 Megastore: Providing Scalable, Highly Available Storage for Interactive Services 2011 CIDR 0.00029466567
543 Socrates: The New SQL Server in the Cloud 2019 SIGMOD 0.00016624903
777 Lazy Database Replication with Snapshot Isolation 2006 VLDB 0.00014075407
782 The Case for Determinism in Database Systems 2010 VLDB 0.00014018588
1,124 FlashLogging: Exploiting Flash Devices for Synchronous Logging Performance 2009 SIGMOD 0.00011923526
1,169 Fast Algorithms for Maintaining Replica Consistency in Lazy Master Replicated Databases 1999 VLDB 0.0001172435
1,248 Consistency Analysis in Bloom: a CALM and Collected Approach 2011 CIDR 0.00011347831
1,430 Middleware-based Database Replication: The Gaps Between Theory and Practice 2008 SIGMOD 0.00010680747
1,577 Blockchain Meets Database: Design and Implementation of a Blockchain Relational Database 2019 VLDB 0.00010184718
1,694 Aria: A Fast and Practical Deterministic OLTP Database 2020 VLDB 9.8520416e-05
1,704 SLOG: Serializable, Low-latency, Geo-replicated Transactions 2019 VLDB 9.8268213e-05
1,756 Offering a Precision-Performance Tradeoff for Aggregation Queries over Replicated Data 2000 VLDB 9.7161465e-05
1,787 Middleware based Data Replication providing Snapshot Isolation 2005 SIGMOD 9.6279445e-05
1,829 Fault-Tolerance in the Borealis Distributed Stream Processing System 2005 SIGMOD 9.5470848e-05
1,940 Performance and Resource Modeling in Highly-Concurrent OLTP Workloads 2013 SIGMOD 9.3298436e-05
2,412 Towards Elastic Transactional Cloud Storage with Range Query Support 2010 VLDB 8.5070443e-05
2,489 FAS - a Freshness-Sensitive Coordination Middleware for a Cluster of OLAP Components 2002 VLDB 8.3929331e-05
2,530 Update Propagation Protocols For Replicated Databases 1999 SIGMOD 8.3354416e-05
2,922 Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads 2017 VLDB 7.8496897e-05
3,073 Database Replication: a Tale of Research across Communities 2010 VLDB 7.6774646e-05
3,095 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD 7.6523803e-05
3,271 Rethinking Database High Availability with RDMA Networks 2019 VLDB 7.4716945e-05
3,454 Locating Data Sources in Large Distributed Systems 2003 VLDB 7.2857626e-05
3,496 How to Build a Non-Volatile Memory Database Management System 2017 SIGMOD 7.2523692e-05
4,014 Quantifying Isolation Anomalies 2009 VLDB 6.8516388e-05
4,261 MorphoSys: Automatic Physical Design Metamorphosis for Distributed Database Systems 2020 VLDB 6.6960399e-05
4,977 RemusDB: Transparent High Availability for Database Systems 2011 VLDB 6.3283589e-05
5,174 Cache-and-Query for Wide Area Sensor Databases 2003 SIGMOD 6.2406834e-05
5,807 Fine-Grained Replication and Scheduling with Freshness and Correctness Guarantees 2005 VLDB 5.9857995e-05
6,025 Replication, Consistency, and Practicality: Are These Mutually Exclusive? 1998 SIGMOD 5.909328e-05
6,277 Replication and Consistency: Being Lazy Helps Sometimes 1997 PODS 5.8251026e-05
6,615 Madeus: Database Live Migration Middleware under Heavy Workloads for Cloud Environment 2015 SIGMOD 5.7322298e-05
6,951 Serializable Snapshot Isolation for Replicated Databases in High-Update Scenarios 2011 VLDB 5.6341647e-05
7,223 Two Birds With One Stone: Designing a Hybrid Cloud Storage Engine for HTAP 2024 VLDB 5.5801574e-05
7,417 FoundationDB Record Layer: A Multi-Tenant Structured Datastore 2019 SIGMOD 5.5306924e-05
8,298 Scalar DL: Scalable and Practical Byzantine Fault Detection for Transactional Database Systems 2022 VLDB 5.3587491e-05
8,461 How can we support Grid Transactions? Towards Peer-to-Peer Transaction Processing* 2005 CIDR 5.3324907e-05
9,084 Vertically Autoscaling Monolithic Applications with CaaSPER: Scalable Container-as-a-Service Performance Enhanced Resizing Algorithm for the Cloud 2024 SIGMOD 5.2258409e-05
9,476 Executing Long-Running Transactions in Synchronization-Free Main Memory Database Systems 2013 CIDR 5.1701594e-05
11,113 CRDV: Conflict-free Replicated Data Views 2025 SIGMOD 4.9769913e-05
11,468 Chablis: Fast and General Transactions in Geo-Distributed Systems 2024 CIDR 4.9769913e-05
11,664 Eventual Durability 2024 VLDB 4.9769913e-05
11,850 Confidence Bounded Replica Currency Estimation 2022 SIGMOD 4.9769913e-05
12,416 Purity: Building Fast, Highly-Available Enterprise Flash Storage from Commodity Components 2015 SIGMOD 4.9769913e-05
12,831 Pangea: An Eager Database Replication Middleware guaranteeing Snapshot Isolation without Modification of Database Servers 2009 VLDB 4.9769913e-05
13,018 A Scalability Service for Dynamic Web Applications 2005 CIDR 4.9769913e-05
14,511 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.00058759613
810 The Datacycle Architecture for Very High Throughput Database Systems 1987 SIGMOD 0.00013750892
Previous Page 1 / 1 Next

Semantically Similar Papers