Ask
Login
0
17kviews
What is recoverable schedule? Why recoverability of schedule is desirable? Explain recovery with concurrent transaction.
written 8.3 years ago by gravatar for teamques10 teamques10 ★ 67k modified 2.7 years ago by gravatar for pedsangini276 pedsangini276 • 4.8k

Mumbai University > Computer Engineering > Sem 4 > Database Management System

Marks: 10M

Year: May 2015
database management systems
ADD COMMENT EDIT
1 Answer
1
336views
written 8.3 years ago by gravatar for teamques10 teamques10 ★ 67k
  • A recoverable schedule is one where, for each pair of Transaction Ti and Tj such that Tj reads data item previously written by Ti the commit operation of Ti appears before the commit operation Tj .
$T_8$ $T_9$
read(A) $T_9$ is dependent on $T_8$
write(A) Non recoverable schedule if $T_9$ …

Create a free account to keep reading this post.

and 4 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.