摘要
在应用层次上,数据库一致性是通过事务一致性体现的,在介绍事务间一致性和事务内一致性概念的基础上,讨论了基于封锁机制的并发控制和基于日志的提交控制技术,分析了事务操作的补偿性问题,以DB2/400数据库为例,探讨了实现事务完整性和数据库一致性的方法,给出了应用程序实例,大量的实际应用表明该方法是可靠有效的。
In application levels,database consistency is manifestsed through transaction consistency.After introducing the concept of consistency in and between transactions,the techniques of concurrency control on the basis of lock mechanism and commitment control on the basis of journal are discussed,respectively.The compensation of transactions is also analysed.Taking DB2/400 database as example,the detail discusses about the method of transaction integrity and database consistency are presented.An application programme is given to show the consistency of DB2/400 database.The proposed method is proved reliable and effective in applications.
出处
《河南科技大学学报（自然科学版）》
CAS
2007年第3期28-31,共4页
Journal of Henan University of Science And Technology:Natural Science
基金
国家科技创新基金项目(05C26222120349)
安徽省教育厅自然科学研究重点项目(KJ2007A/24ZC)
关键词
事务
日志
并发控制
提交控制
回滚
Transaction
Journal
Concurrency Control
Commitment Control
Rollback
