Schedule 1 Let T transfer $50 from A to B,and T,transfer 10%of the balance from A to B. An example of a serial schedule in which T1 is followed by 72: T T2 read(A) A:=A-50 write(A) read(B) B=B+50 write(B) commit read (A) temp :=A*0.1 A:=A-temp write(A) read(B) B:=B+temp write(B) commit Database System Concepts-6th Edition 14.12 @Silberschatz,Korth and Sudarshan
Database System Concepts - 6 14.12 ©Silberschatz, Korth and Sudarshan th Edition Schedule 1 Let T1 transfer $50 from A to B, and T2 transfer 10% of the balance from A to B. An example of a serial schedule in which T1 is followed by T2 :
Schedule 2 A serial schedule in which T2 is followed by T1: T T2 read(A) temp:=A*0.1 A:=A-temp write(A) read(B) B:=B+temp write(B) commit read (A) A:=A-50 write(A) read(B) B:=B+50 write(B) commit Database System Concepts-6th Edition 14.13 ©Silberschat乜，Korth and Sudarshan
Database System Concepts - 6 14.13 ©Silberschatz, Korth and Sudarshan th Edition Schedule 2 A serial schedule in which T2 is followed by T1 :