Which Database Model to Choose?

Ғылым және технология

Get a Free System Design Roadmap PDF with 145 pages by subscribing to our monthly newsletter: 1levelup.dev/roadmap
✏️📘 Summary Notes: 1levelup.dev/blog/consistent-...
Key-Value 🐇
1:04 - Flexible for Unstructured Data
1:22 - Fast Lookup
1:53 - In-Memory Database
3:59 - Not for Complex Data Structures
4:21 - Not for ACID transactions
4:53 - Not for Historical Data
5:13 - Caching
Wide-column 🎡
6:16 - Column layout
6:57 - Primary Keys
7:52 - Denormalized
8:40 - Not for Random Filtering and Rich queries
9:51 - Not for Transaction Processing
10:39 - High scalability
11:52 - Optimized for Writes
Document 📑
12:32 - Denormalized
13:47 - Handle Unstructured Data
14:23 - Indexing and Rich Query
15:03 - Not for Complex joins and relationships
16:01 - Not for Referential integrity
16:20 - Most intuitive
Relational 👑
17:02 - Mature and formalized datamodel
17:47 - Normalization
18:44 - Difficult to scale horizontally
19:26 - ACID
Graph 🍇
20:51 - No need to compute the relationships at query time
21:49 - Handles Complex Data Structures
22:20 - Difficult to scale
22:51 - Not for Write-heavy workloads
23:47 - Multi-hop relationships

Пікірлер: 27

  • @mousely76
    @mousely762 ай бұрын

    17:42 i love that sql injection in the 3rd id

  • @rhodabaruch4
    @rhodabaruch47 ай бұрын

    That was amazing. Thank for you helping me in my prep. This should have way more views. That was the perfect level of detail and the diagrams and animations help solidify the detail you provide. Bravo!

  • @ozzyfromspace
    @ozzyfromspace11 ай бұрын

    You're amazing bro, thank you so much for making these videos! I'm preparing for a senior engineering interview and haven't been feeling very confident about it. Your videos are really helping me build a framework for understanding things at a more high level. I appreciate your effort. Thanks again!

  • @VinChit
    @VinChit5 ай бұрын

    Thanks for creating such intuitive tutorials on different databases. Kudos to your efforts.

  • @paramjitsaha330
    @paramjitsaha3304 ай бұрын

    Choosing the Right Database: Understanding Different Data Models and their Pros and Cons [00:02]Choosing the right database model is crucial for app performance and scalability. [02:35] Key-value databases are well-suited for in-memory storage, providing faster responses [05:17] Key value stores are optimized for high performance and low latency applications. [07:56] White columns databases store data in a normalized form [10:22] Cassandra databases offer horizontal scalability and fast writes. [12:48] Document databases, like MongoDB, provide a more convenient way to handle data. [15:24] Document databases offer scalability and easier integration with object-oriented programming, but lack features and integrity [17:53] Normalization is the process of organizing data into separate tables to improve data integrity. [20:07] Different database models have different challenges in complying with all acid properties. [22:16] Graph databases are difficult to model and distribute across multiple nodes.

  • @gigaheheboi
    @gigaheheboi3 ай бұрын

    Very Informative.. This Video was Easy to understand!

  • @emilyedgars7072
    @emilyedgars7072Ай бұрын

    Best video!! Explained everything I learned in 4 months in 24 mins

  • @habibyama
    @habibyama3 ай бұрын

    Thank you for such intuitive video.

  • @Kimanxo
    @Kimanxo Жыл бұрын

    we demand to provide a similar video about backend frameworks and languages such as Django Next Express Rails Laravel ....

  • @jitx2797
    @jitx2797 Жыл бұрын

    Wow this is quality content. Subscribed

  • @firefly3519
    @firefly35193 ай бұрын

    Very helpful - thank you!

  • @user-lp3wb5su7c
    @user-lp3wb5su7c2 ай бұрын

    this is really useful video, thank you

  • @MAK_007
    @MAK_0078 ай бұрын

    You are awesome. Such a great video ❤

  • @Delicatamente
    @Delicatamente2 ай бұрын

    Best ever. This is so excellently structured and summarize. thank you agaiN!

  • @user-oz6bg3eb6n
    @user-oz6bg3eb6n11 ай бұрын

    your videos are just soooo nice. cngrts

  • @saswatsenapati7870
    @saswatsenapati78703 ай бұрын

    6:17 - wide column database

  • @ShantanuSingh-wc4ou
    @ShantanuSingh-wc4ou3 ай бұрын

    I have no words. To be honest, I am feeling bad for watching this in free of cost as a student. Thank you for your hard work, I will share this video as much as possible.

  • @paakwasioppong9371
    @paakwasioppong937110 ай бұрын

    Awesome video.

  • @rmscoal_dev
    @rmscoal_dev4 ай бұрын

    Hello, I love this video. Perhaps a little feedback. On every of my device, your video audio is so soft. I think it would be nice, if the audio is a bit larger so that I can hear better. Thank you very much.

  • @karpuzye
    @karpuzye5 ай бұрын

    the content is good but following the topics is not easy because the selection of titles appearing for 1 second and then we're not seeing the title anymore while explainging it.

  • @maxonaga3962
    @maxonaga3962 Жыл бұрын

    YOU ARE MY HERO

  • @meditationdanny701

    @meditationdanny701

    Жыл бұрын

    Good To see you back bro t

  • @ravindranaths513
    @ravindranaths513Ай бұрын

    Could you please make a video on Wide column vs column family vs columnar vs column oriented DBs

  • @datapragmatic
    @datapragmatic4 ай бұрын

    The links in the description don't work

  • @antisteo
    @antisteoАй бұрын

    you forgot to mention columnar databases for high performance analytics

  • @lokeshmehta9591
    @lokeshmehta959110 ай бұрын

    bro please increase sound level.

  • @Jody-nf2bz
    @Jody-nf2bz9 ай бұрын

    He keeps stopping every one or two words, so in order to keep up I had to mute the video and read the closed captions instead.

Келесі