Definition: Isolation means concurrent transactions should behave according to the database’s chosen isolation guarantees rather than improperly seeing/interfering with each other’s intermediate work.
The isolation level determines exactly how much interference is allowed.
Examples:
- Transaction A hasn’t committed its salary update → B shouldn’t see an invalid intermediate state.
- Two customers try to buy the same item.
- Two transactions update the same bank account simultaneously.