Register

Two-phase locking & timestamp ordering

• recategorized by
476 views
1 1 vote
For each of the following protocols, describe aspects of practical  applications that would lead you to suggest using the protocol, and aspects  that would suggest not using the protocol:  

• Two-phase locking  

• Two-phase locking with multiple-granularity locking  CO6, L6  

• Timestamp ordering  

• Validation

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · Regular Expressions ...Next → · Relative Addresses
← Previous in category · GO Classes Test Seri...Next in category → · B+ Tree
Position:
Show:

Related questions

1 1 vote
1 1 answer
2.2k
2.2k views
srestha asked Jul 28, 2018
2,239 views
Two Phase Locking
How 2PL guarenteed serializability? I think conflict serializability is not guarenteed for 2PL. But may be view serializable Plz explain it
0 0 votes
1 1 answer
1.6k
1.6k views
bts asked Jun 30, 2018
1,610 views
Two phase locking and time stamp
Which of the following is correct ? I.Two phase locking is an optimistic protocol. II. Two phase locking is pessimistic protocol III. Time stamping is an optimistic proto...
1 1 vote
1 1 answer
2.4k
2.4k views
Tuhin Dutta asked Aug 13, 2017
2,440 views
Two-Phase-Locking
Sort these various versions of Two Phase locking protocols in increasing order of restricted-ness:1. 2-PL(normal)2. S-2PL(Strict)3. R-2PL(Rigorous)4. C-2PL (Conservative)...
4 4 votes
1 1 answer
7.2k
7.2k views
shashank023 asked Jul 25, 2017
7,199 views
conservative two phase locking protocol
Does the conservative two phase locking protocol produce cascadeless schedules?Let us consider the following schedule :Since in the schedule the lock on a is released, it...