CAP & Data Model

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/f9e22ff5-0de4-47e1-8563-3545f373d96f/Untitled.png

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/2816e4da-9ed0-42e6-90cb-0ac7e8ad4e21/Untitled.png

DBs in CAP theorem

CA

It’s no brainer that all RDBMS are Consistent as all reads and writes go to a single node/server.

RDBMS(MySQL, Oracle, MS SQL Server, etc)

We generally categorize RDBMS in CA. Because Relational databases are a single node system and hence we do not need to worry about partition tolerance and hence if RDBMS server is up and running, it will always respond success for any read/write operation.

CP

AP