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.
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
4Each in their own terms, from the easiest level.
Robert Morris
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.D. Richard Hipp
A journaling mode where changes are appended to a log file first, allowing multiple readers and a writer to operate concurrently with snapshot isolation.Ippokratis Pandis
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.
Lectures that assume it
1Connections
12The lectures that define it or assume it, and the concepts next to it.