【摘要】 为了便于对重要数据进行监测和保护,提出了一种应用触发器实现轨迹保留的方法。通过在数据库中建立一个冗余数据表记录数据修改轨迹,数据变化时触发器自动将修改前的数据副本写入冗余数据表,由于冗余数据表是个关系型数据集,提取和查看方便,多级数据回溯与恢复也易于实现。实践表明,该方法具有很好的效果。更多还原

【Abstract】 In this paper,for easy to protect and monitor important data,propose a method that trigger was applied to achieve the goal of tracks reservation.Via designing a special redundant table in database which can record the data modification tracts,whenever data change,the trigger can write a former data backup into this redundant table automatically.Since it is a relational record set,it is convenient to query or select,and to realize a series of UNDO backdating and data rescue.Experimental results and the practice show that this method is available and well effective.更多还原