The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
0 votes
Suppose that transaction Ti issues write(Q). According to timestamp Ordering protocol:

If TS(Ti)<R-timestamp(Q) then Ti will rollback.

My doubt is if TS(Ti) < R-timestamp(Q),it means write operation is occurring before the read operation and hence the transaction is reading the correct value of Q.Then why is it rolling back? Please correct me where am I going wrong.
asked in Databases by Active (1.8k points) | 56 views
if there are some abort operation, then transaction roll back

Only writing and reading not a cause for roll back
Oh yes.sorry missed it.Thank you ma'am

1 Answer

0 votes
There R-timestamp(Q) means process timestamp which read Q value..and it's timestamp is more than the current process which wants to write(Q) so according to timestamp ordering protocol any conflict(hereW-R conflict) from low order timestamp to higher timestamp causes lower timestamp process it's (Ti)rollbacked..
answered by (27 points)

Related questions

+1 vote
1 answer

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

42,295 questions
48,415 answers
62,660 users