It's not always easy to maintain this ACID consistency - especially as databases become widely distributed and replicated across multiple data centers. In 2000, Eric Brewer outlined the "CAP" theorem, ...