Applying Transaction Rules
Transactions must follow four rules, called the ACID (Atomicity, Consistency, Isolation, Durability) properties. If any of these rules are violated, the sequence of operations does not qualify as a transaction.
ACID is an acronym for properties that are used to characterize transactions (Atomicity, Consistency, Isolation, Durability).
Atomicity
Atomicity is the all or nothing rule for transactions. Transactions must be indivisible. What do I mean by indivisible? Remember that transactions are a sequence of actions—most often database actions such as inserts, updates, and deletes to the database tables. If one of these actions fails, none of them are applied to the database. The entire sequence of actions and operations ...
Get Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
