#08 - Tree Indexes: B+Trees (CMU Intro to Database Systems)

  Рет қаралды 5,178

CMU Database Group

CMU Database Group

Күн бұрын

Пікірлер: 5
@MohammedAl-Jawaheri
@MohammedAl-Jawaheri Ай бұрын
I'm a bit confused. at 34:50 it seems like we split 16 (as opposed to 15) because 16 was the key that was going to cause the split, but when we launched it up, we decided to take the middle node as the one to split up (13). why isn't it a consistent rule? when 16 was inserted why didn't we say 13 14 15 16 17 we'll split up 15 Edit: NVM so it's the smallest key in the right node in the leaf for partitioning purposes and then later always the middle one (before insertion of the new node) ?
@rohandvivedi
@rohandvivedi 2 ай бұрын
Can some one help me with this: How does borrowing key from the siblings work, when we are dealing with variable length keys? Because now there is a possibiltiy that borrowing just 1 key may not suffice. And, also the new parent separator entry may make the parent node overfull or underfull.
@luatle7100
@luatle7100 2 ай бұрын
1:01:48 hope that satisfies your question
@RN-er7mz
@RN-er7mz 2 ай бұрын
Nice slides
@ankursinghprime
@ankursinghprime 2 ай бұрын
Nice Intro
#13 - Query Execution Part 1 (CMU Intro to Database Systems)
1:23:19
CMU Database Group
Рет қаралды 2,9 М.
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 148 МЛН
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19
The Most Elegant Search Structure | (a,b)-trees
11:38
Tom S
Рет қаралды 38 М.
What is OpenTelemetry?
12:55
Highlight
Рет қаралды 16 М.
The Birth of SQL & the Relational Database
20:08
Asianometry
Рет қаралды 208 М.
#01 - Relational Model & Algebra (CMU Intro to Database Systems)
1:23:38
CMU Database Group
Рет қаралды 23 М.
Understanding B-Trees: The Data Structure Behind Modern Databases
12:39
Systems Design in an Hour
1:11:00
Jordan has no life
Рет қаралды 33 М.
So You Think You Know Git - FOSDEM 2024
47:00
GitButler
Рет қаралды 1,3 МЛН
#07 - Hash Tables ✸ RelationalAI Database Talk (CMU Intro to Database Systems)
1:23:44
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 148 МЛН