Locking Protocols Given a locking protocol (such as 2PL) A schedule S is legal under a locking protocol if it can be generated by a set of transactions that follow the protocol A protocol ensures serializability if all legal schedules under that protocol are serializable Database System Concepts-7th Edition 18.12 @Silberschatz,Korth and SudarshanDatabase System Concepts - 7 18.12 ©Silberschatz, Korth and Sudarshan th Edition Locking Protocols ▪ Given a locking protocol (such as 2PL) • A schedule S is legal under a locking protocol if it can be generated by a set of transactions that follow the protocol • A protocol ensures serializability if all legal schedules under that protocol are serializable