Instant Recovery with Write-Ahead Logging

Publisher : Springer Nature

ISBN-13 : 3031018575

Page : 113 pages

Rating : 4.5/5 from 575 voters

Traditional theory and practice of write-ahead logging and of database recovery focus on three failure classes: transaction failures (typically due to deadlocks) resolved by transaction rollback; system failures (typically power or 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 the 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 the context of node and network failures, instant restart and instant restore combine to enable practically instant failover from a failing database node to one holding merely an out-of-date backup and a log archive, yet without loss of data, updates, or transactional integrity. In addition to these instant recovery techniques, the discussion introduces self-repairing indexes and much faster offline restore operations, which impose no slowdown in backup operations and hardly any slowdown in log archiving operations. The new restore techniques also render differential and incremental backups obsolete, complete backup commands on a database server practically instantly, and even permit taking full up-to-date backups without imposing any load on the database server. Compared to the first version of this book, this second edition adds sections on applications of single-page repair, instant restart, single-pass restore, and instant restore. Moreover, it adds sections on instant failover among nodes in a cluster, applications of instant failover, recovery for file systems and data files, and the performance of instant restart and instant restore.

More Books:

Instant Recovery with Write-Ahead Logging
Language: en
Pages: 113
Authors: Goetz Graefe
Categories: Computers
Type: BOOK - Published: 2022-05-31 - Publisher: Springer Nature

Traditional theory and practice of write-ahead logging and of database recovery focus on three failure classes: transaction failures (typically due to deadlocks
Instant Recovery with Write-Ahead Logging
Language: en
Pages: 113
Authors: Goetz Graefe
Categories: Computers
Type: BOOK - Published: 2016-04-29 - Publisher: Morgan & Claypool Publishers

Traditional theory and practice of write-ahead logging and of database recovery focus on three failure classes: transaction failures (typically due to deadlocks
Advances in Databases and Information Systems
Language: en
Pages: 354
Authors: Jaroslav Pokorný
Categories: Computers
Type: BOOK - Published: 2016-08-13 - Publisher: Springer

This book constitutes the thoroughly refereed proceedings of the 20th East European Conference on Advances in Databases and Information Systems, ADBIS 2016, hel
Non-Volatile Memory Database Management Systems
Language: en
Pages: 191
Authors: Joy Arulraj
Categories: Computers
Type: BOOK - Published: 2019-02-12 - Publisher: Morgan & Claypool Publishers

This book explores the implications of non-volatile memory (NVM) for database management systems (DBMSs). The advent of NVM will fundamentally change the dichot
Database Internals
Language: en
Pages: 376
Authors: Alex Petrov
Categories: Computers
Type: BOOK - Published: 2019-09-13 - Publisher: "O'Reilly Media, Inc."

When it comes to choosing, using, and maintaining a database, understanding its internals is essential. But with so many distributed databases and tools availab
Answering Queries Using Views
Language: en
Pages: 275
Authors: Foto Afrati
Categories: Computers
Type: BOOK - Published: 2019-04-15 - Publisher: Morgan & Claypool Publishers

The topic of using views to answer queries has been popular for a few decades now, as it cuts across domains such as query optimization, information integration
Data Management in Machine Learning Systems
Language: en
Pages: 157
Authors: Matthias Boehm
Categories: Computers
Type: BOOK - Published: 2022-05-31 - Publisher: Springer Nature

Large-scale data analytics using machine learning (ML) underpins many modern data-driven applications. ML systems provide means of specifying and executing thes
Querying Graphs
Language: en
Pages: 166
Authors: Angela Bonifati
Categories: Computers
Type: BOOK - Published: 2022-06-01 - Publisher: Springer Nature

Graph data modeling and querying arises in many practical application domains such as social and biological networks where the primary focus is on concepts and
Cloud-Based RDF Data Management
Language: en
Pages: 91
Authors: Zoi Kaoudi
Categories: Computers
Type: BOOK - Published: 2022-05-31 - Publisher: Springer Nature

Resource Description Framework (or RDF, in short) is set to deliver many of the original semi-structured data promises: flexible structure, optional schema, and
Data Profiling
Language: en
Pages: 136
Authors: Ziawasch Abedjan
Categories: Computers
Type: BOOK - Published: 2022-06-01 - Publisher: Springer Nature

Data profiling refers to the activity of collecting data about data, {i.e.}, metadata. Most IT professionals and researchers who work with data have engaged in