2,419 views

1 Answer

Best answer
4 votes
4 votes

Immediate update Method :

 Database may be updated by some operations of a transaction before the transaction reaches its commit point.
These operations are typically recorded in the log on disk by force writing before applied

If a transaction fail after recording some change to the database, but before commit point, the effect of its operations on the database must be undone (transaction must be rollback)

Need both undo and redo in recovery .Immediate update is known as “UNDO/REDO Algorithm”to the database.

If fail occurs .The executing (active) transaction at the time of failure may have recorded some Changes in the database. The effect must be undone.

Answer : Immediate updates as a recovery protocol is preferable, when : Writes are more than reads .

selected by

Related questions

2 votes
2 votes
4 answers
1
himanich asked Jun 29, 2016
1,929 views
0 votes
0 votes
1 answer
2
Deepalitrapti asked Aug 17, 2018
1,221 views
3 votes
3 votes
2 answers
3
pream sagar asked Jun 1, 2018
4,211 views
If schedule is Serializable then free from WW, RW,WR .But Lost update may be possible .please explain how in serializable schedule lost update problem still exist.