Cost of Ensuring Safety in Distributed Database Management Systems

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 crash 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 v...

• Type: Conference
• Year: 1999
• Where: PRDC
• Authors: Maitrayi Sabaratnam, Svein-Olaf Hvasshovd, Øystein Torbjørnsen
• Keywords: Applied Computing, Consistency Checks, Database Integrity, Fault Injection, PRDC 1999