摘要： 数据库锁是保证网络数据库中的数据安全的重要手段。文章通过对Microsoft SQL Server的锁管理机制的分析，讨论了锁的多粒度性和锁的多模式性，以及由此引出的锁升级和锁的兼容性，还有减少死锁可能性的几种方法。之后给出了手工加锁的方法，以保证应用程序的正确运行及保持数据的一致性和正确性。

关键词: 数据库锁, 数据安全, 死锁

Abstract: Under network database environments,lock is an important method to look after the data security.In this paper,we analysie the lock architecture in MS SQL Server,including multigranular,model,escalation, compatibility. Then some ways are given to minimize deadlocks under compatible requests. Finally,there is a scheme showing how to add locks manually,and this scheme can guarantee programs'result and to assure the database data's consistency and correctness.

中图分类号: 

• TP311