The characterization of Database Management Sys-tems (DBMS) recovery mechanisms and the comparison of the recovery features of different DBMS require a practical approach to benchmark the effectiveness of recovery in the presence of faults. Existing performance benchmarks for transactional and database areas include two major components: a workload and a set of performance measures. The definition of a benchmark to characterize DBMS recovery needs a new component ' the faultload. A major cause of failures in large DBMS is operator faults, which make them an excellent starting point for the definition of a generic faultload. This paper proposes the steps for the definition of generic faultloads based on operator faults for DBMS recovery benchmarking. A classification for operator faults in DBMS is proposed and a comparative analysis among three commercially DBMS is presented. The paper ends with a practical example of the use of operator faults to benchmark different configurations of the recovery mechanisms of the Oracle 8i DBMS.
Keywords
Operator Faults, Faultload,
Subject
Operator Faults
Related Project
DBench - Dependability Benchmarking
Conference
Pacific Rim International Symposium on Dependable Computing, PRDC2002, December 2002
Cited by
Year 2010 : 1 citations
1. Philipp Reinecke, Katinka Wolter, Miroslaw Malek, “#A Survey on Fault-Models for QoS Studies of Service-Oriented Systems”, Technical Report number B-2010-02, Freie Universität Berlin, February, 2010.
Year 2008 : 1 citations
Andreas Johansson, "Robustness Evaluation of Operating Systems?, PhD thesis, Darmstadt University, 2008
Year 2007 : 3 citations
1. Paolo Lollini et al., "D4.1.2. Evaluation methodologies, techniques and tools", deliverable of the project: Highly dependable ip-based networks and services Project (HIDENETS Project: IST-FP6-STREP- 26979), December 2007.
2. Andréas Johansson, “Robustness Evaluation of Operating Systems”, tese de doutoramento de Andréas Johansson, Vom Fachbereich Informatik der Technischen Universit, University of Darmstad, Germany, 2007.
3. Manuel Mendonça, Nuno Ferreira Neves, Localização de Vulnerabilidades de Segurança em Gestores de Dispositivos Wi-Fi com Técnicas de Fuzzing, Actas da 3ª Conferência Nacional Sobre Segurança Informática nas Organizações (SINO07), Lisbon, Portugal, October 2007.
Year 2006 : 1 citations
1. Paolo Lollini et al., "D4.1.1. Identification and development of evaluation methodologies, techniques and tools", deliverable of the project: Highly dependable ip-based networks and services Project (HIDENETS Project: IST-FP6-STREP- 26979), December 2006.
Year 2004 : 3 citations
1. Aaron B. Brown, Leonard Chung, William Kakes, Calvin Ling, David A. Patterson, “Experience with Evaluating Human-Assisted Recovery Processes”, IEEE/IFIP International Conference on Dependable Systems and Networks, DSN 2004, Florence, Italy, June 28-July 1, 2004.
2. Ali Kalakech, Karama Kanoun, Yves Crouzet and Jean Arlat, “Benchmarking The Dependability of Windows NT4, 2000 and XP”, IEEE/IFIP International Conference on Dependable Systems and Networks, DSN 2004, Florence, Italy, June 28-July 1, 2004.
3. Ali Kalakech, Tahar Jarboui, Jean Arlat, Yves Crouzet, Karama Kanoun, “Benchmarking Operating System Dependability: Windows 2000 as a Case Study”, 10th IEEE Pacific Rim International Symposium on Dependable Computing, PRDC2004, Papeete, Tahiti, French Polynesia, March 3-5, 2004.
Year 2003 : 2 citations
1. Aaron Brown, “A Recovery-Oriented Approach to Dependable Services: Reairing Past Errors with System-Wide Undo”, PhD Thesis, EECS Computer Science Division - University of California, Berkeley, California, USA, December 2003.
2. Kersten Buchacker, Mario Dal Cin, H. Hoxer, R. Karch, Volkmar Sieh, Oliver Tschache, "Reproducible dependability benchmarking experiments based on unambiguous benchmark setup descriptions", IEEE/IFIP International Conference on Dependable Systems and Networks, DSN 2003, San Francisco, California, USA, June 22-25, 2003.
