3
Reply

Explain ACID rule of thumb for transactions.

sai

sai

17y
8.1k
0
Reply

    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.

    17y
    0

    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

    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

    17y
    0