Тёмный

B-Tree Indexes 

Ivan talks about computers
Подписаться 2,2 тыс.
Просмотров 123 тыс.
50% 1

In this video, I'd like to take a look at B-tree indexes and show how knowing them can help design better database tables and queries.

Наука

Опубликовано:

 

1 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 40   
@keithdesouza8859
@keithdesouza8859 6 лет назад
Nice. I think you need to fix the graph O (n). It's a linear straight line increasing ar a fixed rate with time.
@stevengreen9263
@stevengreen9263 5 лет назад
No, it grows linearly with size. Size wasn't growing linearly, so the graph was not linear
@Jonasmelonas
@Jonasmelonas 4 года назад
@@stevengreen9263 You are correct, but I still sort of agree with Keith. It should be changed. Why use an exponential graph when talking about a linearized model, it just creates confusion. Also, size and time should be the axes, which would force a linear plot, not its own function of variables we are not even given :s
@PhanniHam
@PhanniHam 4 года назад
@@Jonasmelonas exactly
@AnimilesYT
@AnimilesYT 4 года назад
well explained, good sound quality, good pronounciation, nice animation, and just everything is really well done!
@slapcanister
@slapcanister 2 года назад
Thanks for this - you have the knack for top quality content, would love to see more!
@edo9k
@edo9k 5 лет назад
Great video! I like the way you explain it, straight to the point, short and simple, which the visual part is too.Kudos!
@shubhammaniyar8530
@shubhammaniyar8530 6 дней назад
Great video and explanation!
@RucuryBeans
@RucuryBeans 6 лет назад
Great explanation! Nice animations, too. Good work!
@Arthur-cx1cg
@Arthur-cx1cg Год назад
Im shocked on the information and delivery. Very good. Thank you.
@michaeljunicesalvilla8736
@michaeljunicesalvilla8736 8 месяцев назад
Very good explanation. Good job, Ivan!
@farhadegza2
@farhadegza2 5 лет назад
Good job, easy to understand explanation. Please publish more videos.
@ashs3979
@ashs3979 5 лет назад
Thank you so much! Short and clear video
@masipal1054
@masipal1054 3 года назад
Waw, thank you for this information of b-tree. I'm from Indonesia and i like your video!
@maxx27i
@maxx27i Год назад
Awesome explanation! 🤩🔥
@MichiLetsPlay
@MichiLetsPlay 4 года назад
I *reaalyy* like the style of this video, keep going :D
@ivantalksaboutcomputers7327
@ivantalksaboutcomputers7327 4 года назад
Thanks, will do!
@sufiyaanrajput7533
@sufiyaanrajput7533 2 года назад
Why did Ivan stopped talking about computers? It was the shortest and to the point explanation. I appreciate also showing examples of when to use and alternatives at the end.
@palaaaurinkoon
@palaaaurinkoon Год назад
Thank you for the explanation, but I guess I am wondering, what should we be indexing?
@mrmohamed5494
@mrmohamed5494 4 года назад
Thanks a lot ! and I love your voice (Mario Kart) :)
@freddylem2659
@freddylem2659 Год назад
Great vid!
@sametnalbant9316
@sametnalbant9316 3 года назад
I waste my 4minute and 32 seconds thanks for the nice video!
@sanmaro91
@sanmaro91 5 лет назад
thank you . helped alot
@timmyguo
@timmyguo 2 года назад
great video
@olcaybolat3452
@olcaybolat3452 Год назад
Video iz amazing I think b+ trees also should been mentioned
@yoshuaputro9786
@yoshuaputro9786 5 лет назад
Linear is a straight line bro, but thanks for the explanation. Keep going.
@BymiJonesJunior
@BymiJonesJunior 4 года назад
Красава
@minagabriel5556
@minagabriel5556 6 лет назад
This is not the linear graph "Linear is straight line"
@asadsbhatti
@asadsbhatti 5 лет назад
well use of animation
@maganzo
@maganzo 6 месяцев назад
1:00 this graph has no labels and shows exponential growth not linear
@luco-games
@luco-games 3 года назад
Access to the disk is expensive? Have you learned it from HDD times, rather than SSD? 🙃
@ivantalksaboutcomputers7327
@ivantalksaboutcomputers7327 3 года назад
Hehe. Good times though!
@createthiscom
@createthiscom 2 месяца назад
I don't understand why at 3:56 you say datetimes cannot be indexed. I'm pretty sure that isn't accurate.
@danielgrohol7365
@danielgrohol7365 2 года назад
Hi Ivan, I think you should buy a better mic or repair the echo, but I like this video so much! Thank you.
@galeop
@galeop 5 лет назад
Great! But it would be better without the high-pitch rhythmic sounds
@ivantalksaboutcomputers7327
@ivantalksaboutcomputers7327 5 лет назад
Thanks, will keep in mind for the future!
@troooooper100
@troooooper100 3 года назад
i dont get it.......
@piotrjozef8797
@piotrjozef8797 2 года назад
i cant focus to that music....
@zenelf3556
@zenelf3556 11 месяцев назад
The music is very bad I wished if the video without music
Далее
МЯСНОЙ ЦЕХ - Страшилки Minecraft
37:24
Мама ударила дочь #shorts #iribaby
00:17
B-trees in 6 minutes - Insertions
6:36
Просмотров 40 тыс.
DBMS Indexing: The Basic Concept
9:52
Просмотров 294 тыс.
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
7 Database Paradigms
9:53
Просмотров 1,5 млн
The Secret Sauce Behind NoSQL: LSM Tree
7:35
Просмотров 189 тыс.
Mysql Index Tutorial | [Simple Explanation] [2020]
6:56