Instant Recovery with Write-Ahead Logging : Page Repair, System Restart, and Media Restore
By: Graefe, Goetz.
Contributor(s): Guy, Wey | Sauer, Caetano.Material type: TextSeries: eBooks on Demand.Synthesis Lectures on Data Management: Publisher: San Rafael : Morgan & Claypool Publishers, 2014Description: 1 online resource (87 p.).ISBN: 9781627055550.Subject(s): Application software -- Development | Computer science | Database managementGenre/Form: Electronic books.Additional physical formats: Print version:: Instant Recovery with Write-Ahead Logging : Page Repair, System Restart, and Media RestoreDDC classification: 005.7565 LOC classification: QA76.8.M3 .G384 2014Online resources: Click here to view this ebook.
|Item type||Current location||Call number||URL||Status||Date due||Barcode|
|Electronic Book||UT Tyler Online Online||QA76.8.M3 .G384 2014 (Browse shelf)||http://uttyler.eblib.com/patron/FullRecord.aspx?p=1899344||Available||EBL1899344|
Preface; Acknowledgments; Introduction; Related prior work; 2.1System Model; 2.2ARIES; 2.3Restart after a System Failure; 2.4Database Backup and Log Archive; 2.5Restore after a Media Failure; 2.6Allocation-only logging; 2.7System Transactions; 2.8Summary of Prior Work; Single-Page Recovery; 3.1Detection of Single-Page Failures; 3.2Recovery for Logged Updates; 3.3Recovery for Non-Logged Updates; 3.4Chains of Log Records; 3.5Summary of Single-Page Recovery; Applications of Single-Page Recovery; 4.1Self-Repairing Indexes; 4.2Write Elision; 4.3Read Elision
4.4Summary of Single-Page Recovery ApplicationsInstant Restart after a System Failure; 5.1Restart Techniques; 5.2Restart Schedules; 5.3Summary of Instant Restart; Single-Pass Restore; 6.1Partially Sorted Log Archive; 6.2Archiving Logic; 6.3Restore Logic; 6.4Summary of Single-Pass Restore; Applications of Single-Pass Restore; 7.1Instant Backup; 7.2Virtual Backups; 7.3Obsolete Incremental Backups; 7.4Summary of Single-Pass Restore Applications; Instant Restore after a Media Failure; 8.1 Indexed Backup and Log Archive; 8.2 Restore Techniques; 8.3 Restore Schedules; 8.4 Hot Restore
8.5 Summary of Instant RestoreMultiple Failures; 9.1 Single-Page Failure During Restore; 9.2 Single-Page Failure During Restart; 9.3 Multiple System Failures; 9.4 Multiple Media Failures; 9.5 System Failure During Media Restore; 9.6 Media Failure During System Restart; 9.7 Summary of Recovery After Multiple Failures; Conclusions; 10.1 Summary; 10.2 Future Work; References; Author Biographies
Traditional theory and practice of write-ahead logging and of database recovery techniques revolve around three failure classes: transaction failures resolved by rollback; system failures (typically software faults) resolved by restart with log analysis, "redo," and "undo" phases; and media failures (typically hardware faults) resolved by restore operations that combine multiple types of backups and log replay.The recent addition of single-page failures and single-page recovery has opened new opportunities far beyond its original aim of immediate, lossless repair of single-page wear-out in nov
Description based upon print version of record.