Data Properties and Transactions

About

This section is about:

• Data - Transaction (Trans(versal?) actions)
• Data Property - ACID (atomicity, consistency, isolation, durability)

transactions are the mechanism that guarantee data ACID (atomicity, consistency, isolation, durability) properties during concurrent data changes (ie multiple user or program changing the same data)

See also: Code Property

Weaker concurrency model

In practice, many DBMSs allow the selective relaxation of most of the ACID rules — for better performance or on a distributed system

• Distributed Database - CAP Theorem (Consistency, Availability, Partition Tolerance)
• Data Property - BASE (Basically Available)
• Distributed Database - Eventual consistency (Weak)