Question
Describe the Shadow Paging Recovery Technique. Compare it with Log-Based Recovery
highlighting their advantages and disadvantages.
Answer :
Word Count : 1492
______ ________ _______ ___ ______.
_______ ______ ___ ________ ______.
________ _________ ____ __________ _______ ____ _________ ___.
________ _________ ________ _______ ___ _____ _____ _________ ________ ________ _______ _________.
_____ _____ ________ ____ ___ ______ _____ __________ _____ _______ __________.
__________ __________ _________ ______ _________ ________ ______ __________ _______.
_______ ____ _____ _____ _____ __________ __________.
____ ____ ________ _______ ________.
____ ______ __________ _________ ________.
_____ ____ _________ ____ ______ ___.
________ __________ _________ __________ __________ ______ __________ __________ _____ ______.
_______ _____ ___ _____ ________ ______ ______ _____ ___ _________ __________ _________.
_________ __________ _____ ______ _______ ________ _______ ____ __________ ___.
_____ ____ _______ ___ _______ _________ ___ __________ ____ _______ ______.
____ _______ _________ _________ ______ ____ _______ _________ _________ _____.
____ ___ _____ ________ __________ _______ ____ ____.
_____ ____ _______ _____ ______ _______ __________.
_____ ________ _____ ___ _____ ____ ____ ______ _______ _______.
______ ______ _______ ____ ______ ___ _________ ___ ______ ___ ____.
__________ ____ __________ _____ ___ _____ ____.
______ _________ _____ _______ _____ ________ _________ __________.
_____ ____ __________ ___ ___ ___ ___ ____.
________ __________ _______ ______ _______ ______ ___ ______ ___ ______ ______.
_________ ________ ___ _________ _______ ______ __________ ______ ______ _____.
_________ ________ ___ ____ _________ ________ __________ _________ __________ __________.
_______ __________ ________ _______ ____ ___.
_________ ______ ___ ________ __________ __________ ______ _____ _______ _______ __________ _________.
_______ _______ _____ ____ ________ ____ _______ __________ ___ _____ ___ ____.
____ ____ ____ ____ __________ _________.
____ _____ ___ __________ _____ _______ ____ ___ _________.
___ _____ ____ _________ ________ ________.
___ __________ ___ _____ ________ _____ _____ _____.
__________ _______ ___ ______ __________ ___ __________ __________ ___.
_______ __________ _______ ______ _______ __________ _____ ____ _________ __________ ______.
__________ _______ ______ _________ ______.
________ ___ ____ __________ ___ _____ __________ ________ ____ _____ ___ ______.
__________ ___ _______ _______ ________ ____ ____ _______ ______ ________.
______ ________ _________ _____ ______ ______ __________.
_______ ____ _________ _________ _____ __________.
____ __________ ______ _____ ________ ________ ____ ________ _______ ________ _______.
_________ _____ _________ _____ __________ ______ ________ ____ __________ ________ ____.
_______ ______ ________ ________ __________.
____ _________ _______ ___ _____ _________ _____ __________ __________ ___ ____ __________.
__________ ______ _______ ________ _______ _______ ________ _______ ________ ______.
_________ _______ ______ _______ ______ _____ ___ ________.
____ ___ ________ ____ ___.
_________ _______ __________ __________ _____ ______.
__________ _____ ___ _________ ____ _________ ______ _______.
__________ _________ __________ ___ ________ _____ ____ _____ ____ ___.
____ _________ __________ ____ ___ ____ __________ ____ ___ __________ __________.
_____ _________ __________ ____ _________ __________ ____.
______ _____ ______ _______ _____.
______ _________ _____ ________ ____ ______ _____ _________ _____ _______.
______ ______ _________ _____ ___.
__________ ___ ______ ___ ______ _________ _________ _____ __________.
_______ _______ ________ ____ _______ ___ ____ ________ ____ ______ ___ ______.
____ ________ _______ _____ ________ ________ _____ _______ _________ ________ ___.
___ ___ ___ _________ ___ ______ _____ _____ ______ ____.
________ ______ _____ _____ __________ __________ ___ __________ ___ ________ _________.
___ _____ ____ ________ ______ _____ ___ _______ __________.
______ ___ ______ _______ __________ ______ ________ _____ __________ _________ _______.
_______ _____ ______ ________ _______ _____ ________ ___ _________.
______ __________ ______ __________ __________ _____ ______ _________.
____ ____ ___ __________ _____ _______ ___ ________ _________ ______.
______ ___ _____ ______ ______ __________ ________ _________ ____ ___.
_______ _____ ___ ___ ___.
________ _____ __________ __________ _________ ____ _______ _____ _____ _________ ________ _________.
________ _______ _________ ___ _________ ________ __________ ________ ____.
_______ _____ __________ _____ _______ _____ ___ _______ ___ ________.
_____ __________ ___ ___ _______ ______ __________ _______ ______.
__________ ________ ___ ______ ________ ________ _______ _______.
________ ________ _________ __________ ________ ___ _________ _________.
______ _____ __________ __________ ________ ________ _________ ____.
__________ ___ _______ ____ _____ _____ ________ _______ _____.
__________ __________ ______ ________ _______.
______ ______ ___ ______ ____ ________ ________ _____ _____ ____ ____ _____.
____ _______ __________ ___ ________ ____.
_________ __________ __________ ______ ___ ______ ______ ______ ______ ___ ____.
____ ________ ______ _________ ___ _____ _______ ________.
_____ __________ ____ ___ ________ ____.
__________ _____ ________ ____ __________ __________ ________ _______ ___ ____ _______ _____.
_____ __________ _____ ___ _________ _________ _____ ________ __________ _________ _________ ____.
___ ________ __________ ___ ____ _______ ________ ________ _________ ____ ____.
_______ ______ _____ __________ ___ ____.
__________ ______ ______ _______ ____ _____ _____ _____ ______ ______.
__________ ______ ___ _________ __________ ___ __________ _____ ___.
___ ________ ________ ________ _____ ________ _____ _____ ___ ___.
__________ ___ ____ ________ _____ __________ ________ _________ ___ _____ ___ ______.
_______ __________ _____ ______ ______ ___ _____ _______ __________.
______ _____ ___ ___ _________ ______ _____ _______ _______ ___ ______.
______ _____ _______ ____ _____ __________ _______ _____ ____ ________.
_______ _______ _________ ____ _________ _____ ________ ________ ______ _____.
__________ ________ __________ ______ ___ _______ __________ ____ _________ _________ ____.
______ ________ _________ ____ ____ __________ _____.
_________ ________ __________ _____ ____ ________.
____ ___ _____ _________ ________ ___.
____ _____ _______ __________ __________ ________.
_________ _______ _______ __________ ______ ___.
______ ______ ___ _________ __________ _______ _____ ______ ________.
____ _________ _________ ___ ____ ___ ________ ___.
_______ _________ ________ ___ _____ _____.
_________ _____ __________ _________ ________ ________ ____ ________ _________ ___.
________ _____ _____ _____ _________ _____ _______ ______ _________ ____ _______.
______ __________ __________ __________ ___.
________ ___ ______ ________ ______ _______ __________.
____ _____ ____ ___ _____ _____.
___ _______ _________ _________ __________ ________.
___ ________ _________ ______ __________ ______ _____ _____ __________ _________.
____ _____ ______ ________ __________ ___ _______ ____ ____ __________ ___ __________.
____ ____ ____ ___ ________ _____ __________ ________.
____ _____ _________ _________ _______ ______ ________.
_____ ____ __________ ______ ____ _____ _____ ___ __________ _________ ______ _________.
__________ ________ _______ _____ ___ ______ _________ ________ ______ ______.
___ _______ _____ _____ ____.
________ ___ _______ _______ ______ _________ _____.
_________ __________ _____ _______ ________ _______ _______ ______.
________ ________ ______ ________ ________ _______ ___ _______.
_____ ________ ______ _____ ________ _____.
_____ __________ ________ ____ _______ __________ ____ ___ ____ _________.
_____ ____ _____ _______ _______.
_________ ________ _________ ___.
Skip in 10
Shadow paging is a database recovery technique designed to maintain database consistency in the event of transaction failures, system crashes, or other interruptions. It provides a mechanism for recovering the database without requiring a traditional log of every update. The basic idea is to maintain two page tables: a shadow page table and a current page table. The shadow page table points to the stable versions of database pages, while the current page table is used by the active transaction to make changes. Shadow paging is based on the principle of maintaining an unchanged copy of the database structure until a transaction successfully completes. A database is normally divided into fixed-size pages, and a page table contains pointers to the physical locations of these pages. At the beginning of a transaction, the system creates a shadow page table that contains pointers to the original database pages. This shadow page table is stored on stable storage and is not modified during the transaction. A current page table is also maintained in main memory or on storage. Initially, both page tables point to the same physical database pages. When a transaction modifies a page, the original page is not overwritten. Instead, a new copy of that page is created at another location on disk, and the current page table is changed so that it points to the newly created page. The shadow page table continues to point to the original, unchanged page. This process is known as copy-on-write. Consequently, the shadow page table always represents the database state before the transaction began, while the current page table represents the database state after the transaction's modifications. Suppose a transaction modifies pages P1 and P2. Initially, both the shadow and current page tables point to the original copies of P1 and P2. When P1 is updated, a new copy P1' is created and the current page table points to P1'. The shadow page table still points to P1. Similarly, when P2 is modified, a new copy P2' is created and the current page table points to it. Thus, the original database remains available through the shadow page table throughout transaction execution. When the transaction completes successfully, the system must make the new database state permanent. This is done by changing the pointer to the page table so that the current page table becomes the new shadow page table. The update of this pointer must be performed atomically. Once the pointer is safely changed, the transaction is considered committed, and the modified pages become part of the permanent database state. The old pages can subsequently be released or reused. If the transaction fails before commitment, recovery is comparatively simple. Since the shadow page
___ ______ __________ ________ ________.______ ________ _______ ___ ______.
_______ ______ ___ ________ ______.
________ _________ ____ __________ _______ ____ _________ ___.
________ _________ ________ _______ ___ _____ _____ _________ ________ ________ _______ _________.
_____ _____ ________ ____ ___ ______ _____ __________ _____ _______ __________.
__________ __________ _________ ______ _________ ________ ______ __________ _______.
_______ ____ _____ _____ _____ __________ __________.
____ ____ ________ _______ ________.
____ ______ __________ _________ ________.
_____ ____ _________ ____ ______ ___.
________ __________ _________ __________ __________ ______ __________ __________ _____ ______.
_______ _____ ___ _____ ________ ______ ______ _____ ___ _________ __________ _________.
_________ __________ _____ ______ _______ ________ _______ ____ __________ ___.
_____ ____ _______ ___ _______ _________ ___ __________ ____ _______ ______.
____ _______ _________ _________ ______ ____ _______ _________ _________ _____.
____ ___ _____ ________ __________ _______ ____ ____.
_____ ____ _______ _____ ______ _______ __________.
_____ ________ _____ ___ _____ ____ ____ ______ _______ _______.
______ ______ _______ ____ ______ ___ _________ ___ ______ ___ ____.
__________ ____ __________ _____ ___ _____ ____.
______ _________ _____ _______ _____ ________ _________ __________.
_____ ____ __________ ___ ___ ___ ___ ____.
________ __________ _______ ______ _______ ______ ___ ______ ___ ______ ______.
_________ ________ ___ _________ _______ ______ __________ ______ ______ _____.
_________ ________ ___ ____ _________ ________ __________ _________ __________ __________.
_______ __________ ________ _______ ____ ___.
_________ ______ ___ ________ __________ __________ ______ _____ _______ _______ __________ _________.
_______ _______ _____ ____ ________ ____ _______ __________ ___ _____ ___ ____.
____ ____ ____ ____ __________ _________.
____ _____ ___ __________ _____ _______ ____ ___ _________.
___ _____ ____ _________ ________ ________.
___ __________ ___ _____ ________ _____ _____ _____.
__________ _______ ___ ______ __________ ___ __________ __________ ___.
_______ __________ _______ ______ _______ __________ _____ ____ _________ __________ ______.
__________ _______ ______ _________ ______.
________ ___ ____ __________ ___ _____ __________ ________ ____ _____ ___ ______.
__________ ___ _______ _______ ________ ____ ____ _______ ______ ________.
______ ________ _________ _____ ______ ______ __________.
_______ ____ _________ _________ _____ __________.
____ __________ ______ _____ ________ ________ ____ ________ _______ ________ _______.
_________ _____ _________ _____ __________ ______ ________ ____ __________ ________ ____.
_______ ______ ________ ________ __________.
____ _________ _______ ___ _____ _________ _____ __________ __________ ___ ____ __________.
__________ ______ _______ ________ _______ _______ ________ _______ ________ ______.
_________ _______ ______ _______ ______ _____ ___ ________.
____ ___ ________ ____ ___.
_________ _______ __________ __________ _____ ______.
__________ _____ ___ _________ ____ _________ ______ _______.
__________ _________ __________ ___ ________ _____ ____ _____ ____ ___.
____ _________ __________ ____ ___ ____ __________ ____ ___ __________ __________.
_____ _________ __________ ____ _________ __________ ____.
______ _____ ______ _______ _____.
______ _________ _____ ________ ____ ______ _____ _________ _____ _______.
______ ______ _________ _____ ___.
__________ ___ ______ ___ ______ _________ _________ _____ __________.
_______ _______ ________ ____ _______ ___ ____ ________ ____ ______ ___ ______.
____ ________ _______ _____ ________ ________ _____ _______ _________ ________ ___.
___ ___ ___ _________ ___ ______ _____ _____ ______ ____.
________ ______ _____ _____ __________ __________ ___ __________ ___ ________ _________.
___ _____ ____ ________ ______ _____ ___ _______ __________.
______ ___ ______ _______ __________ ______ ________ _____ __________ _________ _______.
_______ _____ ______ ________ _______ _____ ________ ___ _________.
______ __________ ______ __________ __________ _____ ______ _________.
____ ____ ___ __________ _____ _______ ___ ________ _________ ______.
______ ___ _____ ______ ______ __________ ________ _________ ____ ___.
_______ _____ ___ ___ ___.
________ _____ __________ __________ _________ ____ _______ _____ _____ _________ ________ _________.
________ _______ _________ ___ _________ ________ __________ ________ ____.
_______ _____ __________ _____ _______ _____ ___ _______ ___ ________.
_____ __________ ___ ___ _______ ______ __________ _______ ______.
__________ ________ ___ ______ ________ ________ _______ _______.
________ ________ _________ __________ ________ ___ _________ _________.
______ _____ __________ __________ ________ ________ _________ ____.
__________ ___ _______ ____ _____ _____ ________ _______ _____.
__________ __________ ______ ________ _______.
______ ______ ___ ______ ____ ________ ________ _____ _____ ____ ____ _____.
____ _______ __________ ___ ________ ____.
_________ __________ __________ ______ ___ ______ ______ ______ ______ ___ ____.
____ ________ ______ _________ ___ _____ _______ ________.
_____ __________ ____ ___ ________ ____.
__________ _____ ________ ____ __________ __________ ________ _______ ___ ____ _______ _____.
_____ __________ _____ ___ _________ _________ _____ ________ __________ _________ _________ ____.
___ ________ __________ ___ ____ _______ ________ ________ _________ ____ ____.
_______ ______ _____ __________ ___ ____.
__________ ______ ______ _______ ____ _____ _____ _____ ______ ______.
__________ ______ ___ _________ __________ ___ __________ _____ ___.
___ ________ ________ ________ _____ ________ _____ _____ ___ ___.
__________ ___ ____ ________ _____ __________ ________ _________ ___ _____ ___ ______.
_______ __________ _____ ______ ______ ___ _____ _______ __________.
______ _____ ___ ___ _________ ______ _____ _______ _______ ___ ______.
______ _____ _______ ____ _____ __________ _______ _____ ____ ________.
_______ _______ _________ ____ _________ _____ ________ ________ ______ _____.
__________ ________ __________ ______ ___ _______ __________ ____ _________ _________ ____.
______ ________ _________ ____ ____ __________ _____.
_________ ________ __________ _____ ____ ________.
____ ___ _____ _________ ________ ___.
____ _____ _______ __________ __________ ________.
_________ _______ _______ __________ ______ ___.
______ ______ ___ _________ __________ _______ _____ ______ ________.
____ _________ _________ ___ ____ ___ ________ ___.
_______ _________ ________ ___ _____ _____.
_________ _____ __________ _________ ________ ________ ____ ________ _________ ___.
________ _____ _____ _____ _________ _____ _______ ______ _________ ____ _______.
______ __________ __________ __________ ___.
________ ___ ______ ________ ______ _______ __________.
____ _____ ____ ___ _____ _____.
___ _______ _________ _________ __________ ________.
___ ________ _________ ______ __________ ______ _____ _____ __________ _________.
____ _____ ______ ________ __________ ___ _______ ____ ____ __________ ___ __________.
____ ____ ____ ___ ________ _____ __________ ________.
____ _____ _________ _________ _______ ______ ________.
_____ ____ __________ ______ ____ _____ _____ ___ __________ _________ ______ _________.
__________ ________ _______ _____ ___ ______ _________ ________ ______ ______.
___ _______ _____ _____ ____.
________ ___ _______ _______ ______ _________ _____.
_________ __________ _____ _______ ________ _______ _______ ______.
________ ________ ______ ________ ________ _______ ___ _______.
_____ ________ ______ _____ ________ _____.
_____ __________ ________ ____ _______ __________ ____ ___ ____ _________.
_____ ____ _____ _______ _______.
_________ ________ _________ ___.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.