ACID support varies per solution

better in partition tollerance

better for clustered systems

good for semi-structured data

JOINS are not mandatory

relational

scales well horizontally

strict schema

full support of JOINS

good for structured data

stores data in a table

dynamic or flexivle schemas

fully supports ACID

new data properties can be added on the fly

Relationships are often captured by denormalizing data and presenting it in a single record

scales well vertically