Definition: Transaction isolation means concurrent database transactions should not improperly interfere with each other.
It controls which intermediate effects of one transaction can be observed by another transaction.
Examples:
- Transaction A is transferring money while Transaction B checks the balance.
- Two customers attempt to reserve the same seat.
- One transaction updates an employee’s salary while another reads payroll information.