Abstract
Purchase PDF (471 K)
E-mail Article
Add to my Quick Links
Cited By in Scopus (0)
Purchase PDF (384 K)
doi:10.1016/j.peva.2003.07.006 
Copyright © 2003 Elsevier B.V. All rights reserved.
Joint evaluation of recovery and performance of a COTS DBMS in the presence of operator faults
Available online 20 October 2003.
References and further reading may be available for this article. To view references and further reading you must purchase this article.
Abstract
A major cause of failures in large database management systems (DBMS) is operator/administrator faults. Although most of the complex DBMS available today 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 of 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/administrator faults in DBMS is proposed. A set of tools have been designed and built to reproduce operator faults in an Oracle 8i DBMS, using exactly the same means used in the field by the real database administrator. This experimental approach is generic (i.e., can be applied to any DBMS) and is fully automatic. The paper ends with the discussion of the results and the proposal of guidelines to help database administrators in finding the balance between performance and recovery tuning.
Author Keywords: Performance and recoverability; Experimental evaluation; Database management systems; Operator faults
Article Outline
- 1. Introduction
- 2. Background on DBMS
- 3. Operator faults in DBMS
- 3.1. Main DBMS administration areas
- 3.2. Administration in different DBMS
- 3.3. Classes of operator faults
- 3.4. Comparative analysis of DBMS administration and susceptibility to operator faults
- 3.5. Operator faults emulation and recovery
- 4. Experimental setup
- 5. Experimental results and discussion
- 5.1. Results with basic recovery mechanism (online redo logs)
- 5.2. Results with archive logs
- 5.3. Results with standby database
- 6. Configuration scenarios summary
- 7. Conclusion
- Acknowledgements
- References
- Vitae
