The concepts are clearly explained! Love the way you structure the content.
@databasesdemystified7747
3 жыл бұрын
Thank you!!
@BC-hmm
2 жыл бұрын
This is the best breakdown I've ever seen of this topic. Two thumbs up!
@bobsmithson249
Жыл бұрын
This is the best video I’ve found to explain this. Thank you!
@zacharymandell7547
4 жыл бұрын
Nice job. Excited for what's coming here!
@orrlevinger
3 жыл бұрын
Should have much more views and likes!! best explanation ever
@databasesdemystified7747
3 жыл бұрын
Thank you so much! Definitely check out my other videos as well if you want to go deeper on other important database topics :)
@salomeqarchava9359
2 жыл бұрын
It is really demystified. Easy to understand. Need more videos like this. Wish you'd have had more feedback and appreciation from the audience to continue making these videos.
@subashkunjupillai2489
3 ай бұрын
You were amazing with your crystal clear explanation! Kudos!
@KitoKitko
3 жыл бұрын
Thank You :) This is BEST crash course ever!
@vikx02
5 ай бұрын
Great explanation tying the db internals to the benefits and drawbacks of row and columnar databases.
@bucketice300
2 жыл бұрын
I am your 1000th Subscriber. Keep up the good work.
@akashjain7378
2 жыл бұрын
Hands down the best video on this topic.
@manikandanraju2405
2 жыл бұрын
One of the best explanations I've come across. Thanks !
@gokukanishka
3 жыл бұрын
Very nice explanation, thanks
@chilelekohantuba3198
2 жыл бұрын
simple yet detailed explanation. thank you
@Tenshiwing
3 жыл бұрын
Holy shit, what a great video. Been looking for this explanation for a long time
@Enderman0000
Жыл бұрын
Jeez, what a great explanation. More so, in as little as 6 minutes!
@bawonos024
3 жыл бұрын
Pretty briefed explanation. Need reference for Big Data, Data warehouse, etc. Thanks, man!
@samyboulos4642
6 ай бұрын
Amazing presentation Thanks!
@nejimaiden
Жыл бұрын
Great explanation, thank you so much
@techgrace7
Жыл бұрын
Thank you for such classic breakdown of this concept
@hemm2333
3 жыл бұрын
One of the best explanations. Thanks 👍
@SEthan-wx6vt
2 жыл бұрын
Thank you, that clearly explained what is the column store
@ClovisNeto
Жыл бұрын
Very nice video. Clearly explained, short and efficient! Loved it (y)
@hamzakazmi5150
2 жыл бұрын
this is just amazing in such a short video how clearly you explained everything
@abhishekparihar1
2 жыл бұрын
very simple and clear way of explanation of ROW Vs Column Store index - please make more videos-
@dsharma8198
Жыл бұрын
excellent explanation.
@balledachandrahas8326
2 жыл бұрын
Excellent explanantion...!!
@praveen3123
2 жыл бұрын
This video is Gold!
@SudhakarChintapalli
4 ай бұрын
Hi Michael, thank you for sharing your knowledge. Rather than solely providing theoretical explanations, it would have been helpful to delve into practical examples, such as querying different columns for a record in columnar databases. Given that data (columns) in columnar databases is scattered across various blocks, it's crucial to discuss the unique identifier in such scenarios.
@ADAMSIVES
Жыл бұрын
Excellent! Great explanation that's really helped me
@denisvoronov6571
3 жыл бұрын
Perfect video! Brilliant explanation!
@ali194194
2 жыл бұрын
Thank you sir .. Got the Answer. spot on...
@labib8aug
3 жыл бұрын
best video ever on the topic
@atousamas7232
Жыл бұрын
Great video
@oliverkuffner
3 жыл бұрын
Great explanation! Thanks for this video!
@animeshsrivastava2398
2 жыл бұрын
So easy to understand. Thanks
@amirsoltaninezhad8161
Жыл бұрын
Very clear and excellent! Thanks!
@vdweghp
Жыл бұрын
Very good !!
@prajwalpatil8500
2 жыл бұрын
Thanks for this!
@sumanthachark
2 жыл бұрын
Real good explanation!!
@marinaZrZ
3 ай бұрын
wow didnt know usyk was into data.. great video too!
@xian5334
3 жыл бұрын
Great explanation, thank you!
@puneetbanga6818
2 жыл бұрын
Well explained
@Sharmasurajlive
2 жыл бұрын
Brilliant !!
@pavithranful
3 жыл бұрын
Thanks for this, explained well
@FedericoLov
3 жыл бұрын
Good explanation but in practice it's very rare to query single columns so the benefits of columnstore are much smaller than expected. I work in a table with 100 million rows, moved from rowstore to columnstore and didn't notice that great improvement; on the contrary after enabling columnstore I still had to create quite a few non clustered indexes to cover my queries
@databasesdemystified7747
3 жыл бұрын
What sorts of queries were you comparing between the two systems? And yes, indexes definitely still matter!
@phuinh9716
2 жыл бұрын
greate video
@rAlarconBazan
3 жыл бұрын
Store data by rows or. Store data by columns. Column storage is good for analytical workloads. Column storage is easy to compress.
@vinitsunita
2 жыл бұрын
Very Good explaination. I have one question, How do you handle the row insert operation in case of Column oriented database as new data will need to inserted into each block.
@michaelkaminsky9472
2 жыл бұрын
Good question! This is non-trivial and why many data warehouses either don't allow or strongly discourage row-level inserts and updates (since you have to figure out where in each block to insert everything and move other things around).
@michaelkaminsky9472
2 жыл бұрын
Basically the answer is that "it's a PITA" for all of the reasons you can imagine.
@TransparentWorld1275
3 жыл бұрын
Will keep watching these vids, but I'm wondering if anyone has any book suggestions that has all of these concepts explained well and comprehensively.
@sumanthachark
2 жыл бұрын
Nice
@gokukanishka
2 жыл бұрын
Require your help in understanding In case Where there is a table with multiple records of a date And we write the below query : Example select name, id, date From table Where date =2017 In which row / columnar it will perform better If there was just one record of 2017 then it would definatly be row store But in case where there are more tha 1 row of the record which platform works better Note - there are multiple records of 2017
@cherupawan3777
2 жыл бұрын
Here row store index will be highly useful and generally u will be using Id as clustered index so now u can go with date as non clustered index so now all dates are arranged now u can access all rows with 2017 much easily. But when u take column store index data will be separated as columns so it would be take time to access all columns for a row by checking many blocks.
Пікірлер: 62