Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

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

Built by the engineers behind Netezza and the technology behind Amazon Redshift, AnzoGraph is a native, Massively Parallel Processing (MPP) distributed Graph OLAP (GOLAP) database that executes queries more than 100x faster than other vendors.  

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.

Download AnzoGraph now and find out for yourself why it is acknowledged as the most complete all-in-one data warehouse for BI style and graph analytics.  

Topics:
database ,nosql ,sql ,cap theory

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}