Problems with Concurrent Execution of Transactions

Join Discussion: www.techtud.com...
IMPORTANT LINKS:
1) Official Website: www.techtud.com/
2) Virtual GATE: virtualgate.in/...
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!
Our Social Media Links:
Facebook Page: / techtuduniversity
Facebook Group: / virtualgate
Google+ Page: plus.google.co...
Last but not the least, SUBSCRIBE our UA-cam channel to stay updated about the regularly uploaded new videos.

[@invisiqueshadow5972]

Maturity is when you realise that this is better than gate smashers.

[@semthree5736]

Yeah bro..this is so good...

[@tejeshkonchada3971]

Play at 1.25 times original speed. Thank me later

[@stable_electron]

thank you! you time saver

[@_sourav_]

Playing at 2x still seems slow xD

[@raghul867]

I'm the only one who watching this with 2x speed before 10mins of exam.

[@monsterrock8108]

How was the exam bro 😆

[@shauntomy1277]

One of the best teachers i have seen, keep up the good work :)

[@lordstinson8095]

What's the difference between "Unrepeatable read" and "Phantom Read" problem?

[@ChandanYadav-hb6ux]

nice explanation....
please uploaded video on Concurrency Control..

[@alibaba888]

Very simple and understandable, just what I was looking for thank you

[@attacker21]

What a good explanation.

[@moha_linus]

I don't understand English but i understand you hahaha
It's very good explanation from u
Thnx to much

[@oliveryt7168]

Good explanation.

[@ChandanYadav-hb6ux]

nice explanation..
please uploaded video on topic in dbms like Dynamic Hashing ,Indexes ...

[@anjalithakkar2259]

you hv a grt handwriting!

[@CreazyFunFactsHQ]

I like more and more what your explanation thanks more

[@rakshitabandi9615]

thank you ,it was nice and simple explanation

[@venkateshchowdarapu5125]

Sir in dirty read problem example how can T2 read the value of X as 110 instead of 100 which is not commited.

[@sauravkumar7508]

Because in t1 a write operation is performed after increasing the value of A.

[@CodeCraftWithVinayak]

Excellent explaination thankx

[@dfrontierit2114]

Great video. Thank You

[@khoah9714]

Very good, thanks!

[@thakur_185.]

excellent explanation

[@jibeshbhattacharjee4306]

Neat. a very good idea for a youtube channel

[@rajatshetty10]

Thank you very much for the explanation sir....

[@vishnu32108]

Nicely explained 👌 👏

[@zhangxin1841]

what about dirty writes and write skew anomaly?

[@pvksmaheeth8816]

Nice explanation

[@sanjeevsingh-nh4xj]

does w(x) means writing update to database?????

[@mohamedbalshy3105]

Designing data-intensive applications book is recommended

[@muthaiahpalaniappan8009]

Sorry for my ignorance...but what is the use of writing to the Database???
It can commit directly while it writes to the table, right??, why is this intermediate step of writing to Database? If it's really required can you give me an example, at which point it may failed to commit when the write is successful. Thanks

[@jeremiahazubuike3006]

thanks a bunch for the well organized and simplified explanations

[@AjwogTHUM]

Thank you for this lesson

[@SarbotamChatterje]

IS IT A DIRTY READ CASE DURING LOST UPDATE PROBLEM? I THINK NO, COS THE VALUE OF X IS NOT YET WRITTEN IN COLUMN 1 AND THE VALUE IS STILL 100 FOR X IN COLUMN 2.. PLZ EXPLAIN. 5:10

[@wonkyochoe2093]

I'm not sure what your are trying to say but if I understand correctly, that is not a "dirty read case". The problem of above schedule in Lost update problem is that T1, T2 are not serializable. In other words, that schedule is wrong case since T2 will read not-updated "x" value from Hard disk. In this case, all transaction will be terminated or committed without abort but x will be a wrong value.
In contrast, in dirty read case, x must have a original value because T1 has been aborted. But, T2 still have a changed "x" value. So, this case is not a updating problem.
I wrote this knowledge as far as I know. If you find any incorrect information about above comment, please make correction

[@bushrapirzada6776]

Yes you are right, the word itself says DIRTY READ, means a failed value is read by some other transaction, and a value is read by other transaction only if it is written(write) first

[@thotakranthikumar2252]

can u please provide a video on INCONSISTENT RETRIEVAL PROBLEM

[@ShikhaMallick]

Good explanation...

[@fabcotechnologies489]

CHeck out the Pi calculus and Rholang/RChain project, safe concurrent execution

[@amitasingh3581]

sir please prefer white background color
it's comfortable to read with white bg

[@vemulaakash8212]

Thank you that is all I can say

[@kumariabha1382]

sir pls make vedio on what are WR ,RW,WW problem plzzzzzz

[@Onella3DMusic]

tysm

[@aqeelar4121]

Helpful !

[@rajankumar5030]

really helpful

[@lakshayvinayak440]

Will u pls provide us notes of all the topics

[@saiganeshmunduru5472]

well taught !!

[@loveislulu264]

what about multiuser anomaly?

[@rohanchutke2298]

thanks saved my arse !

[@gozdec.1376]

thanks

[@shambhavi_7957]

i did not understand the last two ones incorrect summary and unrepeatable read
can u please explain...

[@rakib5969]

Are you Bangali ?

[@Dnyaneshwar_Mulay]

Wrong information shared