What is a Transaction?
Transaction can be defined as the logical set of operations that are performed on the databases. It is similar to the transactions that are done by us in our daily lives. An example of a transaction in DBMS can be seen below.
T1 |
T2 |
---|---|
Read(A) | |
A=A-1000 | |
Write(A) | |
Read(B) | |
B=B+1000 | Read(A) |
Write(B) | Temp=A*0.01 |
commit | A=A-temp |
Write(A) | |
Read(B) | |
B=B+ temp | |
Write(B) | |
commit |
Cascading Rollback
Cascading rollback is a term that is used in DBMS. It is a concept that is explained in DBMS when we start discussing transactions.
So, let’s discuss briefly the basics that we require to know before studying cascading rollback.