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

Ask an Expert

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

Write your message here..

Related Questions

Create an entity relationship diagram, Create an entity relationship diagra... Create an entity relationship diagram, Database Management System

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

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

What is hash file organization, What is hash file organization? What are t... 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?

Database structures, 3 assignments combined in 1 3 assignments combined in 1

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

Define functional and multivalued dependencies, Define functional and multi... 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

Compute natural join and outer join, For the relations R and S given below:... 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, What is theta join explain? Theta  Join  -... 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

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