edited by
744 views
1 votes
1 votes

IN these questions , in T1  it will read value  of A from hard disk or local buffer and W(A) when execute it will make change in local buffer or hard disk , are w(A) and commit are same because commit means we stored data in hard disk anyone explain plz in detail

edited by

1 Answer

Best answer
1 votes
1 votes
commit and w(a) are not same

w(a) means saving data somewhere(hard disk or local buffer) but if system fails that data is loss, but commit means saving as well as making an entry in log record  of database and replicating value in all servers throughout network so just in case there is failure in any of servers it copy will exist. also unless commit if performed there is no guarantee that ACID property will be maintained.

In simple word commits means changes performed are permanent and W(a) means change is temporary.

Example

Suppose there is only one transaction, you want to someone Rs 100 form your bank account, money has been deducted from your account, and successfully reached to person account, but if this transaction is not committed both you and another person won't see any change in your account. as soon as transaction is successfully committed both will have new updated balance in account
selected by

Related questions

3 votes
3 votes
2 answers
2
pream sagar asked Jun 1, 2018
4,138 views
If schedule is Serializable then free from WW, RW,WR .But Lost update may be possible .please explain how in serializable schedule lost update problem still exist.
0 votes
0 votes
3 answers
4
rahul sharma 5 asked Jan 7, 2017
2,214 views
W1(A),R2(A),W2(A),W2(B),W1(B)This schedule has WW conflict but not Lost update problem,Please explain why?Is it possible to have WW conflict without lost update?