wu :: forums - Print Page


    
      
        wu :: forums
        (http://www.ocf.berkeley.edu/~wwu/cgi-bin/yabb/YaBB.cgi)
      

        riddles >> cs >> DBMS
        
(Message started by: kirru on Jun 17^th, 2011, 5:15am)

Title: DBMS
Post by kirru on Jun 17^th, 2011, 5:15am

which of following schemes ensures atomicity?
1. shadow paging 2. deferred data base log modification 3. immediate data base log modification

Title: Re: DBMS
Post by Grimbal on Jun 17^th, 2011, 6:49am

http://en.wikipedia.org/wiki/Shadow_paging
answers your question.

Title: Re: DBMS
Post by TenaliRaman on Jul 28^th, 2011, 11:06am

Actually even (2) ensures atomicity. The only one in your choices that doesn't ensure atomicity is (3).

-- AI

Title: Re: DBMS
Post by meena05 on Aug 23^rd, 2011, 7:27am

Meena :)

(2) is right option to ensure atomicity in dbms.

Title: DBMS
Post by Neetasha on Sep 15^th, 2011, 9:17pm

(1.)shadow paging is one of the ensure automatic recovery system in dbms.

Title: Re: DBMS
Post by khuram4u on Oct 25^th, 2011, 12:02pm

Correct is Shadow paging, as everyone talking about. I would like little explanation.

In Shadow paging, During a transaction, the pages affected by the transaction are copied from the database file into a workspace such as volatile memory, and modified in that workspace. When a transaction is committed, all of the pages that were modified by the transaction are written from the workspace to unused pages in the database file. During execution of the transaction, the state of the database exposed to the user is that is which the database existed prior to the transaction, since the database file still contains the original versions of the modified pages, as they existed before being copied into the workspace if a user accesses the database before the transaction is complete, or upon recovery of failure, it will appear as though the transaction has not occurred.

Title: Re: DBMS
Post by newbea on Feb 15^th, 2012, 3:25am

Hey, i am developing an android app and i am now searching a dbms for a fast wireless usability. what do you think about that? anybody has experiences and could help me with a short notification? I would rather hit the 'lottozahlen' (http://www.lottovergleich.com/lottozahlen) than finding good information in dev forums. ;) thanks and best regards

Title: Re: DBMS
Post by frankrizal on Feb 21^st, 2012, 6:53pm

Well we also did some apps in android.. But it was my partner who's the expert. >:(

Title: Re: DBMS
Post by mbringas on Mar 7^th, 2012, 12:05pm

(2) is right option to ensure atomicity in dbms. :P

Title: Re: DBMS
Post by swedit on Apr 18^th, 2012, 6:07am

is there anybody expert in stochastic?? I need probabilities and information about numbers games like mega million, eurojackpot etc. Iam searching reliable sources ^^

Title: Re: DBMS
Post by newbea on Apr 25^th, 2012, 7:04am

on 04/18/12 at 06:07:19, swedit wrote:

Iam searching reliable sources ^^

You are speaking about number games and you want reliable sources? ;D Nice one! What are searching for? First I would have a look for a study book, eg

amazon.com/Stochastic-Games-Applications-Science-Series/dp/1402014937

greets

Title: Re: DBMS
Post by newbea on May 2^nd, 2012, 3:27am

hey..about the eurojackpot I did a quick research on google. check them out for stochastic explanatory notes.

// removed link; didn't work anyway

Title: Re: DBMS
Post by pawanseo on May 2^nd, 2012, 11:39pm

shadow paging is your answer
// irrelevant link removed by moderator --SMQ

Title: Re: DBMS
Post by swedit on Jun 26^th, 2012, 10:10am

Done! My app for online lotto is nearly finished. If the usability stress test passes I'll give you the link. :) :)

Title: Re: DBMS
Post by Grimbal on Jun 28^th, 2012, 8:47am

irrelevant links will be removed by a moderator
:P