transaction log

A transaction log is a detailed record that a computer system keeps whenever changes are made to a database. It notes each action, such as adding, updating, or deleting data, along with the time it occurred. This log helps ensure data integrity by allowing systems to recover from errors or crashes, restoring the database to a consistent state. Think of it as a meticulous journal that tracks every modification, providing a way to trace or undo changes if needed, and supporting backup and recovery processes efficiently.