How row oriented and column oriented db works?

There are two types of data storage database one is row oriented database and another one is column oriented database. It stores data table by row and common method of storing a table is to serialize each row of data. Row-based systems are designed to efficiently return data for an entire row, or record. In this video I am going to show exactly how the data is stored in memory.
#microservice #learnmicroservices #totorialssystemdesign #microservicestutorials
#systemdesigntips #systemdesign #computerscience #learnsystemdesign #interviewpreperation #amazoninterview #googleinterview #uberinterview #micrsoftinterview

[chakriadm]

Man, you are genius. I have been in IT for 15 years and hardly know 10% of what you know. Your explanation- how you touch basics and build on top of that is simply amazing. I really like how you are emphasizing conceptual knowledge. You rock.

[rhugvedchaudhari]

Hands down, the best explaination available, covering all the technical aspects. Genius!

[daleffi]

Thank you sir. I've worked with relational databases all my life.
Since Cassandra started to be a trend back in the days, i was having a hard time to understand how exactly the concept of column family databases really works.
Until today.
Thank you very much.

[vikashmandir]

I liked the topics getting covered by u. This channel is really helping me to understand system design concepts used in real world.
Also it will be great if u cover the internals of a message queue.

[JoscelinTrouwborst]

Have watched several of these explanations. I feel your use of the white board stands out. Clear consistent and detailed explanation as well. Hat off :-) .

[bactran]

very clear explanation of row-oriented and column-oriented database. Thank you very much

[sanjayg]

You got great grip on the topic and deep understanding of data storage on the disk; simply you are the best and Great!

[ShabnamKhan-cjzc]

Thanks a ton ton.. I have been looking for coloumn based db and how its better. This vid explained everything.. Thanks a lot ..Your every video give so much knowledge which cant be found under one video with explanation in simple way.. Thanks a lot narender for taking out time and making vidoes..

[SAW]

You are a genius. I loved the way you explain the topic and how you relate the problem

[mindcontrolkmc.]

Both of your English and explanation are so clear. Thank you so much, bro!

[ameyapatil]

This is best explanation i have come across ! lucid ! swell !

[edgarcheverier]

Thanks man, great explanation! would be awesome if you could do the same with document-oriented db!

[senthilvs]

@narendra, good concise one. wish u do more . thanks

[mainakchatterjee]

Woww..!! What an explanation..!!..It was really helpful...thanks..!!😇

[sambakorea]

Nice blog with very clear explanations for row and columnar db storage patterns. Could you also blog the in memory data storage in both the cases rather than the HDD. I am not interested in seeing the recent HANA buzz around the ‘in memory’ data storage and retrieval. One more thing, in this blog you have mentioned about the scenarios that dictates how the data will be stored like transactional or analytical..but in HANA, I think it stores everything in columnar way, so are there any drawbacks in that? Appreciate your innate insight in this.

[JxKILLAA]

Starting to get back into to database work, this was an excellent video!

[hariharamoorthythennetipan]

You have explained the concept at the disk level, awesome work.

[nitinkulkarni]

In your example, how is the following requirement met, all the response times between 10 am and 10:30am...I understand all the times are stored together in a series of one or more blocks and all the response times are stored together, the same way. So how are the time range matched with the response time range and returned back? In other words, since the time blocks are stored separately and response times are stored separately, who does the job of saying 10 and 10:30 am matches to 200, 300 and 350 ms of response times?

[haribaskarvengatasamy]

Fantastic. Very good explanation about Row Vs Column db's. Thanks Naren

[parveenpandit]

Wow.. so far this is the best explanation I have seen. Thank you so much.
I have one query, I am still not able to understand, how insertion happens in columnar database, if, there is no space left in a block and next block has data of another column. It will be great if you put some light on the this. Appreciate your help.