14 - Database Recovery (Lecture Session-15) Chapters 19...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Database Recovery (Lecture Session-15) Chapters 19 Wed, Feb 24, 2010 1 DLPD, BI TS-Pilani. Prepared by Dr.R. Gururaj, Asst.Professor of CS Wed, Feb 24, 2010 DLPD, BI TS-Pilani. Prepared by Dr.R. Gururaj, Asst.Professor of CS 2 • Introduction to Database Recovery • Log-based Recovery • Deferred modification • Immediate Modification • Checkpointing • Shadow paging Contents Wed, Feb 24, 2010 DLPD, BI TS-Pilani. Prepared by Dr.R. Gururaj, Asst.Professor of CS 3 Data prior to execution of transaction Exe. of transaction. Data may be in inconsistent state After Execution of the transaction Consistent state Difficulties when failure occur in the process Goes to next consistent state As a result of failure, state of the system will not reflect the state of the real world that the database is supposed to capture. We call that state as inconsistent state . It is important to define transactions such that they preserve consistency. Wed, Feb 24, 2010 DLPD, BI TS-Pilani. Prepared by Dr.R. Gururaj, Asst.Professor of CS 4 Recovery Techniques If a transaction T performed multiple database modifications, several output operations may be required and a failure may occur after some of these modifications have been made but before all of them are made. In order to ensure atomicity property we must first output the information describing the modifications to stable storage without modifying the database itself. This helps us to output all modifications of a committed transaction. Now we discuss same important recovery techniques. Wed, Feb 24, 2010 DLPD, BI TS-Pilani. Prepared by Dr.R. Gururaj, Asst.Professor of CS 5 Database log: Each log record describes a single database write operation and contains the following details....
View Full Document

This note was uploaded on 03/14/2010 for the course CSE IS ZC332 taught by Professor Shailendrasshekhawat during the Summer '10 term at Birla Institute of Technology & Science.

Page1 / 16

14 - Database Recovery (Lecture Session-15) Chapters 19...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online