Issue No.02 - Feb. (2012 vol.45)
pp: 37-42
Daniel J. Abadi , Yale University
The CAP theorem's impact on modern distributed database system design is more limited than is often perceived. Another tradeoff—between consistency and latency —has had a more direct influence on several well-known DDBSs. A proposed new formulation, PACELC, unifies this tradeoff with CAP.
CAP theorem, database architectures, computer systems organization, networking and information technology, distributed database systems
Daniel J. Abadi, "Consistency Tradeoffs in Modern Distributed Database System Design: CAP is Only Part of the Story", Computer, vol.45, no. 2, pp. 37-42, Feb. 2012, doi:10.1109/MC.2012.33
1. G. DeCandia et al., "Dynamo: Amazon's Highly Available Key-Value Store," Proc. 21st ACM SIGOPS Symp. Operating Systems Principles (SOSP 07), ACM, 2007, pp. 205-220.
2. A. Lakshman and P. Malik, "Cassandra: Structured Storage System on a P2P Network," Proc. 28th ACM Symp. Principles of Distributed Computing (PODC 09), ACM, 2009, article no. 5; doi:10.1145/1582716.1582722.
3. B.F. Cooper et al., "PNUTS: Yahoo!'s Hosted Data Serving Platform," Proc. VLDB Endowment (VLDB 08), ACM, 2008, pp. 1277-1288.
4. F. Chang et al., "Bigtable: A Distributed Storage System for Structured Data," Proc. 7th Usenix Symp. Operating Systems Design and Implementation (OSDI 06), Usenix, 2006, pp. 205-218.
5. M. Stonebraker et al., "The End of an Architectural Era (It's Time for a Complete Rewrite)," Proc. VLDB Endowment (VLDB 07), ACM, 2007, pp. 1150-1160.
6. J. Baker et al., "Megastore: Providing Scalable, Highly Available Storage for Interactive Services," Proc. 5th Biennial Conf. Innovative Data Systems Research (CIDR 11), ACM, 2011, pp. 223-234.
7. S. Gilbert and N. Lynch, "Brewer's Conjecture and the Feasibility of Consistent, Available, Partition-Tolerant Web Services," ACM SIGACT News, June 2002, pp. 51-59.
8. M. Stonebraker, "Errors in Database Systems, Eventual Consistency, and the CAP Theorem," blog, Comm. ACM,5 Apr. 2010;
9. J. Brutlag, "Speed Matters for Google Web Search," unpublished paper, 22 June 2009, Google; .
10. L. Lamport, Generalized Consensus and Paxos, tech. report MSR-TR-2005-33, Microsoft Research, 2005; ftp://ftp. TR-2005-33.pdf.
11. H. Attiya, A. Bar-Noy, and D. Dolev, "Sharing Memory Robustly in Message-Passing Systems," JACM, Jan. 1995, pp. 124-142.
12. J. Rao, E.J. Shekita, and S. Tata, "Using Paxos to Build a Scalable, Consistent, and Highly Available Datastore," Proc. VLDB Endowment (VLDB 11), ACM, 2011, pp. 243-254.
13. H. Wada et al., "Data Consistency Properties and the Trade-offs in Commercial Cloud Storage: The Consumers' Perspective," Proc. 5th Biennial Conf. Innovative Data Systems Research (CIDR 11), ACM, 2011, pp. 134-143.