How row oriented and column oriented db works?

Поделиться
HTML-код
  • Опубликовано: 9 янв 2025

Комментарии • 125

  • @chakriadm1
    @chakriadm1 4 года назад +17

    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.

  • @rhugvedchaudhari4584
    @rhugvedchaudhari4584 8 месяцев назад

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

  • @padam2072
    @padam2072 19 часов назад

    So beautifuly explained

  • @daleffi
    @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.

  • @bactran7799
    @bactran7799 3 года назад

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

  • @SAW8149
    @SAW8149 Год назад

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

  • @JoscelinTrouwborst
    @JoscelinTrouwborst 2 года назад

    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 :-) .

  • @mindcontrolkmc.3286
    @mindcontrolkmc.3286 3 года назад

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

  • @haribaskarvengatasamy4531
    @haribaskarvengatasamy4531 4 года назад

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

  • @shanshanxu9978
    @shanshanxu9978 3 года назад

    very good, the best explanation I have seen so far.

  • @sanjayg2686
    @sanjayg2686 4 года назад

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

  • @hariharamoorthythennetipan2190
    @hariharamoorthythennetipan2190 3 года назад

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

  • @sureshiva4605
    @sureshiva4605 Год назад

    Cool explanation...Need more of your videos....Gonna check your whole playlist....

  • @ShabnamKhan-cj4zc
    @ShabnamKhan-cj4zc 4 года назад

    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..

  • @shankarsr1
    @shankarsr1 4 года назад

    wow very good explanation

  • @hemanthkch
    @hemanthkch 2 года назад

    Good one Naren, thank you for posting this.

  • @ameyapatil1139
    @ameyapatil1139 4 года назад +1

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

  • @rajpal7406
    @rajpal7406 3 года назад

    Nicely explained.. Thank you Narendra!

  • @ayush_shaz
    @ayush_shaz 3 года назад

    Amazing video, I loved it.

  • @dgg9270
    @dgg9270 5 месяцев назад

    Quite good explanation.

  • @joshreji7510
    @joshreji7510 2 года назад

    A brilliantly explained video. Thank you!

  • @mainakchatterjee1720
    @mainakchatterjee1720 2 года назад

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

  • @senthilvs1723
    @senthilvs1723 3 года назад

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

  • @csangora
    @csangora 2 года назад

    Superb explanation Narendra. Really understand the concepts

  • @deepjyotimitra1340
    @deepjyotimitra1340 3 года назад

    Detailed explanation. Thank you so much. All my doubts got cleared.

  • @nazeers5684
    @nazeers5684 6 месяцев назад

    good video

  • @JxKILLAA
    @JxKILLAA 3 года назад +1

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

  • @RS-vu5um
    @RS-vu5um 2 года назад

    Excellent Explanation.

  • @Manishsharma-tj4nn
    @Manishsharma-tj4nn 4 года назад +2

    You are back, thanks

  • @uboopathy
    @uboopathy 3 года назад

    Very good explanation

  • @nishanktripathi6589
    @nishanktripathi6589 2 года назад

    It was crisp and clear. Thank you so much for this awesome content 🥰

  • @hgaliza
    @hgaliza 3 года назад

    Thanks for the video! Very clear and concise explanation. 👍🏻

  • @srinivaskjakkula3868
    @srinivaskjakkula3868 4 года назад

    Great Video thank you for sharing your knowledge.

  • @soumyajitsinharoy
    @soumyajitsinharoy 4 года назад

    Very nice explanation.

  • @kyliexoo
    @kyliexoo 6 месяцев назад

    you're a great teacher!!

  • @vikramragunathan6392
    @vikramragunathan6392 Год назад

    I don't think anyone can explain better. Wow.

  • @vikashmandir
    @vikashmandir 4 года назад +6

    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.

  • @akshay_g
    @akshay_g 4 года назад

    Good explaination

  • @vrushali6044
    @vrushali6044 4 года назад

    Awesome explanation ..Keep it up

  • @awake8138
    @awake8138 3 года назад

    Really awesome.well explained 👏👏👏

  • @sj0387
    @sj0387 4 года назад

    Brilliant Explanation. Thanks Bro.

  • @sanjeevbc9784
    @sanjeevbc9784 3 года назад

    nicely explained

  • @jksharma7
    @jksharma7 4 года назад

    very clear understanding sir.

  • @hariomsharma5468
    @hariomsharma5468 3 года назад

    loved the way you explained

  • @edgarcheverier
    @edgarcheverier 4 года назад +7

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

    • @meghnath1993
      @meghnath1993 4 года назад +2

      +1 , would like to understand how you write queries for (row vs column vs document)

    • @nalamda3682
      @nalamda3682 2 года назад

      + 1

  • @rocktoyo69
    @rocktoyo69 4 года назад

    Great video, it helped me to understand my course from my university and helped me for my final exam, thank you

  • @dconenana2986
    @dconenana2986 2 года назад

    This is wonderful and thanks very much. This is my first time ever commenting on a video lol .

  • @HaiNguyen-yr7md
    @HaiNguyen-yr7md Год назад

    it's so clear. thank you so much.

  • @dheemanthmallikarjun514
    @dheemanthmallikarjun514 3 года назад

    Great explanation 👏 keep it coming

  • @tungtranvan1286
    @tungtranvan1286 3 года назад

    thank bro for sharing

  • @richardglazer4686
    @richardglazer4686 3 года назад

    Great explanation, thank you!

  • @bratwurstmitbiryani
    @bratwurstmitbiryani 4 года назад

    Dude you are great. Very nicely explained!

  • @mateuszkowaleczko6446
    @mateuszkowaleczko6446 4 года назад

    Thanks man. You explain it really well

  • @sambakorea
    @sambakorea 8 месяцев назад

    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.

  • @amanpreetkaurkohli7288
    @amanpreetkaurkohli7288 3 года назад

    really very good explanation. Would like to see video on partitioning in future.

  • @madaxe8894
    @madaxe8894 4 года назад

    Good.

  • @stnlylee
    @stnlylee 4 года назад

    nice video thanks

  • @parveenpandit168
    @parveenpandit168 9 месяцев назад

    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.

  • @arjunsharmaconnect
    @arjunsharmaconnect 2 года назад

    great

  • @ragdoll2324
    @ragdoll2324 4 года назад

    Great video. Thanks for making it. It would be great if you can create more videos on the internals of databases, focusing each vdo on a different kind of database.
    Thanks!

  • @PiyushSingh-vx7bx
    @PiyushSingh-vx7bx 4 года назад

    Awesome video ❤️

  • @sairajanagandula6478
    @sairajanagandula6478 4 года назад

    Thank you very much bro. You have explained it very clearly and at a beginner level. It helped me in while learning SAP HANA as well.

  • @oldguywholifts
    @oldguywholifts 4 года назад

    Sincerely... good effort!!! 👍

  • @stephyjacob1256
    @stephyjacob1256 4 года назад +4

    Take care man. Situation in Germany also not good due Coronavirus. Stay safe.

  • @srinathvangari8526
    @srinathvangari8526 4 года назад

    Well explained. Thank you

  • @akshatjain1559
    @akshatjain1559 2 года назад

    You are a genius dude! These little things get people 300-400K jobs in FAANGMULA!

  • @nalamatigeetha2459
    @nalamatigeetha2459 4 года назад

    Got to knw much frm ur session. Thanks alot

  • @nitinkulkarni7942
    @nitinkulkarni7942 4 года назад +8

    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?

    • @obinnaubah9045
      @obinnaubah9045 4 года назад

      I was wondering the same thing.

    • @quizforces
      @quizforces 4 года назад

      Actually along with the data you will always associate the ID, that way first you query all the time and know the ID's that you need to query after that you can query another column like response times or error count. Thing to remember (it stores ID as well along with the data).

    • @nitinkulkarni7942
      @nitinkulkarni7942 4 года назад

      @@quizforces i dont thin that how it will work. What i found out later is that the first time in my query response will match the 1st response and so on......

    • @RajaKumar-sj3et
      @RajaKumar-sj3et 3 года назад

      Almost all of the row vs column store explanations on the internet do not explain this point well, but they think they are doing a wonderful job of explaining the concepts to the audience but just fail to explain this simple point. LOL! I think what Ritesh Malav explained below makes sense that the ID is also stored together in the column store so that the individual data values are married together to make sense as meaningful piece of record instead of isolation.

    • @skc2020
      @skc2020 3 года назад

      @@RajaKumar-sj3et Completely agree with you & Ritesh. Logically each column should have ID attached to it. But that crops up other questions.
      1. How come column encoding works if ID is attached ?
      2. How RLE encoding distinguishes columns of different records ?
      3. In most of the columnar DB's (like Redshift, Vertica), we don't mention primary keys - Then how does the columns of a single row gets tied up ?
      I was waiting for these explanations in this (nth) video but no luck !!

  • @GAURAVGUPTA-zu2bu
    @GAURAVGUPTA-zu2bu 4 года назад

    It will be nice to see a video on write ahead logs

  • @ansh7627
    @ansh7627 4 года назад

    I am your fan

  • @aravindmohandas
    @aravindmohandas 4 года назад +7

    Thats a great video. One question- How does indexing work in column oriented ?

    • @sj0387
      @sj0387 4 года назад +1

      An index is nothing but a column or a group of columns in a database. In a Column oriented database, you don't need an index. That is the beauty.

  • @YashChoudhari73
    @YashChoudhari73 4 года назад

    amazing explanation! :)

  • @saiprasad84
    @saiprasad84 Год назад

    Great video. I have 2 questions. 1) What will happen if we usually fetch 2 columns at the same time? Like the time and number of requests in your example? 2) Which database has better performance with DML operations like update and delete? You talked about inserts - can you please talk about updates/deletes also please?

  • @ankushgats
    @ankushgats 4 года назад

    Hey Narendra, this is very helpful content and your voice is very relaxing. Just want to add a suggestion, I think we should have included: how data from one column is matched(linked) to data from another column, like how does db identifies what are the "number-of-requests" between time windows of 10.01 to 10.11.

    • @MC-wp2vz
      @MC-wp2vz 2 года назад

      the record id is always stored, so when you do the time query, you are getting from the time column all the record ids that matches the time requirement. Then it goes to the metric column you need. It reads all of them which might be partitioned, and then fetch data that has the same record ids

  • @akshatjain1559
    @akshatjain1559 2 года назад

    How do you large and hot partitions in Columnar DB, since one column could contain data that is huge (Large strings) or hot (More frequently accessed than others)

  • @vivekmit
    @vivekmit 4 года назад +1

    Hi Narendra; You explained extremely well how we can choose the best-fit NoSql database based on our requirements. Do we have any other factor to decide best-fit NoSql database like, in case our application is write oriented or read oriented..I know the CAP theorem is another factor to decide best-fit NoSql db but wish to know other possible factors.

  • @sahilbajaj2190
    @sahilbajaj2190 Год назад

    Question: Incase of column oriented writes, what if current block gets fulled & next consecutive block is also fulled. So, does it shifts all the blocks or how does it actually work & maintain all the blocks at different places for a particular column ?

  • @atulkumar-bb7vi
    @atulkumar-bb7vi Год назад

    Thanks bro for very amazing explanation. but couple of questions. 1. How would this work in case of SSD devices? & When columns data updated, how it refer the updated values somewhere else for same column coz, it is very common to update the column data as well in analytics applications as new data keeps coming??

  • @kranthikumarjorrigala
    @kranthikumarjorrigala 4 года назад

    Very clearly explained. Thanks a lot. Can you make videos on Amazon redshift.

  • @RandomShowerThoughts
    @RandomShowerThoughts 2 года назад

    does does a columnar database handle multiple where requests? Does it keep track of the subset at each fliter?

  • @gauravmittal451
    @gauravmittal451 3 года назад

    I just laughed at the scalar academy ad which came during the video.

  • @anandperi7060
    @anandperi7060 Год назад

    So basically how are these Column data across the blocks linked... for example the traffic and errors need to be plotted with the time. So there is a relationship that needs to be maintained with some kind of a key right? How is that being done?

  • @meghasharma3092
    @meghasharma3092 4 года назад

    Now i understood why my architect always asks not to do any analytics query on transactional DB :)

  • @AJEETVATE
    @AJEETVATE 2 года назад

    perfect ....

  • @AkashJadhavIT
    @AkashJadhavIT 4 года назад

    Thank you for all these amazing videos on systems design. We have learned great concepts from you sir.
    One request from my side. Would it possible for you to make a series on "object oriented design interview". Any resources you would recommend for the same?

    • @TechDummiesNarendraL
      @TechDummiesNarendraL  4 года назад +1

      It doesn't have to be contiguous always, blocks are distributed and memory allocation starts from different blocks and they are tracked by FS

  • @aneksingh4496
    @aneksingh4496 4 года назад

    very nice explanation . Thanks , I have been following your videos , Great effort . Please also suggest how do u prepare for these topics ,I mean what resources do you use .. that would be also great help !!! :-)

  • @arshiabegum2706
    @arshiabegum2706 Год назад

    Thanku 😊

  • @AdityaJha94
    @AdityaJha94 4 года назад +1

    When one of the disk of shards in a database (either row oriented or column oriented) is full, what are the strategies to mitigate the situation?

  • @milindjadhav7420
    @milindjadhav7420 4 года назад

    I was looking for row vs column db and got very useful info.thanks.Could you please explain in terms of MPP and Cloud DWH if possible..😊

  • @stoneshou
    @stoneshou 4 года назад +1

    Is it fair to say column oriented for OLAP vs row oriented for OLTP

  • @sanketh768
    @sanketh768 10 месяцев назад

    so it means writes are slower in columnar DB's compared to row oriented DB'S ?

  • @freeopensource
    @freeopensource Год назад

    Thanks a lot !!

  • @anandperi7060
    @anandperi7060 Год назад

    I'm under the impression the Data Load times for a Data Warehouse is critical ... if a table has 50 columns by your definition there is 50X extra IO... is this really the case and the load times are that much slower?

  • @nitinwadhawan6460
    @nitinwadhawan6460 4 года назад

    Hi, Great videos! Please also let us know the source of your knowledge? any books you recommend if someone wants to deep dive into the concepts.

  • @shewafree
    @shewafree 3 года назад

    Thank you!

  • @subee128
    @subee128 5 месяцев назад

    Thanks

  • @prabhakaradhulipalla1162
    @prabhakaradhulipalla1162 4 года назад

    how does it store null values for any given row in CF db?

  • @improbabilityphysics8404
    @improbabilityphysics8404 4 года назад

    I guess when storing column based data, the ID column should be saved as well?

  • @PallaviJadon-y3c
    @PallaviJadon-y3c Год назад

    Do you have notes for this video?

  • @gauravkhurana420
    @gauravkhurana420 4 года назад

    every database have the ability to store row wise and column wise both?OR Different database works differently?

    • @TechDummiesNarendraL
      @TechDummiesNarendraL  4 года назад

      It's different use cases and different databases.
      Row oriented: MySQL postgres
      Col oriented: Cassandra, mriadb, sap Hana, hbase

    • @gauravkhurana420
      @gauravkhurana420 4 года назад

      @@TechDummiesNarendraL Thanks Man,Appreciate your Hardwork...