基于“写时复制”的培养方案管理系统逻辑锁定方案设计

Design of Training Protocol Management System Logic Locking Scheme Based on“Copy-on-Write”

培养方案管理系统提升了人才培养方案修订工作的质量和效率,然而,该系统在使用过程中也暴露出了专业间课程独立修改与数据规范化设计难以两全、高并发环境下数据容易出现不一致、共享课程导致某一专业培养方案定稿困难等一系列问题。文章引入了“写入时复制”(Copy-on-Write)技术,增加了专业锁、学期锁、课程锁等逻辑锁,利用两阶段锁协议等技术对培养方案管理系统进行重构,保证了系统的稳定高效运行,为此类数据库系统并发一致性问题提供了解决方案。

The Training protocol management system improves the quality and efficiency of talent training protocol revision work,however,the system in the process of use also exposes a series of problems such as professional course independent modification and data standardization design is difficult to both,high concurrency environment data prone to inconsistent,sharing courses lead to a professional training protocol finalized difficulties and so on.This paper introduces the technology of“Copy-on-Write”,adds logic locks such as professional lock,semester lock and course lock,and uses the two-stage lock protocol and other technologies to reconstruct the training protocol management system.It ensures the stable and efficient operation of the system,and provides a solution for the concurrent consistency problem of such database system.