Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged -2phaselocking
0
votes
2
answers
1
Self doubt on 2PL protocol
How can 2PL protocol ( simple one ) ensure conflict serializability even though it cannot ensure freedom from deadlock ? I mean ,if a schedule is conflict serializable it has a conflict equivalent to a serial schedule and serial schedules won't have deadlocks .Right ?
How can 2PL protocol ( simple one ) ensure conflict serializability even though it cannot ensure freedom from deadlock ?I mean ,if a schedule is conflict serializable it...
ashunimbz
590
views
ashunimbz
asked
Mar 30, 2019
Databases
-2phaselocking
conflict-serializable
transaction-and-concurrency
databases
+
–
0
votes
0
answers
2
Does rigorous 2pl causes deadlock.
Manojkumar Susarla
353
views
Manojkumar Susarla
asked
Jan 15, 2019
Databases
-2phaselocking
+
–
0
votes
0
answers
3
2 Phase Locking
https://gateoverflow.in/1484/gate1999-2-6 in this questions after T2 is not granted exclusive lock on A does the transaction T2 gets blocked entirely or it can continue to acquire exclusive lock on B? and if T2 continues to acquire lock on B followed by T1 requesting for read and write lock on B successively, is it deadlock situation here? And is that why it is not 2PL?
https://gateoverflow.in/1484/gate1999-2-6in this questions after T2 is not granted exclusive lock on A does the transaction T2 gets blocked entirely or it can continue to...
aditi19
447
views
aditi19
asked
Nov 11, 2018
Databases
-2phaselocking
databases
serializability
transaction-and-concurrency
+
–
3
votes
1
answer
4
2 Phase Locking
Consider the following schedule: S:R2(A) W1(B) W1(C) R3(B) R2(B) R1(A) C1 R2(C) C2 W3(A)C3 Please explain how it is allowed in 2 PL
Consider the following schedule:S:R2(A) W1(B) W1(C) R3(B) R2(B) R1(A) C1 R2(C) C2 W3(A)C3Please explain how it is allowed in 2 PL
shivangi5
1.2k
views
shivangi5
asked
Dec 6, 2017
Databases
-2phaselocking
serializability
databases
transaction-and-concurrency
+
–
2
votes
2
answers
5
2 Phase Locking
State True or False and Tell reason 1) 2PL is always conflict serializable 2)Timestamp protocol is conflict and view serializable
State True or False and Tell reason1) 2PL is always conflict serializable2)Timestamp protocol is conflict and view serializable
srestha
2.9k
views
srestha
asked
Sep 16, 2017
Databases
-2phaselocking
serializability
+
–
1
votes
1
answer
6
Serializability and 2 phase locking protocol
Why is cascading rollback possible in 2 phase locking protocol, we know it guarantee serializability and serializable schedule are strict, which implies it is cascadeless? Please clear the doubt and correct me.
Why is cascading rollback possible in 2 phase locking protocol, we know it guarantee serializability and serializable schedule are strict, which implies it is cascadeless...
Kushagra Gusain
1.0k
views
Kushagra Gusain
asked
Sep 7, 2017
Databases
-2phaselocking
databases
serializability
+
–
To see more, click for the
full list of questions
or
popular tags
.
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register