【摘要】 并发控制是数据库管理系统重要的组成部分。允许多个用户同时对数据库进行访问,有可能出现多个用户同时存取同一数据的情况。如果对其不加控制就有可能破坏数据库的一致性,出现丢失修改、不可重复读以及读取脏数据的情况,所以需要对数据库进行并发控制。封锁是实现并发控制的一项重要技术。本文设计几个教学案例,帮助学生更好地理解封锁机制,从而为掌握数据库的并发控制打下坚实基础。更多还原

【Abstract】 Concurrency control is an important part of the database management system. The database allows multiple users to use the database system at the same time. In this case, multiple users possibly access the same data currently.There may be the situations of lost update, not repeatable and read dirty data, if there is no control. So concurrency control of the database is very important. Blocking is a key technique for concurrency control. This article designed several case studies to help students understand the block mechanism better. This will lay a solid foundation for students to master the concurrency control of the database.更多还原