Intro to ACID Database Transactions | Systems Design Interview: 0 to 1 with Google Software Engineer
Вставка
- Опубліковано 5 лют 2025
- Implementing isolation in databases both takes a long time and is hard - only days ago I heard the exact opposite about my chode
the best part of these videos is that i look forward to these corny jokes, makes me feel i am studying in a classroom setting again. good work jordan
the smiley logo on the tshirt for ACID topic. hats off on the effort Jordan
According to wikipedia, consistency is more about keeping the DB always in a state that respects the rules:
Consistency ensures that a transaction can only bring the database from one consistent state to another, preserving database invariants: any data written to the database must be valid according to all defined rules, including constraints, cascades, triggers, and any combination thereof. This prevents database corruption by an illegal transaction. Referential integrity guarantees the primary key-foreign key relationship
Yeah that's fair to say, just mainly the database doesn't go bonkers due to multithreading.
i think this concern is addressed in the video during the discussion that a consistent database is a database that respects the invariants -- for example the invariant that there is always at least one worker listed for a given shift. (it's interesting that some of the invariants are user defined and some are internal to the database, for example foreign key references -- so maybe part of the expectation would be that a database will always pass an integrity check pragma or something)
wow, congratzz, you survived the first wave
Yeah I'll probably post something about that later today
I always get confused with consistency from ACID because it's different from the CAP theorem, it's good to revisit this topic and refresh this knowledge.
Consistent is overloaded term:
1. Consistent hashing
2. Cap theorem
3. Replica consistency
I like the way you use funny and non funny words, magic man
okay. I was under my table after the foot picture transaction
That'll be $5
no foot pics no $$$. work hard play hard@@jordanhasnolife5163
@@jordanhasnolife5163 double it and give it to the next person🙏
How does successfully enforced atomicity guarantee consistency ? Should it not be the other way round
I think consistency in the ACID meaning of the term basically implies that the database is satisfying invariants, so I guess I would say I agree lol
Feels like a fever dream watching this now getting hit with the bath water
sir not the riley reid
Whoa how'd you get a hold of my browser history?? 🤔
You should provide the readings that helped you come up with this vidya
All these beginning videos are almost completely ripped off of "Designing data intensive applications" by Martin Kleppmann. In the future I'll start to diverge from this book and then will attach them.
@@jordanhasnolife5163 So you're saying that I should just read the book that I bought.
@@chrisrectenwald7307 lol maybe? there are 1,000 beginner python tuts in video, books, blogs... choose the medium, style that you like
@@chrisrectenwald7307 Lol yeah I hate reading too, alas sometimes you must, that being said I think this still has supplemental value as visual examples
Hey yo.