What is recoverable schedule? Why recoverability of schedule is desirable? Explain recovery with concurrent transaction.

18kviews

written 9.4 years ago by

teamques10 ★ 70k

modified 3.8 years ago by

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

339views

written 9.4 years ago by

teamques10 ★ 70k

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.