SQL vs. NoSQL Explained (in 4 Minutes)

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ธ.ค. 2024

ความคิดเห็น • 61

  • @tryexponent
    @tryexponent  ปีที่แล้ว +7

    Make sure you're interview-ready with Exponent's system design interview prep course: bit.ly/3P2tvBy

  • @dreamsachiever212
    @dreamsachiever212 ปีที่แล้ว +340

    I don't know but as a beginner I have noticed many of these videos LACK the most important sauce : ACTUAL USE CASES! If you would have featured examples like let's say you're building an app that does this or that for you might want to use SQL for this part of the scope BECAUSE etc... and for that part of the scope NoSQL might be preferred because etc.... There you go, I have just shared a framework for your next video lol. Thank you anyway for the content it shows the genuine interest to educate but could be better especially if you want to educate beginners.

  • @AjaySharma-me1sy
    @AjaySharma-me1sy 11 หลายเดือนก่อน +156

    I'd take two examples to give some clarity on how you apply the principles explained in the video to decide on real-life situations:
    1. Designing a social media system like Facebook. Consistency is not critical. Posts can be created and it's totally fine if they take some time to propagate to multiple users. Considering the post data will be mostly unstructured data (text/images/video) and that you will need horizontal scalability (billions of posts), you should use a no-SQL database.
    2. Designing a payment system like VISA or Mastercard. Consistency is of utmost importance while committing the transaction. If there is issue in reflecting the transaction information, it can lead to unwanted consequences and angry customers. Considering that the data is structured and you don't need multiple users to see a single transaction, you should use a SQL like database.

  • @WaliSayed
    @WaliSayed ปีที่แล้ว +34

    The points mentioned are informative but add bit more clear explanation here about the horizontal and vertical scalabilities of NoSQL and SQL database systems:
    NoSQL databases are designed to scale out horizontally, meaning you can add more servers or nodes to the database cluster to handle increased data volume, traffic, or performance requirements. On the other hand, SQL databases often scale up vertically by adding more CPU, RAM, or storage capacity to a single server to handle increased demands.

    • @tryexponent
      @tryexponent  ปีที่แล้ว +2

      Hey WaliSayed! Thanks for adding on and sharing your knowledge!

  • @pranavjoshi7697
    @pranavjoshi7697 10 หลายเดือนก่อน +13

    @1:12 MongoDB is also ACID-compliant after version 4.

  • @petar55555
    @petar55555 ปีที่แล้ว +72

    SQL databases can also scale horizontally as well. People could get in trouble during the interview, please clarify this point

  • @bemalsdvanitha2090
    @bemalsdvanitha2090 3 หลายเดือนก่อน +3

    Its posible for shard sql databases, atleast postgree sql, there is extension call citus or postgree xl, you can easily shard. Also from postgree 10 it support declarative partitionings

  • @TecDM_EC89
    @TecDM_EC89 8 หลายเดือนก่อน +1

    I have never needed to implement a NoSQL database since I normally design my datasets correctly before development.
    When I tried to learn about NoSQL I found out that the lectures I was taking were leading me to "replicate" a relational structure in a NoSQL database.
    But, that's just my case. I can tell that everything will depend on the context.

  • @abdullokhayrulloev9211
    @abdullokhayrulloev9211 ปีที่แล้ว +11

    So much valuable information in only 4 minutes

  • @michaelbradley6712
    @michaelbradley6712 9 หลายเดือนก่อน

    I regard you as a very credible and lucid presenter.

  • @jasonl412
    @jasonl412 ปีที่แล้ว +8

    so, is it a standard answer the the question of "Could you tell the difference between SQL and NoSQL"?

    • @michaelai8274
      @michaelai8274 ปีที่แล้ว +1

      There's not exactly one to choose. They both have use cases in which they're best in that category/

  • @vinaygupta2369
    @vinaygupta2369 ปีที่แล้ว +7

    Very precise to the points of differneces between sql and nosql. thanks for the good content as always❤

  • @drndn
    @drndn 4 หลายเดือนก่อน

    Some of the qualities ascribed to SQL and NoSQL DBMSs are actually not intrinsic to them but orthogonal. ACID is one such example, that quality has nothing to do with whether the data is in tables or not. Both SQL and NoSQL DBMSs can be ACID, and both can be not ACID. For example, MySQL with the MyISAM table store is SQL but not ACID. For example, some key value stores etc are ACID. Also the ability to be distributed or not can be the case with both SQL and non. For example, Amazon Aurora is SQL that is distributed and horizontally scalable.

  • @normbograham
    @normbograham 5 หลายเดือนก่อน

    In my experience, and I did not make the decisions, but NoSql, is used for HUGE databases, with very few tables, and often the data is mostly static. Or at least, only a few records change in a day. And note, the Daytona database solution, had a weird ability to have an unlimited tuples in the same field, all on the same record, since, under it all, the database tuple, was text. So, anything you say about SQL databases, only applies to most of them and not all. The largest, and oldest database, is in Daytona and Cymbol.

  • @rebelwwg1wga431
    @rebelwwg1wga431 วันที่ผ่านมา

    what database will be best for service like zillow? Or maybe hybrid and use both... or citus + postgresql? :)

  • @rahulkumarmandal4450
    @rahulkumarmandal4450 6 หลายเดือนก่อน +1

    Nice explanation maam. Love from INDIA

  • @rolandocedeno6194
    @rolandocedeno6194 6 หลายเดือนก่อน

    NoSQL databases were not originally intended for scenarios requiring strict data integrity, as ensuring data consistency across distributed systems can be complex. The best use case for NoSQL is often for data caching mechanisms, where a disconnected application stores data in a NoSQL database and later synchronizes it with a relational database like SQL Server, Oracle, or MySQL. Using NoSQL as a caching mechanism also enhances performance, as you can keep a list of products in a NoSQL database and refresh it only when changes occur, thereby limiting the number of server data requests. This approach effectively functions as a caching mechanism. In conclusion, the use case where the technology shines is a hybrid application.

  • @Deepakkumar-dy1en
    @Deepakkumar-dy1en ปีที่แล้ว +10

    Its very informative video ❤.
    But it could be better to add few use cases to use sql vs nosql in system design context.
    I think:
    Use sql db if acid property, more relational data and less need of scalability is there else use nosql db.
    Correct me if i am wrong.

  • @saikiran-v4p
    @saikiran-v4p 2 หลายเดือนก่อน

    Amazing explanation! You made it so easy to understand!

  • @gusinthecloud
    @gusinthecloud 5 หลายเดือนก่อน +1

    great video. A few people have ability to teach!! You have it!!

  • @shagenhokie
    @shagenhokie 11 หลายเดือนก่อน +2

    Great overview. Thanks for sharing.

  • @zhonglin5985
    @zhonglin5985 9 หลายเดือนก่อน +1

    I don't think the video has explained why SQL databases usually can't horizontally scale for write-heavy systems. This statement can be easily challenged by the interviewers. Actually MySQL database has been proven be to able to horizontally scale for writes using sharding.

  • @adityyyaaa
    @adityyyaaa 6 หลายเดือนก่อน +1

    No-SQL database can easily solve the "consistency" problem by implementing structures or schemas internally

  • @CertifiedOtherBoy-cn7pg
    @CertifiedOtherBoy-cn7pg 2 หลายเดือนก่อน

    Very helpful, thank you!

  • @FabioGoncalves-ry7zq
    @FabioGoncalves-ry7zq 7 หลายเดือนก่อน

    Thank you for the amazing video. I now understand it better than I used to.

  • @VishalGupta-mn2mn
    @VishalGupta-mn2mn 8 หลายเดือนก่อน

    why dint you cover CID(consistency, Isolation and Durrability) for sql? why only atomicity you explained?

  • @swapnanjalisahoo97
    @swapnanjalisahoo97 9 หลายเดือนก่อน

    Very informative and quick 😊

  • @apnashankar
    @apnashankar ปีที่แล้ว +1

    Well Exaplanation ma'am❤! Now I've understood differences b/w SQL and NO-SQL. Thank you ❤

  • @klawtawar
    @klawtawar ปีที่แล้ว +2

    Also share some examples

  • @moisthero
    @moisthero 6 หลายเดือนก่อน

    do product managers get asked system design questions in interviews?

    • @tryexponent
      @tryexponent  6 หลายเดือนก่อน

      Generally not!

  • @mlavinb
    @mlavinb 9 หลายเดือนก่อน

    Amazing! thanks for sharing

  • @TTomni
    @TTomni 10 หลายเดือนก่อน

    This was great thanks :).

  • @benjaminphilips3737
    @benjaminphilips3737 6 หลายเดือนก่อน

    Academically, in theory, they both have their advantages and disadvantages. But in reality, SQL is baby for admin, NoSQL is for work and solution.

  • @jayakumar2927
    @jayakumar2927 9 หลายเดือนก่อน

    How to convert db NoSQL to SQL DB?

    • @tryexponent
      @tryexponent  9 หลายเดือนก่อน

      It's tricky because converting a NoSQL database to SQL requires defining a structured, relational schema that matches the unstructured data in NoSQL, which may vary significantly in format. I think you may want to evaluate whether SQL or NoSQL is more suitable for your application's needs and requirements before switching. Hope this helps!

  • @fatemehrouhani8642
    @fatemehrouhani8642 6 หลายเดือนก่อน

    Are APIs kind of noSQls?

    • @tryexponent
      @tryexponent  5 หลายเดือนก่อน

      Nope! APIs (Application Programming Interfaces) are sets of protocols, routines, and tools for building software applications, allowing different systems to communicate with each other. NoSQL, on the other hand, refers to non-relational database management systems that provide flexible schemas for storing and retrieving data.
      While APIs can be used to interact with various types of databases, including NoSQL databases, they are fundamentally different concepts serving different purposes in software development and data management.

  • @HemanthChandra
    @HemanthChandra ปีที่แล้ว +8

    this is good, but too many technical jargons... so, some details mentioned here are not clear

  • @shreyaschillal
    @shreyaschillal 7 หลายเดือนก่อน

    Well &Cool explanation

  • @bigbigdog
    @bigbigdog ปีที่แล้ว +2

    ❤thank you for this video

  • @native-nature-video
    @native-nature-video ปีที่แล้ว +1

    Thank you!

  • @kvelez
    @kvelez 5 หลายเดือนก่อน

    Thanks.

  • @mvlinux
    @mvlinux ปีที่แล้ว

    thank you 👍

  • @luizcarlossilva3641
    @luizcarlossilva3641 3 หลายเดือนก่อน

    I wish I could like it twice

  • @AYJ959
    @AYJ959 ปีที่แล้ว

    good 👍👍

  • @loveall4969
    @loveall4969 5 หลายเดือนก่อน +1

    👍

  • @ethereal_mantis5755
    @ethereal_mantis5755 ปีที่แล้ว +1

    I got from the video that there's very few weak points for NoSQL

  • @ashishgupta3247
    @ashishgupta3247 9 หลายเดือนก่อน

    Great

  • @jacobsimon4699
    @jacobsimon4699 ปีที่แล้ว

    Awesome!

  • @jeffpeng1118
    @jeffpeng1118 หลายเดือนก่อน

    wait you are a PM?

  • @mohammedrezk8072
    @mohammedrezk8072 8 หลายเดือนก่อน +7

    Guys , is this an actress as well ?

    • @tryexponent
      @tryexponent  8 หลายเดือนก่อน +5

      Our hosts are always real tech employees. In this case, a former ML engineer turned technical product manager.

  • @mrrishiraj88
    @mrrishiraj88 ปีที่แล้ว

    🙏👍

  • @chimuanyaibecheozor4832
    @chimuanyaibecheozor4832 5 หลายเดือนก่อน

    got lost when you started talking about nosql weaknesses. too many technical words makes it hard to follow

  • @AlanSilva-vl4xg
    @AlanSilva-vl4xg หลายเดือนก่อน

    Thanks!