answersLogoWhite

0


Best Answer

The strict two-phase locking (S2PL) class of

schedules is the intersection of the 2PL class with the

class of schedules possessing the Strictness property.

To comply with the S2PL protocol a transaction

needs to comply with 2PL, and release its write

(exclusive) locks only after it has ended, i.e., being

either committed or aborted. On the other hand, read

(shared) locks are released regularly during phase 2.

Implementing general S2PL requires explicit support

of phase-1 end, separate from transaction end, and no

such widely utilized product implementation is

known.

S2PL is a special case of 2PL, i.e., the S2PL class is a

proper subclass of 2PL

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Explain the strict two-phase locking protocal in dbms?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What benefits does strict two phase locking provide and What disadvantages result?

ADVANTAGE: It produces only cascadeless schedules, recovery is very easy.DISADVANTAGE: The set of schedules obtainable is a subset of those obtainable from plaintwo phase locking, thus concurrency is reduced


Give an example where strict 2 phase locking is followed but the resulting schedule leads to deadlock Explain why the 2PL being followed here is strict and explain why there is deadlock?

T1: Write X // This acquires an exclusive lock: LockXT2: Write Y // This acquires an exclusive lock: LockYT2: Read X // This attempts to acquire a shared lock on X, but since X is locked already by T1, T2 is subsequently blocked by the system until X is freed.T1: Read Y // This attempts to acquire a shared lock on Y, but since Y is locked already by T2, T1 is subsequently blocked by the system until Y is free.T1: Commits // This should release all locks held by T1.T2: Commits // This should release all locks held by T2.* Note that "block" means the transaction will not proceed until the specified condition is met.Now, since T2 is waiting for T1 to free X AND T1 is waiting for T2 to free Y, we get into a cycle of condition checking. These conditions will never be met because both transactions are waiting for the other one to do something, in order to proceed itself. Therefore we have a deadlock between T1 and T2 trying to access the shared resources X and Y.The Wikipedia article on Two-phase locking may help you understand why this is strict 2-phase locking and what 2-phase locking is.


What kind of teacher of mr.torres courage?

He is a strict,serious and humorless teacher and his students misjudged him


What did mrs trunchbull do to her students?

Mrs. Trunchbull mistreated her students in various ways, including using fear and intimidation, imposing strict rules and punishments, and physically abusing them by throwing, shaking, and locking them in a spiky cupboard called "The Chokey."


What is a number sentence which states two values as unequal?

A strict inequality.A strict inequality.A strict inequality.A strict inequality.


How do you spell strict?

"s-t-r-i-c-t"


What is a sentence for strict?

I am on a strict diet.


Is is strict a verb?

No because you can not "strict".


Is strict a verb?

No because you can not "strict".


Are iranians lives strict?

Not strict in the life of a particular country. They are strict in all countries. Iranian people inthe region are less strict.


Is Zeus strict?

Yes, very strict.


How can use a sentences strict?

he was very strict about it