ACID Properties in Databases With Examples

[@u_ziben]

You beautifully summarized it at the end. Thank you.

[@vivektarab16]

00:28 - Transaction management system
01:00 - Consistency
02:44 - Read

[@dustmighte]

Acid is definitely a must, once each quarter or so

[@joepasqua1751]

Very useful video, as usual. Unsurprisingly, Isolation is the most poorly understood part of ACID by a large margin. Many DB’s use “Read Committed” as their default isolation level and this can cause confusing errors in the face of long running transactions. Especially if the transaction durations are being influenced by performance. “Why do I have this failure only when the DB is under very heavy load?” It can be tough to reproduce.

[@ashadulmridha6551]

Finally Im clear about ACID

[@raj_kundalia]

Amazingly simple explanation, thank you!

[@erfan_rad]

Very simple and useful explanation. And that summary in the end really nailed it. Thank you.

[@vivekravi827]

Consistency (rules) on RDBMS is different from Consistency (replication) on NoSQL

[@zivunknown]

No, that's a difference between ACID and CAP.

[@nosyarlin]

I wish more resources emphasize on this point

[@PyProEm]

Just found this channel. Excellent presentation!!

[@idocoding2003]

I suggest reading korth. That book is godly. ❤❤. I love DBMS

[@LailaInSp]

may i know the exact book? thank you

[@idocoding2003]

@@LailaInSp database concepts by Henry f korth

[@giteshkhanna2633]

The best video on ACID

[@RtoipKa]

Consistency was added only to make Acid acronym. "Designing data intensive applications"

[@MrYerak5]

At least it's not AIDS

[@swizzthesecond]

Thanks for making this helpful video.🙂

[@brunofares9586]

Amazing, God bless you man

[@oldoctopus393]

0:30, "transaction management systems often use loCKing mechanism", looks like there should lock icon on slide instead of log

[@akhilmn4013]

I think he means logging, not too sure but you can check this out: en.wikipedia.org/wiki/Write-ahead_logging

[@oldoctopus393]

@@akhilmn4013 makes sense, thank you!

[@DushyantKumar-mj6ob]

Beautifully explained 🤌

[@shantipriya370]

wonderful explanation

[@장하영-x1f]

Hello. Thank you for always posting good content videos. Is PowerPoint the tool you use to present? I wonder how you present in an animation.
I'm a person who wants to have the ability to explain visually like you.
Thank you.

[@Daviddd10]

What software you use for your diagrams? Its amazing

[@artemcodes]

Thank you it was very helpful

[@djmehrzadgsan]

Hi,
May I know what application or program do you use for creating the RUclips animated contents.
Thank you.

[@Ukuraina-cs6su]

How do they make such a beautiful presentation?

[@PixelShah]

Nice content ❤
What tool used for the animations

[@gosnooky]

Bank accounts can't go negative? My bank account during uni would disagree 😂

[@kirinyetbrian]

😂😂😂

[@zixuanzhao6043]

A snapshot of the data doesn't include the new row, so why non-repeatable (backed on snapshot) reads still sees fantom data?

[@vivektarab16]

03:13 - Read Commiter

[@DK-ox7ze]

What's the default isolation level for RDBMS?

[@kafychannel]

It depends. In postgresql it is read committed,in mysql is repeatable reads

[@DK-ox7ze]

@@kafychannel What's the difference between the two configs?

[@javohirmirzo]

@@DK-ox7ze please rewatch the video to understand the difference. in short the difference is highlighted at 3:57

[@dinamohamed13600]

Amaaaaaaazing!

[@codingmario]

Amazing video

[@octaviocardenas4012]

good stuff

[@gus473]

Excellent examples and explanation! 🫡

[@garrysingh4484]

What software are you using for the diagrams & animations ???

[@ByteBite101]

Illustrator & After Effects are the go-to option.

[@Ukuraina-cs6su]

@@ByteBite101, thank you. Before, I thought that After Effects was for movies only.

[@cecilechau7932]

ACID is the property for database transaction - roll back, not partial changes -

[@rishiraj2548]

Thanks

[@stormShadow64]

Atom IS dividible for god sake

[@GabryelMonteiro]

It is the other away around, atom means indivisible in ancient greek.
So the word atom IS indivisible. That the physical atom is divisible is the problem.

[@GabryelMonteiro]

(And now I imagine a world where the atom is just called tom)

[@RicMorn]

“The” atom is divisible.
The concept behind the term is not: looks like physicists were too hasty about this…😊

[@randomname435]

When SQL was invented, scientists didn’t know that atoms are further divisible. SQL is that old.

[@alexmadnix]

Sahn lam & Alex xu

[@makdan1331]

who is here for the AZ900 :)

[@enriqueruiz320]

😲🤯

[@shahabbadihi3453]

Wish you hired an Indian speaker for your videos! I can't understand you without following subtitles!

[@ゾカリクゾ]

what's up with the thumbnail tho? expected a more professional look (I'm talking about the "really mean")

[@sameergaikwad222]

Seriously your pronunciation is hard to catch.

[@Ukuraina-cs6su]

His pronunciation is fine. But please help him with production.

[@ameywani8]

learn indian accent