Transaction Management Notes | EduRev

: Transaction Management Notes | EduRev

 Page 1


Transaction 
Management 
Copyright @ www.bcanotes.com 
Page 2


Transaction 
Management 
Copyright @ www.bcanotes.com 
What is Transaction 
? It is a unit of Program that is in a Running 
Condition. 
 
? A set of changes that must all be made together. 
 
? It is a program unit whose execution may or may 
not change the Contents of Database. 
 
? It is executed as a single unit. 
  
Copyright @ www.bcanotes.com 
Page 3


Transaction 
Management 
Copyright @ www.bcanotes.com 
What is Transaction 
? It is a unit of Program that is in a Running 
Condition. 
 
? A set of changes that must all be made together. 
 
? It is a program unit whose execution may or may 
not change the Contents of Database. 
 
? It is executed as a single unit. 
  
Copyright @ www.bcanotes.com 
Example 
 A transfer of money from one bank 
account to another requires 2 changes to 
the database i.e. both must Succeed or 
Fail together. 
 For e.g. ATM money transfer (UPDATE 
commands to increase/decrease Balance). 
 
Copyright @ www.bcanotes.com 
Page 4


Transaction 
Management 
Copyright @ www.bcanotes.com 
What is Transaction 
? It is a unit of Program that is in a Running 
Condition. 
 
? A set of changes that must all be made together. 
 
? It is a program unit whose execution may or may 
not change the Contents of Database. 
 
? It is executed as a single unit. 
  
Copyright @ www.bcanotes.com 
Example 
 A transfer of money from one bank 
account to another requires 2 changes to 
the database i.e. both must Succeed or 
Fail together. 
 For e.g. ATM money transfer (UPDATE 
commands to increase/decrease Balance). 
 
Copyright @ www.bcanotes.com 
Processes of Transaction 
? Transaction is executed as a series of 
Reads and Writes of database objects 
which are: 
?Read Operation 
?Write Operation 
Copyright @ www.bcanotes.com 
Page 5


Transaction 
Management 
Copyright @ www.bcanotes.com 
What is Transaction 
? It is a unit of Program that is in a Running 
Condition. 
 
? A set of changes that must all be made together. 
 
? It is a program unit whose execution may or may 
not change the Contents of Database. 
 
? It is executed as a single unit. 
  
Copyright @ www.bcanotes.com 
Example 
 A transfer of money from one bank 
account to another requires 2 changes to 
the database i.e. both must Succeed or 
Fail together. 
 For e.g. ATM money transfer (UPDATE 
commands to increase/decrease Balance). 
 
Copyright @ www.bcanotes.com 
Processes of Transaction 
? Transaction is executed as a series of 
Reads and Writes of database objects 
which are: 
?Read Operation 
?Write Operation 
Copyright @ www.bcanotes.com 
Processes of Transaction… 
? Read Operation 
 Data object is first brought into Main 
Memory from Disk, and then value is 
copied into a Program. 
? Write Operation 
 Data base object copy in Main Memory is 
first modified then written to Disk. 
Copyright @ www.bcanotes.com 
Read More
Offer running on EduRev: Apply code STAYHOME200 to get INR 200 off on our premium plan EduRev Infinity!