Sign inSign in
ConceptSystems & CS

Write-ahead log

A recovery protocol where change records are written to a separate log file before database pages are flushed to disk.
as Jignesh Patel defines itCarnegie Mellon UniversityThe wording closest to all 4 definitions
Watch it explained

Know first

Named as a prerequisite by the lectures that define this. The number is how many say so. A grey one has no page yet.

Opens up

Concepts that name this one as a prerequisite.

Lecturers

4

Each in their own terms, from the easiest level.

  • Robert Morris

    MIT · Undergraduate

    A log on disk that records all changes to a database before they are applied to the main data pages, ensuring durability and crash recovery.
    • 17:45Cloud Replicated DB, Aurora
  • D. Richard Hipp

    Carnegie Mellon University · Undergraduate

    A journaling mode where changes are appended to a log file first, allowing multiple readers and a writer to operate concurrently with snapshot isolation.
    • 31:38The Architecture and Bytecode Virtual Machine of SQLite
  • Ippokratis Pandis

    Carnegie Mellon University · Research

    A technique for ensuring data integrity by recording all changes to a database in a log file before applying them to the actual data files.
    • 35:13Lakebases & LTAP: Unifying Transactions and Analytics on Open Object Storage

Lectures that assume it

1

Connections

12

The lectures that define it or assume it, and the concepts next to it.

4 lecturers. Definitions are written by AI from each lecture’s transcript. A time with a play mark starts the lecture at the moment the lecturer says it.