An AWS re:Invent 2019 session for advanced DynamoDB users on design patterns used by large customers, including Amazon retail. It covers GSI sharding, index overloading, graph processing, composite keys and transactional workflows.
Why Hacker News points people here: Recommended as Rick Houlihan's definitive talk on modeling relational-style data in DynamoDB.
Shows how good table design gives relational-style modeling on NoSQL.
Full comment
I wrote a piece that touches a bit on the why: link But in a nutshell: availability and scalability. Yes you can achieve this with relational DBs, but it will be quite complex, while No-SQL gives it by design. All while ensuring all the goodness of relational data modeling, consistency and queries. The only requirement is a good table design: this video
RecommendsandriosrSep 2020
“This is a great presentation about this”
Explains modeling relations in DynamoDB tables.
Full comment
Interesting question. No-SQL doesn't mean non-relational. DynamoDB is a relational database. It's up to you on how you design the table to accommodate your relations. This is a great presentation about this: this video
Cites itabd12Apr 2020
“Rick has had the most-watched re:Invent talk the last three years.”
Rick Houlihan's DynamoDB design patterns talk, the most-watched re:Invent talk.
Full comment
Rick has had the most-watched re:Invent talk the last three years. Here are the links for each: - 2019: this video - 2018: link - 2017: link Additional DynamoDB links here: link
Cites itbelterJan 2022
“You never heard of Rick Houlihan? He is the 90% of DynamoDB Evangelism...”
One of several Rick Houlihan DynamoDB design talks.
Full comment
You never heard of Rick Houlihan? He is the 90% of DynamoDB Evangelism... At the same time you are able to this internal lookups? Do you work with DynamoDB? AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401) link AWS re:Invent 2019: [REPEAT 1] Amazon DynamoDB deep dive: Advanced design patterns (DAT403-R1) this video AWS re:Invent 2020: Amazon DynamoDB advanced design patterns – Part 1 link AWS re:Invent 2020: Amazon DynamoDB advanced design patterns – Part 2 link AWS re:Invent 2021 - DynamoDB deep dive: Advanced design patterns link Amazon DynamoDB | Office Hours with Rick Houlihan: Breaking down the design process for NoSQL applications link