Instant recovery with write-ahead logging: page repair, system restart, and media restore
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...
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
[San Rafael, California]
Morgan & Claypool Publishers
[2015]
|
| Schriftenreihe: | Synthesis lectures on data management
#39 |
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | 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 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 |
| Beschreibung: | Part of: Synthesis digital library of engineering and computer science Title from PDF title page (viewed on December 24, 2014) |
| Beschreibung: | 1 Online-Resource (xv, 69 Seiten) Illustrationen |
| ISBN: | 9781627055550 |
| DOI: | 10.1007/978-3-031-01852-7 |
Internformat
MARC
| LEADER | 00000nmm a2200000zcb4500 | ||
|---|---|---|---|
| 001 | BV046427467 | ||
| 003 | DE-604 | ||
| 005 | 20240103 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 200217s2015 |||| o||u| ||||||eng d | ||
| 020 | |a 9781627055550 |c ebook |9 978-1-62705-555-0 | ||
| 024 | 7 | |a 10.1007/978-3-031-01852-7 |2 doi | |
| 035 | |a (ZDB-105-MCS)7005384 | ||
| 035 | |a (OCoLC)1141122184 | ||
| 035 | |a (DE-599)BVBBV046427467 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-83 | ||
| 082 | 0 | |a 005.86 |2 23 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 100 | 1 | |a Graefe, Goetz |e Verfasser |0 (DE-588)106622496X |4 aut | |
| 245 | 1 | 0 | |a Instant recovery with write-ahead logging |b page repair, system restart, and media restore |c Goetz Graefe, Wey Guy, Caetano Sauer |
| 264 | 1 | |a [San Rafael, California] |b Morgan & Claypool Publishers |c [2015] | |
| 264 | 4 | |c © 2015 | |
| 300 | |a 1 Online-Resource (xv, 69 Seiten) |b Illustrationen | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 1 | |a Synthesis lectures on data management |v #39 | |
| 500 | |a Part of: Synthesis digital library of engineering and computer science | ||
| 500 | |a Title from PDF title page (viewed on December 24, 2014) | ||
| 520 | |a 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 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 | 4 | |a Data recovery (Computer science) | |
| 650 | 4 | |a Data logging | |
| 650 | 0 | 7 | |a Wiederherstellung |g Informatik |0 (DE-588)4177289-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Protokoll |g Datenverarbeitungssystem |0 (DE-588)4343364-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbank |0 (DE-588)4011119-2 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Datenbank |0 (DE-588)4011119-2 |D s |
| 689 | 0 | 1 | |a Protokoll |g Datenverarbeitungssystem |0 (DE-588)4343364-9 |D s |
| 689 | 0 | 2 | |a Wiederherstellung |g Informatik |0 (DE-588)4177289-1 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Guy, Wey |e Verfasser |0 (DE-588)1066224994 |4 aut | |
| 700 | 1 | |a Sauer, Caetano |e Verfasser |0 (DE-588)1066225028 |4 aut | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 978-1-62705-554-3 |
| 830 | 0 | |a Synthesis lectures on data management |v #39 |w (DE-604)BV036731811 |9 39 | |
| 856 | 4 | 0 | |u https://doi.org/10.1007/978-3-031-01852-7 |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
| 912 | |a ZDB-105-MCS |a ZDB-105-MCDM | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-031839770 | ||
Datensatz im Suchindex
| _version_ | 1804180976749772800 |
|---|---|
| any_adam_object | |
| author | Graefe, Goetz Guy, Wey Sauer, Caetano |
| author_GND | (DE-588)106622496X (DE-588)1066224994 (DE-588)1066225028 |
| author_facet | Graefe, Goetz Guy, Wey Sauer, Caetano |
| author_role | aut aut aut |
| author_sort | Graefe, Goetz |
| author_variant | g g gg w g wg c s cs |
| building | Verbundindex |
| bvnumber | BV046427467 |
| classification_rvk | ST 270 |
| collection | ZDB-105-MCS ZDB-105-MCDM |
| ctrlnum | (ZDB-105-MCS)7005384 (OCoLC)1141122184 (DE-599)BVBBV046427467 |
| dewey-full | 005.86 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.86 |
| dewey-search | 005.86 |
| dewey-sort | 15.86 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| doi_str_mv | 10.1007/978-3-031-01852-7 |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03802nmm a2200541zcb4500</leader><controlfield tag="001">BV046427467</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20240103 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">200217s2015 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781627055550</subfield><subfield code="c">ebook</subfield><subfield code="9">978-1-62705-555-0</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1007/978-3-031-01852-7</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-105-MCS)7005384</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1141122184</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV046427467</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-83</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.86</subfield><subfield code="2">23</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Graefe, Goetz</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)106622496X</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Instant recovery with write-ahead logging</subfield><subfield code="b">page repair, system restart, and media restore</subfield><subfield code="c">Goetz Graefe, Wey Guy, Caetano Sauer</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[San Rafael, California]</subfield><subfield code="b">Morgan & Claypool Publishers</subfield><subfield code="c">[2015]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">© 2015</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Resource (xv, 69 Seiten)</subfield><subfield code="b">Illustrationen</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Synthesis lectures on data management</subfield><subfield code="v">#39</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Part of: Synthesis digital library of engineering and computer science</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Title from PDF title page (viewed on December 24, 2014)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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 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</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data recovery (Computer science)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data logging</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Wiederherstellung</subfield><subfield code="g">Informatik</subfield><subfield code="0">(DE-588)4177289-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Protokoll</subfield><subfield code="g">Datenverarbeitungssystem</subfield><subfield code="0">(DE-588)4343364-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbank</subfield><subfield code="0">(DE-588)4011119-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenbank</subfield><subfield code="0">(DE-588)4011119-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Protokoll</subfield><subfield code="g">Datenverarbeitungssystem</subfield><subfield code="0">(DE-588)4343364-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Wiederherstellung</subfield><subfield code="g">Informatik</subfield><subfield code="0">(DE-588)4177289-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Guy, Wey</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1066224994</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Sauer, Caetano</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1066225028</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">978-1-62705-554-3</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Synthesis lectures on data management</subfield><subfield code="v">#39</subfield><subfield code="w">(DE-604)BV036731811</subfield><subfield code="9">39</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.1007/978-3-031-01852-7</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Erstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-105-MCS</subfield><subfield code="a">ZDB-105-MCDM</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-031839770</subfield></datafield></record></collection> |
| id | DE-604.BV046427467 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T08:44:19Z |
| institution | BVB |
| isbn | 9781627055550 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-031839770 |
| oclc_num | 1141122184 |
| open_access_boolean | |
| owner | DE-83 |
| owner_facet | DE-83 |
| physical | 1 Online-Resource (xv, 69 Seiten) Illustrationen |
| psigel | ZDB-105-MCS ZDB-105-MCDM |
| publishDate | 2015 |
| publishDateSearch | 2015 |
| publishDateSort | 2015 |
| publisher | Morgan & Claypool Publishers |
| record_format | marc |
| series | Synthesis lectures on data management |
| series2 | Synthesis lectures on data management |
| spelling | Graefe, Goetz Verfasser (DE-588)106622496X aut Instant recovery with write-ahead logging page repair, system restart, and media restore Goetz Graefe, Wey Guy, Caetano Sauer [San Rafael, California] Morgan & Claypool Publishers [2015] © 2015 1 Online-Resource (xv, 69 Seiten) Illustrationen txt rdacontent c rdamedia cr rdacarrier Synthesis lectures on data management #39 Part of: Synthesis digital library of engineering and computer science Title from PDF title page (viewed on December 24, 2014) 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 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 Data recovery (Computer science) Data logging Wiederherstellung Informatik (DE-588)4177289-1 gnd rswk-swf Protokoll Datenverarbeitungssystem (DE-588)4343364-9 gnd rswk-swf Datenbank (DE-588)4011119-2 gnd rswk-swf Datenbank (DE-588)4011119-2 s Protokoll Datenverarbeitungssystem (DE-588)4343364-9 s Wiederherstellung Informatik (DE-588)4177289-1 s DE-604 Guy, Wey Verfasser (DE-588)1066224994 aut Sauer, Caetano Verfasser (DE-588)1066225028 aut Erscheint auch als Druck-Ausgabe 978-1-62705-554-3 Synthesis lectures on data management #39 (DE-604)BV036731811 39 https://doi.org/10.1007/978-3-031-01852-7 Verlag URL des Erstveröffentlichers Volltext |
| spellingShingle | Graefe, Goetz Guy, Wey Sauer, Caetano Instant recovery with write-ahead logging page repair, system restart, and media restore Synthesis lectures on data management Data recovery (Computer science) Data logging Wiederherstellung Informatik (DE-588)4177289-1 gnd Protokoll Datenverarbeitungssystem (DE-588)4343364-9 gnd Datenbank (DE-588)4011119-2 gnd |
| subject_GND | (DE-588)4177289-1 (DE-588)4343364-9 (DE-588)4011119-2 |
| title | Instant recovery with write-ahead logging page repair, system restart, and media restore |
| title_auth | Instant recovery with write-ahead logging page repair, system restart, and media restore |
| title_exact_search | Instant recovery with write-ahead logging page repair, system restart, and media restore |
| title_full | Instant recovery with write-ahead logging page repair, system restart, and media restore Goetz Graefe, Wey Guy, Caetano Sauer |
| title_fullStr | Instant recovery with write-ahead logging page repair, system restart, and media restore Goetz Graefe, Wey Guy, Caetano Sauer |
| title_full_unstemmed | Instant recovery with write-ahead logging page repair, system restart, and media restore Goetz Graefe, Wey Guy, Caetano Sauer |
| title_short | Instant recovery with write-ahead logging |
| title_sort | instant recovery with write ahead logging page repair system restart and media restore |
| title_sub | page repair, system restart, and media restore |
| topic | Data recovery (Computer science) Data logging Wiederherstellung Informatik (DE-588)4177289-1 gnd Protokoll Datenverarbeitungssystem (DE-588)4343364-9 gnd Datenbank (DE-588)4011119-2 gnd |
| topic_facet | Data recovery (Computer science) Data logging Wiederherstellung Informatik Protokoll Datenverarbeitungssystem Datenbank |
| url | https://doi.org/10.1007/978-3-031-01852-7 |
| volume_link | (DE-604)BV036731811 |
| work_keys_str_mv | AT graefegoetz instantrecoverywithwriteaheadloggingpagerepairsystemrestartandmediarestore AT guywey instantrecoverywithwriteaheadloggingpagerepairsystemrestartandmediarestore AT sauercaetano instantrecoverywithwriteaheadloggingpagerepairsystemrestartandmediarestore |