loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Sixth Pacific Rim International Symposium on Dependable Computing (PRDC'99)
Cost of Ensuring Safety in Distributed Database Management Systems
Hong Kong, China
December 16-December 17
ISBN: 0-7695-0371-3
Maitrayi Sabaratnam, Norwegian University of Science & Technology
Svein-Olaf Hvasshovd, Norwegian University of Science & Technology
Generally, applications employing Database Management Systems (DBMS) require that the integrity of the data stored in the database be preserved during normal operation as well as after crush recovery Preserving database integrity and availability needs extra safety measures in the form of consistency checks. Increased safety measures inflict adverse effect on performance by reducing throughput and increasing response time. This may not be agreeable for some critical applications and thus, a tradeoff is needed.This study evaluates the cost of extra consistency checks introduced in the data buffer cache in order to preserve the database integrity, in terms of performance loss. In addition, it evaluates the improvement in error coverage and fault tolerance, and occurrence of double failures causing long unavailability, with the help of fault injection. The evaluation is performed on a replicated DBMS, ClustRa [9).The results show that the checksum overhead in a DBMS inflicted with a very high TPC-B-like workload caused a reduction in throughput up to 5%. The error detection coverage improved from 62% to 92%. Fault injection experiments shows that corruption in database image went down from 13% to 0%. This indicates that the applications that require high safety, but can afford up to 5% performance loss can adopt checksum mechanisms.
Citation:
Maitrayi Sabaratnam, Svein-Olaf Hvasshovd, Øystein Torbjørnsen, "Cost of Ensuring Safety in Distributed Database Management Systems," prdc, pp.193, Sixth Pacific Rim International Symposium on Dependable Computing (PRDC'99), 1999
Usage of this product signifies your acceptance of the Terms of Use.