浙江大学数据库系统概念PPT第十五章.pptVIP

Chapter 15: Transactions Transaction Concept Concurrent Executions Serializability Testing for Serializability Recoverability Transaction Definition in SQL Transaction Concept E.g. Transaction to transfer $50 from account A to account B: 1. read(A) 4. read(B) 2. A := A – 50 5. B := B + 50 3. write(A) 6. write(B A transaction is a unit of program execution that accesses and possibly updates various data items. A transaction must see a consistent database. During transaction execution the database may be inconsistent. When the transaction is committed, the database must be consistent.