Simple Locking Protocol | Concurrency Control

preview_player
Показать описание

IMPORTANT LINKS:
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!

Our Social Media Links:

Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Рекомендации по теме
Комментарии
Автор

UPSS!!! 3.00 is wrong! the phrase: "another transaction can apply exclusive lock" is not true! Correction: Only shared lock (read) request could be applied when a shared lock has already obtained.

jkj
Автор

If a transaction has share lock, you CAN'T apply exclusuve lock! FIRST EXAMPLE (with x in circle) IS WRONG!

icscybersecure
Автор

Love your videos, you're saving my life.

maxvandoorn
Автор

Lol all these people correcting his first example without finishing the video. He corrected himself later my dudes.

KCIsMe
Автор

In Transaction T1, we need to acces A first. So shouldn't you have apply shared lock on A to read it first and then Lock-x to write it ?

shashankkumar
Автор

how someone can write a locked item x shared lock in t1 how t2 is accesing it writing it need to first unlock or release the item x incompatible.

gadgetarena.premium
Автор

can you show you how to lock a table(or)database in mysql

manisai
Автор

*If Reading data item does not need locking* then why do we have shared lock ??

ahtisham
Автор

Can someone explain me why there is a need for locks???
I am not able to understand... :(...

lonewolf
Автор

That means shared exclusive locks have no advantages

twinklegarg