Dynamic data recovery for database systems based on fine grained transaction log

Hong Zhu, Ge Fu, Yi Zhu, Renchao Jin, Kevin Lü, Jie Shi
2008 Proceedings of the 2008 international symposium on Database engineering & applications - IDEAS '08  
Data recovery techniques for malicious transactions are increasingly becoming an important issue since the security for DBMSs are mainly prevention based, and they cannot defend systems from unknown attacks. Survivability and availability are essential for modern DBMSs, which require the database provide continuous services in the period of recovery, namely dynamic recovery. In this paper, we presented a data recovery model and introduce extended read-write dependency and phantoms dependency to
more » ... the model. A fine grained transaction log is proposed for data recovery. The log records all the data items of the read and update-involved operations for the committed transactions, and even extracts data items read by the subqueries in the SQL statements. Based on the log, we develop a dynamic recovery system to implement the data recovery model. The system could provide continuous services while the recovery is processing. Experiments based on TPC-W benchmark show that the dynamic recovery system is high-efficient and reliable. Existing damage assessment algorithms [1, 3, 6, 7] do not consider the "blind write transaction". A blind write transaction is a transaction whose operations are all update-involved and have no read-write dependency relationships with other transactions. Therefore, blind write transaction would not cause damage
doi:10.1145/1451940.1451975 dblp:conf/ideas/ZhuFZJLS08 fatcat:gwcb464dbzey7jk7luarivdona