NoSQL BASE vs SQL ACID

SQL
http://www.postgresql.org/docs/8.4/static/explicit-locking.html#LOCKING-TABLES

Atomicity : all or nothing (rollback)
Coherence : coherent before, coherent after
Isolation: not impacted by others?
Durability : commit, if it's done, it's really done

Atomicity: tất cả hoặc không có gì (rollback)
Coherence: mạch lạc trước, mạch lạc sau
Cách ly: không bị ảnh hưởng bởi những người khác?
Độ bền: cam kết, nếu nó được thực hiện, nó thực sự thực hiện

http://stackoverflow.com/questions/4659422/locking-mysql-tables-rows

NoSQL
http://www.martinfowler.com/tags/noSQL.html

Basic Availability

• The database appears to work most of the time.

Soft-state

• Stores don’t have to be write-consistent, nor do different replicas have to be mutually consistent all the time.

Eventual consistency

• Stores exhibit consistency at some later point (e.g., lazily at read time).

http://neo4j.com/blog/acid-vs-base-consistency-models-explained/