‫Let's throw the first one might, I assume.
‫OK, I'm going to sometimes I'm going to butcher the names I've got.
‫I'm going to say my -- am right.
‫But you know what I'm talking about.
‫So it stands for next sequential access method.
‫And yes, it says index because everything is indexed right.
‫And that means every index you create points directly to the row.
‫Right.
‫And that could be advantageous and sometimes bad.
‫So we're going to come through that.
‫Right.
‫So it could be three.
‫And I'm going to make a specific video about Beatriz's and LSM threes.
‫Right.
‫Let's not focus more about that.
‫B three is a computer science, architecture, computer sciences stuff that allows you to store data
‫on disk.
‫Right.
‫So you can search through them very fast.
‫Right.
‫A lot of people don't know what B stands for.
‫That's what the Wikipedia article says.
‫At least I call B.S. on that.
‫I think it's just balance three.
‫Why do we why do we keep complicating things?
‫Just it's obviously it's not binary three, right.
‫Because Beta is not really just you know, you can have multiple knowledge.
‫You can specify many nodes.
‫Right.
‫But yeah, I would, I would, I would just say stands for three.
‫Okay.
‫You can call me out on that.
‫What the indexes point directly to the arrows.
‫Right.
‫So if you think about it like there will be an index and there's likely to be the data itself that rose.
‫Right.
‫And then the the, the the index will point directly to this place on disk offset where that all exists.
‫So it's a very fast access to the location where stuff inserts are also fast, but it doesn't have really
‫transactional support.
‫Right.
‫So you cannot do acid stuff on it.
‫And we're going to show that and and the practical part of this video.
‫So are you going to do transactions, guys?
‫You're stuck.
‫You're going to do like a.
‫Banking stuff where we can debate I want account and put it into one account, in one transaction,
‫that's impossible.
‫So that might be very dangerous to use this at my house and to maybe you can build it at Tomasetti and
‫in in the database layer.
‫That's possible, right?
‫It's not hard, but it could be done by my -- and on itself does not support transactions.
‫So if you're trying to use transactions, you cannot use my ASRM and as been opensource and owned by
‫Oracle.
‫So this thing has been flunking from different people.
‫Right.
‫So I don't remember the first company that created it.
‫It's a Swedish company.
‫Right.
‫I think, sleepyhead, I might be wrong there and then sun board that thing.
‫Right.
‫And then Oracle bought Sun and and MySQL and then Oracle owns all that stuff.
‫My Assim and MySQL database and owns a bunch, A.B., all that stuff.
‫Right.
‫And we're going to talk about why people really hate that part and why people started talking once Oracle
‫started owning this stuff, people started working this thing and creating their own databases.
‫So inserts are fast, updates are the delete are problematic and because they created fragments.
‫Let's talk a little bit about that.
‫So when you answered you always in such to the end of the disk and you know where the end of the file
‫is.
‫So that's fast ride because you always know where the end of the file is.
‫And that's a very.
‫Quick access to the end of the file, you know where it is, so, you know, you can throw stuff at
‫the end.
‫The problem is when you go back and they start updating existing laws.
‫Right.
‫Or maybe deleting existing laws in the middle.
‫Right.
‫So that's a problem because the moment you start deleting and updating, you change the wrong size.
‫And if you change the Rossides, the offsets change and all these the indexes that point to that row,
‫now the offsets change.
‫You have to go and update all your indexes and that's slow, man.
‫So that's why updates and deletes.
‫Right.
‫Are very slow in my --.
‫And because you're updating that thing and you're changing the structure of your file.
‫And that's why those four indexes that point to this roll index offsets 700 is no longer a seven hundred
‫hundred and five.
‫So you have to go and change all that stuff.
‫And that's expensive, right?
‫So database crashes, corrupt, stable, IRA, this place.
‫And a lot of people complain when I face this personally, back when I own my own MySQL, what is it
‫called?
‫The lamp stack.
‫I didn't own Alamsyah.
‫I owned a stack because of windows, but it's the same thing.
‫The database, like in the middle of an inserts, long inserts or updates.
‫If it crashes, you have a corrupt cable you cannot access unless you repair it.
‫And that is right.
‫And that is very problematic.
‫Right.
‫If you corrupt your indexes and and you can see why my -- and tables can get corrupted guys, because
‫we just explained it.
‫We we have a lot of indexes that point directly to the location of the roll on disk.
‫That's bad, right?
‫Because now you have to make sure the database have to update all these indexes.
‫And that's bad because anything that gets out of sequence, well, you have to go and update that there
‫is a repair, the utility that repair stables for you.
‫And it's a portable level locking.
‫There is no overall level locking.
‫So if you want prevent people from editing, you left the whole table versus so that poor people, if
‫they want to insert an irrelevant throw, they cannot write verses.
‫If you want to just really you won't stop people from editing that particular role.
‫Right.
‫You can't write.
‫That's the problem.
‫A.B. supports the role of licking my -- and doesn't sell that kind of loss.
‫Writing down if you have concurrent users.
‫Music Well, Moradi, Arizona DB All of these guys I myself worked well.
‫I was not responsible for it.
‫They also bought my -- am persona.
‫Maria TV used to be the default engine for my sequel until I believe Virgin 5.5 or this guy says, you
‫know what, this is a mess, right?
‫Let's support transaction's a support role Level Looking-Glass support all that foreign kids, all that
‫beautiful stuff.
‫We cannot just start building all these functionality on the database itself.
‫Let's push it down to the storage database.
‫Right as a database engine so people can use this database engine to build their own databases.
‫Right.