‫Let's talk about the first property now that we understand transaction at City, Atama City is came
‫from the word atom right in science or is an atom is the smallest piece of a unit that cannot be divided.
‫You cannot divide an atom unless you're doing a nuclear fission and all that stuff.
‫But let's assume atomic atom cannot be divided, cannot be split.
‫And that's what a transaction as a transaction should be.
‫Atomic.
‫When we say a transaction as atomic, that means all of those queries should succeed.
‫And if one of them fail, you better fail the whole thing.
‫You better roll back the whole thing.
‫And now we know what a rollback is.
‫Does that make sense, guys?
‫Very simple concept.
‫OK, why does it matter, though?
‫Why does it matter?
‫Why should I care?
‫Why are you enforcing that?
‫Or are you going to know?
‫Are they the same example without my city, let's say I don't have it on my city.
‫I don't enforce this in my database or over the vendor of this database.
‫Oracle Bosco's didn't implement that at all.
‫Must do, which is bad or all relational should implement that.
‫The Muslim blessing.
‫I'm going to deposit the same transaction.
‫I'm going to do it.
‫But we're going to add some will the spices on top of that again transaction.
‫I'm going to put hundreds of code.
‫OK, I need to check.
‫Does this guy have one hundred?
‫He does, sir.
‫OK, cool.
‫Go ahead and divide the gold.
‫Right with one hundred.
‫And what the heck happened.
‫That's not a machine.
‫That's just a slight good but yeah.
‫Your database crashed something habit.
‫You went back, restarted the database, guess what?
‫That's the last thing you did, you you debated it when I come by you, but you didn't get to the other
‫part of the transaction to actually comment and change that to six hundred.
‫So now you have a hundred dollars in the thin air.
‫It just went away.
‫Right.
‫That's just Budish, right?
‫That's very badush.
‫OK, after we restarted the machines, I can't get credit obviously.
‫So that's what I thought.
‫My transaction is a transaction that will roll back all queries, all changes if one of the queries
‫fail.
‫So that's what it means essentially.
‫Right.
‫So if this is what we had just there is not a atomic transaction, what happened is as bad.
‫Right.
‫So the correct way is to just roll back and roll back this two thousand.
‫Does that make sense, guys?
‫That's what I told my city is.