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

Learn how to create flexible schemas in a relational database using SQL for JSON.

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.

Create flexible schemas using dynamic columns for semi-structured data. Learn how.

database ,nosql ,sql ,cap theory

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}