How Do Databases Store Tables on Disk? Explained both SSD & HDD

This video is really scary , much scary than watching insidious ,

Reason: Just upgraded my hdd to ssd and going to learn dbms by making one ( using B-Trees ).

Bkl sahi se padhna sheekh.

How can I learn more on what you are talking about?

Why does he act like Neil degrasse tyson?

What an amazing speaker—You're most engaging speaker on software engineering I've ever seen!

yo' grt Nasser lv u
there is some confusion
HDD sector size is mostly 512 BYTE, and OS reads in sectors nothing less.. so OS blocks are same as sector looks like.
SSD doesn't have sectors. It has pages and blocks. The block size is mostly 512 KILO BYTE! Pages are usually 4 KILO BYTE. So one block has 128 pages in SSD. OS running in native mode will read/write in pages looks like. But garbage collection etc will work with blocks, since updates are rather intensive as you mentioned.

Really informative.
Would love to see some examples of this actually affecting the engineering decisions companies made.

Awesome Content Sir..
Reminded of The Joker in Dark Knight!!

Are you really appreciate the tech behind it? What does "ugly disk" even mean?

"It reads the hold god damn block ." hhhh your video is funny, thanks for the explaination .

Sorry bro but 'sasta' Zayn Malik

Hi Hussein, how can I put my Postgres data on a portable SSD so that I can use the Postgres on my desktop and laptop without restoring? Thank you so much for your teaching!

How many accents...italian, french, german, indian, arabic..

My man, I gotta say I love the way you present information. I'd love to be your neighbor and spend time just rambling on about curious IT stuff.

Is the extra speed of the SSD worth the extra cost?

Nice video. However all the sound effects do not add anything to the content, or provide comedic effect.

that was perfect

Hello Hussein, why do we need to the virtual memory when we retrieve a data from a disk?

Lovely, great content ❤️, can I know some of the names of books behind you? Looks so interesting

very nice,got it

so does it mean given a choice, i better use LSM-indexing db engine (cus btree rebalancing killing ssd)? How easy/hard isit to switch db engine?

How the database programm can find the beginning of the block on the disc?

Very useful stuff. 👍 But I have a question! Would you mind sharing the link @15.42? I was thinking of building a project for DB algorithm visualization so I want to make sure its both distinguishable from that and useful in a practical sense for the average DB student and professional.

Keep up the novel work. Hats-off!

Hey Hussein, thanks for this video 😃
Can you make a video on clustered and Nonclustered indexes also, it has a major role in storing records of tables in memory and it is bit complex. I tried to understand it but didn't understand much. It'll be great if you can make a video about it.
Thanks 😃

Great video. As usual. Thank you.

This channel is a goldmine

Awesome infos bro

Amazing content! :) Just to add to the last mention on Rocksdb, from what I have read. RocksDB is a fork of LevelDB, which itself is an open source storage engine implementation off from Google Bigtable’s tablet storage engine (proprietary ). But yeah, each of these system’s underlying data structure is an LSM Tree. They give you higher write throughput vs BTrees which performs better for reads.

I mostly watch your videos to hear your accent..its super cool. and besides you provide some really good information too.

Hello sir, i really enjoy your videos. Those content are rerely found while entering into microservice jungle :P. But i've one issue. I've watched your all backend engineering playlist. But i'm still confused on how to implement Saga Orchesteration using RabbitMQ. Please Please i need this!! Thank you for such wonderful videos. Love Love !!!!!

Superb content as always 👌

How do Key-Value stores actually store the data on this? Because size per entry isn’t that fixed as in relational DBs

Awesome content Hussein. Thanks a lot. Can you make a video as to how memory management works in NodeJs/Chrome V8?

It's a damn good video!

Amazing absolutely love your content 👌🏻

Thank You for making this video. I have requested for it. Keep sharing ur knowledge with us.

Respect for the PS on the back ❤️

Thanks for this video, Can you explain why RAM is faster than disk seek and can you explain how the data are organized in ram.

Ur videos are dope

Amazing content man.Please make a video on sql vs no-sql and when to choose which.