Design, Implementation, and Evaluation of a Repairable Database Management System

Although conventional database management systems are designed to tolerate hardware and to a lesser extent even software errors, they cannot protect themselves against syntactically correct and semantically damaging transactions, which could arise because of malicious attacks or honest mistakes. The lack of fast post-intrusion or posterror damage repair in modern DBMSs results in a longer Mean Time to Repair (MTTR) and sometimes permanent data loss that could have been saved by more intelligent repair mechanisms. In this paper, we describe the design and implementation of Phoenix - a system that significantly improves the efficiency and precision of a database damage repair process after an intrusion or operator error and thus, increases the overall database system availability. The two key ideas underlying Phoenix are (1) maintaining persistent intertransaction dependency information at run time to allow selective undo of database transactions that are considered "infected"...

• Type: Conference
• Year: 2005
• Where: ICDE
• Authors: Tzi-cker Chiueh, Dhruv Pilania
• Keywords: Database, Database Damage Repair, Database Repair Process, ICDE 2005, Manual Repair Process