Durability ----------- A tomicity C I D urability 1. Any change by a committed transaction must be made durable. 2. Any changes by a rolled back transaction must be removed. ------------ Log: append only mechanism LSN: log sequence number Record: T1 update P1 A (old value) B (new value) Write Ahead Logging (WAL) --------------------------- Before writing any data page that is updated from memory to disk First, flush log to disk If completed, then write the data to disk