|< < 19 > >|

Overview of Database System Implementation

Concurrency Control

A selected row is

  • Read

  • Updated in memory

  • Written back to the table

But these actions cannot be done freely, due to transaction isolation.

E.g., don't update a salary row if another transaction is already updating it.

|< < 19 > >|