hello, Friend in My Previous post we discussed Transaction Commands COMMIT and ROLLBACK.
Today we talk about transaction property. The transaction has Four property which is available below
Transaction
Property :
-Atomicity
-Consistency
-Isolation
-Durability
Atomicity
:
ensure that all
operations within the work unit are completed successfully otherwise
the transaction is aborted at the point of failure and previous operations
are rolled back to their former state
for example in the application that passes data from the parent table to the child table. the
atomicity property is ensure that if data is sent from the parent successfully and received data successfully
Consistency :
Ensure that the database
property changes status upon
a successfully committed transaction.
for example in an application that transfers funds from one account to another account. the consistency
property ensures that the total value of funds in both accounts
is the same at the start and end of each transaction.
Isolation :
enable a transaction to
operate independently and transparent to each other
for example in an application that transfers funds from one account to another. the isolation
property is ensure that another transaction sees
the transferred funds in one account or another the other,
but not in both nor in neither.
Durability :
Ensure that the result
or effect of the committed transaction persists in case of a system
failure
