Video: AWS re:Invent 2019: Amazon DynamoDB deep dive: Advanced design patterns (DAT403-R1)

This technical session is for advanced users of Amazon DynamoDB. The patterns and data models discussed in this presentation summarize a collection of implementations and best practices used by large customers—including Amazon retail businesses—to deliver highly scalable solutions for a wide variety of business problems. We delve into strategies for global secondary index sharding and index overloading, scalable graph processing with materialized queries, relational modeling with composite keys, executing transactional workflows on DynamoDB, and more.

from comments:
00:00 Intro
01:00 Agenda list
02:17 Brief History of Data Processing
06:11 Why NoSQL?
07:11 Overview of Amazon DynamoDB
08:43 NoSQL Data Modeling
11:43 Partition Overloading
12:58 Secondary Indexes
14:43 Partition/shard keys in NoSQL 
15:14 Write sharding
17:33 Index overloading
19:11 Hot key issue (heat map)
19:48 Get the most out of DynamoDB throughput
20:52 Auto scaling
22:01 Performance at any scale
23:08 Global-scale events: Elastic is the new normal
24:05 Data modeling - It's all about relationships - including NoSQL databases
25:27 SQL vs NoSQL Design Patterns
26:19 Adhoc "joins" in SQL 
27:04 Modeled "joins" in NoSQL
31:05 Document vs wide column data modeling
33:31 Indexing efficiently in NoSQL
36:27 Complex queries
39:38 Composite keys
41:30 Modeling relational data
47:26 The Index schema (GSI1)
50:10 The Index schema (GSI2)
51:06 The Index schema (GSI3)
53:17 Design for common patterns
56:28 NoSQL Workbench for DynamoDB
57:32 Conclusions