‫So all the material I looked at regarding the B trees and the B plus trees has been purely theoretical
‫and very hard to put in practice when it comes to actual real production database systems and linking
‫those to in practice.
‫You know, what you studied in a university shows you how to do the math of the B3 and how to traverse.
‫But when you actually know how these things work and used an actual database system such as balseros
‫or MySQL or Monga DB, then you're going to understand the proper path a query takes in order to be
‫optimal using a particular index.
‫So in this video, I want to shed a light about batteries and B plus trees, the evolution of B batteries
‫to be plus blusterous, specifically with regard to production database systems.
‫So if you enjoy this stuff, let's just jump into it.
‫We need to start with the problem.
‫The problem is what we call full table scans.
‫What are those?
‫This is this is the slowest form of scans.
‫In order to find a particular item, we need to scan the entire table.
‫And that's the original problem that that spurs the rest of the discussions here that we're going to
‫discuss.
‫The B3 or stands for balanced arrays could be stands for Blowing Tree, because that's the research
‫lab that spurred that paper or can can stand for Bare Tree, which is the name of the author of the
‫paper, one of the authors of the case.
‫And we're going to talk about the battery limitations, the limitation of the original proposed batteries
‫and how it was kind of changed and varied to this B plus SRI's, which is mostly used in old database
‫system.
‫I don't I didn't see any database system use pure battery.
‫And it's original, although they when you read the papers, when you read the.
‫The documentation, they refer to it as Vetri, because that's what is known, but in fact, it might
‫have been B plus three.
‫We're going to discuss these discussions.
‫We got some consideration is what it's come to be.
‫Plus threes.
‫All right.
‫Just just discussions and learning the intricacies of the B plus TRÉS memory users, storage, stuff
‫like that.
‫And then we're going to talk about how B plus C storage cost varies in my school, specifically, A.B.,
‫because my school is a database engine specific because you can with all the database engine underneath
‫my school to be anything really, that is, you can put it as a ASV storage, you can put it at RDB.
‫That's the default and put it as my assim.
‫You can put it as far as entries like my rocks, rocks, DB, stuff like that.
‫I go to discuss House because these are the most databases that I'm familiar with.
‫I also know a little bit of SQL Server.
‫I'm going to throw in some SQL Server Oracle stuff, knowledge like them.
‫I'm going to summarize the whole thing.
‫So this is the agenda of this video that's just jump into it.