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 (2.5k points) | 129 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

+1 vote
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 (41 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
48,634 questions
52,769 answers
68,307 users