Database Management Systems · Recovery

ARIES recovery algorithm

The specific three-phase algorithm (analysis, redo, undo) real databases use to recover using the write-ahead log.

Also known as: ARIES, fuzzy checkpointing, log sequence numbers.

Start a lesson on ARIES recovery algorithm

Learn first

• Write-ahead logging and recovery: Writing what you're about to change to a log before touching the actual page, so a crash can still recover the right state.
• Lock-based concurrency control: Transactions acquiring then releasing locks on data, in two strict phases, to enforce serializability in practice.

Related topics

• Distributed databases: A database whose data lives across multiple machines instead of one.
• Database administration and performance tuning: The ongoing work of keeping a database backed up, monitored, and fast as real usage grows.