Over a million developers have joined DZone.

CAP Theorem Poll: Which Two Do You Need?

DZone's Guide to

CAP Theorem Poll: Which Two Do You Need?

The CAP Theorem dictates that, out of Consistency, Availability, and Partition Tolerance, you can only pick two features at a time. Which two do you need?

· Database Zone
Free Resource

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

The CAP Theorem dictates that when you work in a database, you can have Consistency, Availability or Partition Tolerance, but only two of these features at a time.

For example, in NoSQL Systems, each database falls under combinations of two of the three categories:

For this week's poll, we want to know which two features you want. Remember, you have to forfeit the third, so if you choose consistency and availability, you'll be left without partition tolerance. You don't just have to use NoSQL, either. Give us your answer here! We'll be posting a survey result analysis next week.

It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate

database ,nosql ,sql ,cap theory

Opinions expressed by DZone contributors are their own.


Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.


{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}