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/
Some tribes of the programmer clan.