258 views
0 votes
0 votes
Q: Assume T2->T1 is one of non-conflict schedule

Suppose

T1 : R1(B),W1(B)

T2 : R2(B)

NOW., R1(B),R2(B),W1(B)

IS there any problem if R2(B) comes in between R1(B) and R2(B) as shown above ?

2 Answers

0 votes
0 votes

I believe your question is if there is a problem if R2(B) comes between R1(B) and W1(B). Answer is no there is no problem. Because it is maintaining T2 -> T1. There is no conflict for R1(B) to R2(B) but R2(B) has to be before W1(B) otherwise R2(B) will read different value of B, and then it will no longer be T2 -> T1, which is not good according to the question.

Related questions

0 votes
0 votes
1 answer
1
Deepak Joshi asked Oct 8, 2023
595 views
A database relation R has 10 attributes (A, B, C, D,..., J)."CDEF" is known to be a candidate key of relation R. There may be other candidate keys, which are unknown. Wha...
1 votes
1 votes
0 answers
2
JAINchiNMay asked Dec 1, 2022
434 views
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false
0 votes
0 votes
1 answer
4
abhinowKatore asked Sep 8, 2022
261 views
If a schedule is not conflict-serializable. Is it serializable?