Joint Evaluation of Performance and Robustness of a COTS DBMS through Fault-Injection

  • Authors:
  • Diamantino Costa;Tiago Rilho;Henrique Madeira

  • Affiliations:
  • -;-;-

  • Venue:
  • DSN '00 Proceedings of the 2000 International Conference on Dependable Systems and Networks (formerly FTCS-30 and DCCA-8)
  • Year:
  • 2000

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper presents and discusses observed failure modes of a common-off-the-shelf (COTS) Database Management System (DBMS) under the presence of transient operational faults induced by SWIFI. The standard Transaction Processing Performance Council TPC-C benchmark and associated environment is used here together with fault-injection technology, building a framework that discloses both dependability and performance figures. Over 1600 faults were injected in the database server of a Client/Server computing environment built upon Oracle 8.1.5 database engine and Windows NT running on COTS machines with Intel Pentium processors. A macroscopic view on the impact of faults revealed that: 1) A large majority of the faults caused no observable abnormal impact in the database server; In 96% of hardware faults and 80% of software faults the database server behaved normally. 2) Software faults are more prone to let the database server hanging or cause abnormal terminations. 3) Up to 51% of software faults lead to observable failures in the client processes. Usage of a COTS DBMS like Oracle seems to be an effective way to benefit from COTS component economics while holding a fair confidence on service reliability. However, in certain business areas where data integrity is must, customized 驴business logic驴 checking should be implemented.