Concurrency Control(1)

• managing simultaneous operations on the database without having them interfere with one another

• maximize throughput
• lost update problem, uncommitted dependency problem,inconsistent analysis problem Fig 22(20).4-6

• Serializable schedule:correct schedule

• nonserial schedule produces the same result as some serial execution Fig 22(20).7