Database Recovery Techniques – Overview
Filed Under Databases, Recovery | Posted on September 6, 2009
The main goal of recovery is to ensure the atomicity property of a transaction. If a transaction fails before completing its execution, the recovery mechanism has to make sure that the transaction has no lasting effects on the database. The different approaches to recovery : – Deferred Update : These techniques postpone any actual updating [...]
How is shadow paging performed ?
Filed Under Uncategorized | Posted on September 6, 2009
Shadow paging is an alternative to log-based recovery techniques, which has both advantages and disadvantages. It may require fewer disk accesses, but it is hard to extend paging to allow multiple concurrent transactions. The paging is very similar to paging schemes used by the operating system for memory management. How Shadow Paging is performed ? [...]
Overview of Shadow Paging
Filed Under Explanation, Technical, Terms, Tips | Posted on September 6, 2009
A computer system, like any other mechanical or electrical system is subject to failure. There are a variety of causes, including disk crash, power failure, software errors, a fire in the machine room, or even sabotage. Whatever the cause, information may be lost. The database must take actions in advance to ensure that the atomicity [...]
