Portable Faultloads Based on Operator Faults for DBMS Dependability Benchmarking
COMPSAC '04 Proceedings of the 28th Annual International Computer Software and Applications Conference - Volume 01
Towards timely ACID transactions in DBMS
DASFAA'07 Proceedings of the 12th international conference on Database systems for advanced applications
Fault injection approach based on dependence analysis
COMPSAC-W'05 Proceedings of the 29th annual international conference on Computer software and applications conference
Why do migrations fail and what can we do about it?
LISA'11 Proceedings of the 25th international conference on Large Installation System Administration
International Journal of Secure Software Engineering
Hi-index | 0.00 |
A major cause of failures in large database management systems (DBMS) is operator faults. Although most of the complex DBMS have comprehensive recovery mechanisms, the effectiveness of these mechanisms is difficult to characterize. On the other hand, the tuning of a large database is very complex and database administrators tend to concentrate on performance tuning and disregard the recovery mechanisms. Above all, database administrators seldom have feedback on how good a given configuration is concerning recovery. This paper proposes an experimental approach to characterize both the performance and the recoverability in DBMS. Our approach is presented through a concrete example of benchmarking the performance and recovery of an Oracle DBMS running the standard TPC-C benchmark, extended to include two new elements: a faultload based on operator faults and measures related to recoverability. A classification of operator faults in DBMS is proposed. The paper ends with the discussion of the results and the proposal ofguidelines to help database administrators in finding the balance between performance and recovery tuning.