000 nam a22 4500
999 _c32629
_d32629
008 231128b xxu||||| |||| 00| 0 eng d
020 _a9783031007293
082 _a005.86
_bGRA
100 _aGraefe, Goetz
245 _aInstant recovery with write-ahead logging : page repair, system restart, and media restore
260 _bSpringer,
_c2022
_aCham :
300 _axvii, 113 p. ;
_bill.,
_c23 cm
365 _b34.99
_cEUR
_d91.70
490 _aSynthesis lectures on data management ;
_v39
504 _aIncludes bibliographical references
520 _aTraditional 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 novel or traditional storage hardware. In the contexts of system and media failures, efficient single-page recovery enables on-demand incremental "redo" and "undo" as part of system restart or media restore operations. This can give the illusion of practically instantaneous restart and restore: instant restart permits processing new queries and updates seconds after system reboot and instant restore permits resuming queries and updates on empty replacement media as if those were already fully recovered. In addition to these instant recovery techniques, the discussion introduces much faster offline restore operations without slowdown in backup operations and with hardly any slowdown in log archiving operations. The new restore techniques also render differential and incremental backups obsolete, complete backup commands on the database server practically instantly, and even permit taking full backups without imposing any load on the database server.
650 _aComputer Communication Networks
650 _aComputer networks
650 _aData Structures and Information Theory
700 _aGuy, Wey
700 _aSauer, Caetano
942 _2ddc
_cBK