Explain the shadow paging recovery technique, Database Management System

Explain the shadow paging recovery technique. 

Ans: Shadow paging is a method used to acquire atomic and durable transactions, and provides the capability to manipulate pages in a database. Throughout a transaction, the pages influenced by the transaction are copied from the database file into a workspace, like volatile memory, and modified in that workspace. While a transaction is committed, all of the pages that were altered by the transaction are written from the workspace to not used pages in the database file.

Throughout execution of the transaction, the state of the database exposed to the user is that where the database existed prior to the transaction, as the database file still consist of the original versions of the modified pages, like they existed before being copied into the workspace. If a user accesses the database previous to the transaction is complete, or on the recovery of a failure, it will come out as though the transaction has not occurred.

Posted Date: 5/6/2013 2:42:37 AM | Location : United States







Related Discussions:- Explain the shadow paging recovery technique, Assignment Help, Ask Question on Explain the shadow paging recovery technique, Get Answer, Expert's Help, Explain the shadow paging recovery technique Discussions

Write discussion on Explain the shadow paging recovery technique
Your posts are moderated
Related Questions
Create an entity relationship diagram, Database Management System

Explain Composite attribute in SQL ? Composite attribute: A composite attribute has many components, each of that is atomic or composite.

What are axioms? Axioms or rules of inference give a simpler technique for reasoning about

What is hash file organization? What are the causes of bucket overflow within a hash file organization? What can be completed to decrease the occurrence of bucket overflow?


#questiononsider the following relation: CAR_SALE =(CAR_ID,oPTION_TYPE, Option_listpreice, Sale_date, Option_discountedprice)..

Define functional and multivalued dependencies.       Ans:  A functional dependency is a assets of the semantics of the attributes in a relation. The semantics point out how at

For the relations R and S given below: R                      S A B C 1 4 7 2 5 8 3 6 9

What is theta join explain? Theta  Join  - The  theta  join  operation  is  an  extension  to  the  natural-join operation which permits us to merge selection and a Cartesian

Two-way Associations Mostly, associations are travel in both directions, although not usually with same frequency. There are three approaches for the implementation. In