Concurrent Executions Multiple transactions are allowed to run concurrently in the system.Advantages are: Increased processor and disk utilization,leading to better transaction throughput E.g.one transaction can be using the CPU while another is reading from or writing to the disk Reduced average response time for transactions:short transactions need not wait behind long ones. Concurrency control schemes-mechanisms to achieve isolation That is,to control the interaction among the concurrent transactions in order to prevent them from destroying the consistency of the database Will study in Chapter 15,after studying notion of correctness of concurrent executions. Database System Concepts-6th Edition 14.10 ©Silberschat乜,Korth and SudarshanDatabase System Concepts - 6 14.10 ©Silberschatz, Korth and Sudarshan th Edition Concurrent Executions Multiple transactions are allowed to run concurrently in the system. Advantages are: Increased processor and disk utilization, leading to better transaction throughput E.g. one transaction can be using the CPU while another is reading from or writing to the disk Reduced average response time for transactions: short transactions need not wait behind long ones. Concurrency control schemes – mechanisms to achieve isolation That is, to control the interaction among the concurrent transactions in order to prevent them from destroying the consistency of the database Will study in Chapter 15, after studying notion of correctness of concurrent executions