I am from Pakistan. May Allah give you best reward for providing ease to the students.... please teach the teachers here how to teach. they have no idea how to teach students. lots of respect for you and best wishes....
Very nice explanation ... i used to be a biology student but i took engineering line, i nvr studied computer based subjects even my teachers failed to explain thm to me but you ..... you are like a light spot in my black world ..... keep it up plz upload more subjects realated to it stream
Thanku sir. I always watch your video. You inspire me as a TH-camr also because I am also a TH-camr. And want to become a teacher like you . Love you sir.
Amazing !!I found another great teacher on utube. Also, I did not understand one thing why it is called 2PL? And 2PL and serializability r same things or different? Also, To solve transaction issue in microservice architecture people uses 2PL. can u ellaborate how that work?
there are various problems occurs to achieve serializability, to overcome these problems we use shared/Exclusive lock but there are also some problem occured in these two, then we finally use 2PL that ensures complete serializability.
sir in irrecoverability , the T2 transaction is demand for shared lock s(A) when when shared lock we can do only read opertaion so there is no effect on database value of A bcs we are not updating the value we are only reading so how we can say that T2 is not recoverable although if T1 get rolls back there is no problem bcs T2 does nothing write operation in A value .. pls answer
the value which we are reading is wrong because after t1 write operation we are reading updating value of transaction t1 in t2 and when t1 fail t2 is committed so in this case it is irrecoverable
Sir ap roj ap statrgy bta rhe the important topic ko revise krne k liye ..bo post sir muje dikh ni rhi ab...muje plz sir help me muje un tooic ko mark krna h apne syllabus me.
Useful work done by transactions gets lost due to failure in even a single transaction which leads to cascaded rollbacks of all the uncommited transactions. This is not desirable.!
![PASULOL รามเกียรติ์ ตอนที่ 4 นนทกพบรัก [Ramakien Ep.4: Nonthok in love]](http://i.ytimg.com/vi/tMUQgmZzf_A/mqdefault.jpg)
![กี่หมื่นฟ้า | Your Sky Series EP.1 [2/4]](http://i.ytimg.com/vi/qJbQs_nhjD4/mqdefault.jpg)
I am from Pakistan. May Allah give you best reward for providing ease to the students.... please teach the teachers here how to teach. they have no idea how to teach students. lots of respect for you and best wishes....
*Ohh shut up followers of phedophile*
You are god of dbms ,finally i had finished your all lecture. And 100% confidence in dbms
Very nice explanation ... i used to be a biology student but i took engineering line, i nvr studied computer based subjects even my teachers failed to explain thm to me but you ..... you are like a light spot in my black world ..... keep it up plz upload more subjects realated to it stream
Thank you so much
Nice keep growing on
U r awesome... U tube pr only u .......who have cleared my all doubts ...thanks
sir hamesha bhot accha smjhate hai , ek hi bar me smjh aajata hai, thankyou sir for your hard work.❣❣❣
All your videos are very useful and clear Sir!
Sir aapka lecture dekhne se phle like nhi kru to sukoon nhi milta and I feels like I cheated you so first i like then i love to watch lecture ❤️
Thanku sir. I always watch your video. You inspire me as a TH-camr also because I am also a TH-camr. And want to become a teacher like you . Love you sir.
Your explanations are just perfect 😊
Hey , I really appreciate this , It was so hard to feel the concept from the reference book . Thank you so much for helping us out !
Very great explanation sir !
It helped me alot thank you so much for this video.
You are great sir. I very much love you sir!!!
Mind blowing
watching from Bangladesh
Amazing !!I found another great teacher on utube. Also, I did not understand one thing why it is called 2PL? And 2PL and serializability r same things or different? Also, To solve transaction issue in microservice architecture people uses 2PL. can u ellaborate how that work?
there are various problems occurs to achieve serializability, to overcome these problems we use shared/Exclusive lock but there are also some problem occured in these two, then we finally use 2PL that ensures complete serializability.
Two phase , growing and shrinking
Very nice explained
We can rollback commited transaction through campanstate transaction 👍 Isn't it?
nice explanation thank you sir
Great sir👌👌
I think we should say that this schedule is always conflict serializable, but not necessarily serializable
Amazing 👌👌 👌
if it is serializable then it should be recoverable also
his teaching skills are pro, but did you all notice his sweatshirt collection very cool :p
very good explanation
Nice sir❤️
Thank u so much ❤️
Thank you so much sir❤️
Two persons waiting for each other to text first.
That is deadlock 🗿
salute to u sir.
best videos . Keep the good work up :)
Thanku sir
Sir, GATE exam ke liye swiching Theory ke uper videos banao na sir.
Thank you sir ☺️
ap jaisa sir kiu sirf youtube me parat hai...clg mai kiu nahi ate aap jaise teacher...
agar trans 1 mein x(a) firr r(A) , w(A) ho or fir trans 2 mein r(b) ho to r(b) pe to wo lock lg sakta hai tp fir serializibilty to nhi hoga
@ 4:32 how can we give shared lock on exclusive lock.
Paji ek number 👍
I hv doubt here...unlock ke baad lock grant e nai hoga phr commit krne mein kaise prob ayegi...case 1
sir in irrecoverability ,
the T2 transaction is demand for shared lock s(A) when when shared lock we can do only read opertaion so there is no effect on database value of A bcs we are not updating the value we are only reading so how we can say that T2 is not recoverable although if T1 get rolls back there is no problem bcs T2 does nothing write operation in A value .. pls answer
How would failing of T1effect when it is not holding any lock in shrinking phase how it can perform other operation in future?
the value which we are reading is wrong because after t1 write operation we are reading updating value of transaction t1 in t2 and when t1 fail t2 is committed so in this case it is irrecoverable
Very Very Thanks Sir
Gurujee shandar jabardast zindabad
2:51 but sir write to kar hi nhi skhta shared lock hai!
Thank you sir
Thankyou sir
I can't understand your language sir please try to teach in English it would be very helpful to other students from other languages
You can utilize subtitle's
Sir ajj mera NET ka paper tha
AI k bhut questions aye hue they
Sir aap lpu me padhate ho????
yes
Sir,shared exclusive me bhi to fer cascading rollback hoga fer.....
Sir compensating transaction se roll back kiya ja sakta hai, commited transaction ko
Sir cascade schedule can also recoverable. If I am wrong then tell me sir
no
No
Sir ap roj ap statrgy bta rhe the important topic ko revise krne k liye ..bo post sir muje dikh ni rhi ab...muje plz sir help me muje un tooic ko mark krna h apne syllabus me.
sql k previous year upload kijiye
Sir, why is cascading rollback said to be a 'disadvantage'?
Useful work done by transactions gets lost due to failure in even a single transaction which leads to cascaded rollbacks of all the uncommited transactions. This is not desirable.!
Bcos cpu was utilised for doing wasteful work and spent time in doing which went rolled back.It could have completed other useful processes
Low performance.
I love you
jo abi yaha tk aa gaya matlab pass ho jao ga itna to ha 🐓🐈
Sir iam requesting you to post the videos in English also ,please consider my request
Sirr plzzzzz replyyy me
Thankyou sir
Thank you sir