Concurrency and Problems Associated

Описание: We have discussed Transaction, Schedules, different types of schedules in DBMS.
1. Serial schedule
2. Concurrent schedule

A concurrent schedule is said to be serializable iff the result of concurrent schedule is equivalent to one of the possible serial schedule.

Problems with Concurrency:
1. Lost update problem
2. Dirty Read problem
3. Unrepeatable Read Problem