Types of Databases: Relational vs. Columnar vs. Document vs. Graph vs. Vector vs. Key-value & more

Поділитися
Вставка
  • Опубліковано 21 лис 2024

КОМЕНТАРІ • 94

  • @AntonPutra
    @AntonPutra  11 місяців тому +9

    🔴 - To support my channel, I’d like to offer Mentorship/On-the-Job Support/Consulting - me@antonputra.com

  • @ssrakeshsharma
    @ssrakeshsharma 9 місяців тому +17

    One of the best video to understand Types of Databases. Excellent work 👍

  • @ErikWillekens
    @ErikWillekens 8 місяців тому +8

    Your clarity is exceptional

  • @aDarkDay
    @aDarkDay 3 місяці тому +8

    Its a very good summary of all features, adv and disadv of databases, and their use cases too. A good one mate!

  • @crazychase443
    @crazychase443 9 місяців тому +6

    Absolute perfect level of detail that I was looking for. Love this video, thank you so much!

  • @notyrants507
    @notyrants507 6 місяців тому +5

    Super good for understanding the differnces, crystal-clear, thank you!

  • @narval7495
    @narval7495 5 місяців тому +1

    7 minutes of video do way more than a whole month of classes. What an awesome video

  • @PatrickGalbraith
    @PatrickGalbraith 9 місяців тому +3

    what did you use for slides/presentation? This is top notch.

  • @ghilmanfatih9751
    @ghilmanfatih9751 4 місяці тому +3

    crystal clear illustration, structured story telling, subscribed!

  • @PatrickGalbraith
    @PatrickGalbraith 9 місяців тому

    I'm doing a talk tomorrow and this was helpful in reminding me of good info to mention.

  • @StudyBuddy-jj5pb
    @StudyBuddy-jj5pb Місяць тому +1

    Damn, good job and thank you. (it would be great if you had a visual remainder to distingush sections but everything else is just perfect.)

  • @jenny8396
    @jenny8396 7 місяців тому +1

    Super nice summary for beginners. Im just learning about noSQL and this is a great start to the idea of it!

  • @tamaramal1
    @tamaramal1 7 місяців тому +1

    Its a GREAT video that explains all clearly, simple and with examples!

  • @Featherlicht
    @Featherlicht 3 місяці тому +1

    This is so a well thought out lesson. Thank you so much.

  • @MoSALah-xe1hz
    @MoSALah-xe1hz 5 місяців тому +1

    The most important video i have seen about this topic 🎉❤

  • @ItsMeIshir
    @ItsMeIshir 5 місяців тому +1

    This is very good video. Thanks for creating this content for us.

  • @BigBobEdyS
    @BigBobEdyS 6 місяців тому +2

    Amazing video on the topic! Very clear and concise

  • @PandalPan
    @PandalPan 7 місяців тому +1

    Thank you for your detailed explanation. Hats off!

  • @ARATHI2000
    @ARATHI2000 10 місяців тому +1

    Very nice summary. Thanks, Anton!

  • @GabrielPozo
    @GabrielPozo 10 місяців тому +3

    Thank you for sharing this great video!

  • @shashankcg5029
    @shashankcg5029 25 днів тому +1

    fantastic perspectives

  • @pradeekmohandas4234
    @pradeekmohandas4234 Місяць тому

    such clarity ❤

  • @AndreyIgnatchenko
    @AndreyIgnatchenko 10 місяців тому +1

    Thank you Anton for the great video!
    Is it worth to mention Redis and Memcached as examples of key value databases?

    • @AntonPutra
      @AntonPutra  10 місяців тому

      Redis tries to be everything nowadays, lol

  • @AbdiqaniM015
    @AbdiqaniM015 5 місяців тому +1

    Thanks for sharing, was very helpful 💖💖

  • @abdessamadelhardouz717
    @abdessamadelhardouz717 5 місяців тому +2

    Well done !! Very clear

  • @AmiraMohamed-jf5tl
    @AmiraMohamed-jf5tl Місяць тому

    Really great video 👏

  • @auguriocarmesi1507
    @auguriocarmesi1507 3 місяці тому +1

    You are amazing man thank you very much, with this I did my homework hahahaj

  • @kapilchoudhary2922
    @kapilchoudhary2922 Місяць тому +1

    Great content, Thanks!

  • @5alpha23
    @5alpha23 4 місяці тому +1

    What I'm missing are query runtimes for all but the first two types. For example, what happens to a query if a graph database has 10,000 nodes and 500,000 edges?

  • @laughingvampire7555
    @laughingvampire7555 3 місяці тому

    regular Relational DB: array of structs
    columnar DB: struct of arrays

  • @cascossi809
    @cascossi809 8 місяців тому +1

    HI Anton, congratulations for the video. I am also interested in the software used for the animated infographics. Thanks in advance.

    • @AntonPutra
      @AntonPutra  8 місяців тому +1

      thanks, adobe suite

  • @airtime2pesa
    @airtime2pesa 22 дні тому +1

    Very Very Well done Thanks

  • @subee128
    @subee128 3 місяці тому +2

    Thank you very much

  • @DonLeonM
    @DonLeonM 6 місяців тому +1

    THANK YOU for a great video!

  • @Xaoticex
    @Xaoticex 10 місяців тому +9

    Great comparison of relational vs columnar and I really like document and key-value store parts too, the only thing is 18min is a bit long, otherwise perfect!

  • @lucasvazquez-sk1lv
    @lucasvazquez-sk1lv 10 місяців тому +1

    Thank you for this amazing content.

  • @joshbleijenberg4000
    @joshbleijenberg4000 5 місяців тому +1

    Great video, for a tinder like application. What database would you choose and why?

    • @AntonPutra
      @AntonPutra  5 місяців тому

      If it's a personal project, start simple and use MongoDB or Postgres! You can scale and redesign later.

  • @abhinavsingh7919
    @abhinavsingh7919 4 місяці тому +2

    What about *Redis* , does it fall under Time-series database or is it something else entirely?

    • @AntonPutra
      @AntonPutra  4 місяці тому

      it is primarily a key-value store

  • @shoaib88923
    @shoaib88923 9 місяців тому

    impressive work

  • @hitmanrj
    @hitmanrj 6 місяців тому +1

    What a great video!

  • @i8you2b
    @i8you2b Місяць тому

    Thanks!

  • @leomarker7199
    @leomarker7199 11 місяців тому +4

    love it 👌

  • @haonanqiu4251
    @haonanqiu4251 5 місяців тому +1

    high quality

  • @olivierbourdon2397
    @olivierbourdon2397 7 місяців тому

    Great video indeed. May be you could also add a section with multi-purpose database(s) like SurrealDB ;-)

  • @williamvalentinmunozlopez9858
    @williamvalentinmunozlopez9858 2 місяці тому

    This is gold

  • @MrRin_
    @MrRin_ 10 місяців тому

    Hi, Anton! Can you please share some resources on how to scale ML workloads in GKE? Some tricks that you may know, time sharing vs multi-instance GPU?
    In other words, how do we get most out of the compute without running into OOM issues
    Thank you!

    • @AntonPutra
      @AntonPutra  10 місяців тому

      It really depends on the framework you're using to run ML, such as Spark, Airflow, etc. I don't really have general advice on this topic.

  • @kurtlee138
    @kurtlee138 3 місяці тому

    Amazing

  • @premraj.m
    @premraj.m 4 місяці тому

    nice video, but 6:25 Cassandra is not columnar db isn't it? it a wide-column store.

    • @AntonPutra
      @AntonPutra  4 місяці тому +1

      well it's a mix i know

    • @premraj.m
      @premraj.m 4 місяці тому

      @@AntonPutra your videos awesome bro. I love your videos a lot. Thank you very much.

    • @AntonPutra
      @AntonPutra  4 місяці тому

      @@premraj.m thanks :)

  • @maksimmuruev423
    @maksimmuruev423 4 місяці тому

    Well you put a lot of time for SQL and MongoDb.. and practically brefly mention others.. Interesting will be open topics for Graph and vector and so on.

    • @AntonPutra
      @AntonPutra  4 місяці тому

      thanks for the feedback, i have one for graph db - ua-cam.com/video/-6Xc2_IOh-0/v-deo.html

  • @francishubertovasquez2139
    @francishubertovasquez2139 2 місяці тому

    It's about fact finding per person the validity to establish. correlation in universities of universes? How about the universe continually moves and dark matter escapes at the edge a data and informational fact in science and matters though in strands waves forms or could carry some mass or form mass and enlarge as it attracts, the orientations for dimension have layers and it waves or electromagnetically affected by outside science influence and could change overtime, sensor for changes needed, then person identity validation if not metamorphosized yet for observational fix per universe of identity signatures but as you've said what if awol or dropped out then reconsidered in other connected schools for example in different timeframe was the previous info still valid since discontinued, if pieces by jigzsaw with comparison was comparison fixed connected or not for every hour there's some change, skin cells, protein factor increase or not, lipid content changes, mindset rewire if rewire, bone cells technologically change for example, etc can minimal difference be considered or be open minded that universally speaking variables of species, familiarity? More studies needed

  • @kik513
    @kik513 7 місяців тому

    The column oriented explanation is wrong. Cassandra does not store dsta in colums. It still stores in rows, but how does it read data row by row, but each row has key value pairs whcih are colums. Where it van jump to a required columns.
    Cassandra is column family DB, not a column oriented DB.

    • @AntonPutra
      @AntonPutra  7 місяців тому

      I'll soon make a video specifically about columnar databases, including a hands-on tutorial.

  • @ravindranaths513
    @ravindranaths513 7 місяців тому

    Could you please make a video on Wide column vs column family vs columnar vs column oriented DBs. Please include some examples/usecases/scenarios also

    • @AntonPutra
      @AntonPutra  7 місяців тому

      can you give me some examples of databases?

  • @cdgtopnp
    @cdgtopnp 15 годин тому

    You copied the entire columnar database chapter from this video watch?v=8KGVFB3kVHQ&ab_channel=ness-intricity101

  • @Zeding_Stuff
    @Zeding_Stuff Місяць тому

    крутяк но сделай пж по русски а то не все понял