Explain ACID rule of thumb for transactions.

sai

18y

8.1k

Atomicity :- A transaction is a unit or work in which a series of operations occur between the BEGIN TRANSACTION and END TRANSACTION statments of an application. A transaction executes exactly once and is atomic - all the work is done or none of it is.

Consistency :- A transaction is a unit of integrity because it preserves the consistency of data, transforming one consistent state of data into another consistent state of data.

Isolation :- A transaction is a unit of isolation allowing concurrent transactions to executes and isolate one transaction from other transaction.

Durability :- A transaction is a unit of recovery. If a transaction succeeds, the system gurantees that it updates will persit, even if the computer crashes immediately after the commit.

18y

Atomocity: A trasaction is either competed(100%) or not at all completed(0%).

consistace: corrected data u have pass

isolation: each tranaction is indepent ie it's does not effect the other one

durability: transaction is not volatile

rahamanabdul shaik

18y

A transaction must be:

Atomic - it is one unit of work and does not dependent on previous and following transactions.
Consistent - data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t.
Isolated - no transaction sees the intermediate results of the current transaction).
Durable

18y