This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Consistency Tradeoffs in Modern Distributed Database System Design: CAP is Only Part of the Story
Feb. 2012 (vol. 45 no. 2)
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.

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; http://cacm.acm.org/blogs/blog-cacm83396-errors-in-database-systems-eventual-consistency-and-the-cap-theorem.
9. J. Brutlag, "Speed Matters for Google Web Search," unpublished paper, 22 June 2009, Google; http://code.google.com/speed/filesdelayexp.pdf .
10. L. Lamport, Generalized Consensus and Paxos, tech. report MSR-TR-2005-33, Microsoft Research, 2005; ftp://ftp. research.microsoft.com/pub/tr 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.

Index Terms:
CAP theorem, database architectures, computer systems organization, networking and information technology, distributed database systems
Citation:
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
Usage of this product signifies your acceptance of the Terms of Use.