自修复数据库系统日志机制研究  

Research on Logging Mechanism of Self-healing Database System

作　　者：谢美意[1] 朱虹[1] 冯玉才[1] 

机构地区：[1]华中科技大学计算机科学与技术学院,武汉430074

出　　处：《计算机科学》2010年第4期139-142,166,共5页Computer Science

基　　金：863高技术研究发展计划基金项目(2006AA01Z430)资助

摘　　要：选择性恢复使得一个自修复数据库系统在受到恶意攻击后,只需撤销历史中受到恶意事务感染的那部分操作,无需回滚整段历史,但要求日志机制支持对事务间依赖关系的追踪及前像数据的长期保存。通过分析传统日志机制的不足以及现有原型系统实现方法存在的问题,提出了一种新的日志结构。该日志包含事务依赖信息,并以前像表代替传统日志机制中的回滚段。给出了基于该日志结构的数据库恢复方法,并在时间和空间开销方面对本方法与其它方法进行了分析和比较。Selective recovery allows a self-healing database system to undo only those operations affected by malicious transactions instead of rollbacking the whole history after malicious attacks, but this function relies on the logging mechanism＇s support on inter-transaction dependency tracking and longtime preservation of before image data. The inadequacy of traditional logging mechanisms and the problems of the methods used in current prototypes were analyzed. Following this,a new logging structure was proposed which contains inter-transaction dependency information and replaces the rollback segments in traditional logging mechanisms with the before image tables. Database recovery approaches based on the new mechanism were also presented. At last,we analyzed the performance and space overhead of our method,and compared it with other methods.

关 键 词：自修复 选择性恢复 事务依赖 前像表 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]