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 KZbin 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...

[@shauntomy1277]

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

[@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 😆

[@lordstinson8095]

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

[@ChandanYadav-hb6ux]

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

[@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

[@alibaba888]

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

[@oliveryt7168]

Good explanation.

[@anjalithakkar2259]

you hv a grt handwriting!

[@CodeCraftWithVinayak]

Excellent explaination thankx

[@dfrontierit2114]

Great video. Thank You

[@CreazyFunFactsHQ]

I like more and more what your explanation thanks more

[@rakshitabandi9615]

thank you ,it was nice and simple explanation

[@thakur_185.]

excellent explanation

[@vishnu32108]

Nicely explained 👌 👏

[@khoah9714]

Very good, thanks!

[@jibeshbhattacharjee4306]

Neat. a very good idea for a youtube channel

[@ChandanYadav-hb6ux]

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

[@pvksmaheeth8816]

Nice explanation

[@sanjeevsingh-nh4xj]

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

[@mohamedbalshy3105]

Designing data-intensive applications book is recommended

[@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.

[@jeremiahazubuike3006]

thanks a bunch for the well organized and simplified explanations

[@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

[@ShikhaMallick]

Good explanation...

[@rajatshetty10]

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

[@zhangxin1841]

what about dirty writes and write skew anomaly?

[@AjwogTHUM]

Thank you for this lesson

[@amitasingh3581]

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

[@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

[@aqeelar4121]

Helpful !

[@thotakranthikumar2252]

can u please provide a video on INCONSISTENT RETRIEVAL PROBLEM

[@rajankumar5030]

really helpful

[@Onella3DMusic]

tysm

[@vemulaakash8212]

Thank you that is all I can say

[@fabcotechnologies489]

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

[@saiganeshmunduru5472]

well taught !!

[@lakshayvinayak440]

Will u pls provide us notes of all the topics

[@loveislulu264]

what about multiuser anomaly?

[@kumariabha1382]

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

[@gozdec.1376]

thanks

[@rohanchutke2298]

thanks saved my arse !

[@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