Title
Dynamic data recovery for database systems based on fine grained transaction log
Abstract
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 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.
Year
DOI
Venue
2008
10.1145/1451940.1451975
IDEAS
Keywords
Field
DocType
dynamic data recovery,fine grained transaction log,data recovery technique,extracts data item,data item,dynamic recovery,dynamic recovery system,data recovery,modern dbmss,database system,continuous service,data recovery model,dynamic data
SQL,Data mining,Survivability,Computer science,Transaction log,Dynamic data,Data recovery,Database
Conference
Citations 
PageRank 
References 
1
0.36
9
Authors
6
Name
Order
Citations
PageRank
Hong Zhu1477.49
Ge Fu281.86
Yi Zhu329659.12
Renchao Jin4308.83
Kevin Lü523318.92
Jie Shi610.36