AWS DynamoDB Schema Design | How to choose the right key

Be A Better Dev October 6, 2019
Video Thumbnail
Be A Better Dev Logo

Be A Better Dev

@beabetterdev

About

This channel is devoted to helping you become a better developer by learning about AWS, cloud computing, and system design concepts. My name is Daniel Galati and I have nearly a decade of experience working in tech. I am currently working as a senior software engineer at Amazon. On my channel, you'll find videos on software development topics such as databases, design principles, and cloud computing. I put an emphasis on making complicated topics easier to understand. From time to time, I'll also share developer career advice gathered through real-life industry experience for those of you looking to break into, or are already established in the software industry. If you want to join me in becoming a better developer, hit that subscribe button now. Patreon Link: https://www.patreon.com/beabetterdev --------------------- Videos created are based on my own opinion and not related to any company, organization or person.

Video Description

AWS DynamoDB Tutorial. DynamoDB is a powerful fully managed NoSQL database. Part of the complexity in using the service is related to choosing a partition key that not only serves your access patterns, but prevents you from having scaling related headaches in the future. In this video, I talk about the factors you should consider when choosing a partition key. I start out by briefly talking about why choosing the right key is important, followed by defining partition and sort keys. Afterwards we go into key partitioning behavior and a feature called adaptive capacity. Finally, I conclude with some general guidance on when you should choose one key structure over another. Looking to get hands on experience building on AWS with a REAL project? Check out my course - The AWS Learning Accelerator! https://courses.beabetterdev.com/courses/aws-learning-accelerator 00:25 Why picking the right key is important 01:10 Primary Key, Partition Key, Sort Key 09:24 When to use what key 🎉SUPPORT BE A BETTER DEV🎉 Become a Patron: https://www.patreon.com/beabetterdev 📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚 Clean Code - https://amzn.to/37T7xdP Clean Architecture - https://amzn.to/3sCEGCe Head First Design Patterns - https://amzn.to/37WXAMy Domain Driver Design - https://amzn.to/3aWSW2W Code Complete - https://amzn.to/3ksQDrB The Pragmatic Programmer - https://amzn.to/3uH4kaQ Algorithms - https://amzn.to/3syvyP5 Working Effectively with Legacy Code - https://amzn.to/3kvMza7 Refactoring - https://amzn.to/3r6FQ8U 🎙 MY RECORDING EQUIPMENT 🎙 Shure SM58 Microphone - https://amzn.to/3r5Hrf9 Behringer UM2 Audio Interface - https://amzn.to/2MuEllM XLR Cable - https://amzn.to/3uGyZFx Acoustic Sound Absorbing Foam Panels - https://amzn.to/3ktIrY6 Desk Microphone Mount - https://amzn.to/3qXMVIO Logitech C920s Webcam - https://amzn.to/303zGu9 Fujilm XS10 Camera - https://amzn.to/3uGa30E Fujifilm XF 35mm F2 Lens - https://amzn.to/3rentPe Neewer 2 Piece Studio Lights - https://amzn.to/3uyoa8p 💻 MY DESKTOP EQUIPMENT 💻 Dell 34 inch Ultrawide Monitor - https://amzn.to/2NJwph6 Autonomous ErgoChair 2 - https://bit.ly/2YzomEm Autonomous SmartDesk 2 Standing Desk - https://bit.ly/2YzomEm MX Master 3 Productivity Mouse - https://amzn.to/3aYwKVZ Das Keyboard Prime 13 MX Brown Mechanical- https://amzn.to/3uH6VBF Veikk A15 Drawing Tablet - https://amzn.to/3uBRWsN 📚 References: Getting started with AWS: https://youtu.be/lTyqzyk86f8 DynamoDB Global Secondary Indexes - https://youtu.be/ihMOlb8EZKE DynamoDB Local Secondary Indexes - https://youtu.be/Y8gMoZOMYyg DynamoDB Accelerator (DAX) - https://youtu.be/9deAV0yAkH8 SQL vs NoSQL explained - https://youtu.be/ruz-vK8IesE Choosing the right key - https://aws.amazon.com/blogs/database/choosing-the-right-dynamodb-partition-key/ Understanding Adaptive Capacity - https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-partition-key-design.html#bp-partition-key-partitions-adaptive ☁Topics covered include: - Primary Key - Partition Key - Sort Key - Range Key - Partitions, - Partition Splitting - Read Capacity Units (RCU) - Write Capacity Units (WCU) - Throttling - Adaptive Capacity - Burst Capacity 🌎 Find me here: Twitter - https://twitter.com/BeABetterDevv Instagram - https://www.instagram.com/beabetterdevv/ Patreon - Donations help fund additional content - https://www.patreon.com/beabetterdev #DynamoDB #PartitionKey #SortKey

Essential Gaming PC Build

AI-recommended products based on this video

Loading...
Skytech Archangel Gaming PC Desktop – AMD Ryzen 5 3600 3.6 GHz, NVIDIA RTX 3060, 1TB NVME SSD, 16GB DDR4 RAM 3200, 600W Gold PSU, 11AC Wi-Fi, Windows 11 Home 64-bit

Skytech Archangel Gaming PC Desktop – AMD Ryzen 5 3600 3.6 GHz, NVIDIA RTX 3060, 1TB NVME SSD, 16GB DDR4 RAM 3200, 600W Gold PSU, 11AC Wi-Fi, Windows 11 Home 64-bit

(31)
$2,657.01$2,656.90
FREE delivery Feb 24 - Mar 3
Loading...
Acer Nitro V 16 AI Gaming Laptop, 16" WUXGA 180Hz Display, AMD Ryzen 5 240, GeForce RTX 5050, 16GB DDR5, 512GB SSD, Backlit Keyboard, Copilot, Wi-Fi 6E, Win 11, Black, 1TB Docking Station Set

Acer Nitro V 16 AI Gaming Laptop, 16" WUXGA 180Hz Display, AMD Ryzen 5 240, GeForce RTX 5050, 16GB DDR5, 512GB SSD, Backlit Keyboard, Copilot, Wi-Fi 6E, Win 11, Black, 1TB Docking Station Set

(40)
$1,399.00
FREE delivery Feb 24 - Mar 5
Loading...
ASUS TUF Gaming A15 Gaming Laptop, 15.6” 144Hz FHD Display, AMD Ryzen 5 7535HS Processor, GeForce RTX 2050, 8GB DDR5 RAM, 512GB PCIe SSD Gen 4, Wi-Fi 6, Windows 11, FA506NF-AS51-CA

ASUS TUF Gaming A15 Gaming Laptop, 15.6” 144Hz FHD Display, AMD Ryzen 5 7535HS Processor, GeForce RTX 2050, 8GB DDR5 RAM, 512GB PCIe SSD Gen 4, Wi-Fi 6, Windows 11, FA506NF-AS51-CA

(156)
$799.00$759.05
FREE delivery Mon, Feb 16
Loading...
KAMRUI Mini PC E3B, Mini Computer AMD Ryzen 5 7430U (6C/12T, Up to 4.3GHz), 16GB DDR4 512GB M.2 SSD Mini Gaming Pc W11 PRO, 4K Triple Display/WiFi 6/BT5.2/USB3.2 for Home/Business Mini Desktop PC Global Recycled Standard

KAMRUI Mini PC E3B, Mini Computer AMD Ryzen 5 7430U (6C/12T, Up to 4.3GHz), 16GB DDR4 512GB M.2 SSD Mini Gaming Pc W11 PRO, 4K Triple Display/WiFi 6/BT5.2/USB3.2 for Home/Business Mini Desktop PC Global Recycled Standard

(227)
$499.00
FREE delivery Sun, Jan 4Only 8 left in stock.
Loading...
MSI MPG X870E Carbon WiFi Gaming Motherboard (AMD Ryzen 9000/8000/7000 Series Processors, AM5, DDR5, PCIe 5.0, SATA 6Gb/s, M.2, USB 3.2 Gen 2, Wi-Fi 6E, Bluetooth 5.3, LAN 2.5Gbps, HDMI/DP, ATX)

MSI MPG X870E Carbon WiFi Gaming Motherboard (AMD Ryzen 9000/8000/7000 Series Processors, AM5, DDR5, PCIe 5.0, SATA 6Gb/s, M.2, USB 3.2 Gen 2, Wi-Fi 6E, Bluetooth 5.3, LAN 2.5Gbps, HDMI/DP, ATX)

(243)
$519.99$413.19
FREE delivery Sat, Jan 3
50+ bought in past month
Loading...
MSI MPG Z790 Carbon WiFi II Gaming Motherboard (Supports 12th/13th/14th Gen Intel Processors, LGA 1700, DDR5, PCIe 5.0, M.2, 2.5Gbps LAN, USB 3.2 Gen2, Wi-Fi 7, ATX)

MSI MPG Z790 Carbon WiFi II Gaming Motherboard (Supports 12th/13th/14th Gen Intel Processors, LGA 1700, DDR5, PCIe 5.0, M.2, 2.5Gbps LAN, USB 3.2 Gen2, Wi-Fi 7, ATX)

(3,098)
$479.99$435.09
FREE delivery Sat, Jan 3
Loading...
MSI MPG X870E Edge TI WiFi Gaming Motherboard (AMD Ryzen 9000/8000/7000 Series Processors, AM5, DDR5, PCIe 4.0, M.2, SATA 6Gb/s, USB 3.2 Gen 2, HDMI/DP, Wi-Fi 7, Bluetooth 5.3, 2.5Gbps LAN, ATX)

MSI MPG X870E Edge TI WiFi Gaming Motherboard (AMD Ryzen 9000/8000/7000 Series Processors, AM5, DDR5, PCIe 4.0, M.2, SATA 6Gb/s, USB 3.2 Gen 2, HDMI/DP, Wi-Fi 7, Bluetooth 5.3, 2.5Gbps LAN, ATX)

(160)
$369.99$307.79
FREE delivery Sat, Jan 3
Loading...
MSI MPG A1000GS PCIE5, Fully Modular Gaming 1000W Power Supply, 80+ Gold, Dual 12V-2x6 Cables, Server-Grade, ATX 3.1 & PCIe 5.1, Low-Noise, Semi Digital, Embossed Jacket Cables, 10 Year Warranty

MSI MPG A1000GS PCIE5, Fully Modular Gaming 1000W Power Supply, 80+ Gold, Dual 12V-2x6 Cables, Server-Grade, ATX 3.1 & PCIe 5.1, Low-Noise, Semi Digital, Embossed Jacket Cables, 10 Year Warranty

(192)
$169.99
FREE delivery Sat, Jan 3
50+ bought in past month
Loading...
Corsair Vengeance LPX 32GB (2 X 16GB) DDR4 3200 (PC4-25600) C16 1.35V Desktop Memory - Black
Best Seller

Corsair Vengeance LPX 32GB (2 X 16GB) DDR4 3200 (PC4-25600) C16 1.35V Desktop Memory - Black

(16,675)
$112.99$101.69
FREE delivery Sun, Aug 10
500+ bought in past month
Loading...
Samsung 990 EVO Plus - 4TB PCIe Gen4. X4, Gen5. X2 NVMe 2.0 - M.2 Internal SSD, Speed Up to 7,250 MBs, Upgrade Storage for PC-Laptops, HMB Technology and Intelligent Turbowrite (MZ-V9S4T0B/AM)

Samsung 990 EVO Plus - 4TB PCIe Gen4. X4, Gen5. X2 NVMe 2.0 - M.2 Internal SSD, Speed Up to 7,250 MBs, Upgrade Storage for PC-Laptops, HMB Technology and Intelligent Turbowrite (MZ-V9S4T0B/AM)

(1,811)
$359.99$341.99
FREE delivery Tue, Jun 17
100+ bought in past month
Loading...
SAMSUNG EVO Select Micro SD-Memory-Card + Adapter, 128GB microSDXC 160MB/s Full HD & 4K UHD, UHS-I, U3, A2, V30, for Android Smartphones, Tablets, Nintendo-Switch (MB-ME128SA/AM) [Canada Version]

SAMSUNG EVO Select Micro SD-Memory-Card + Adapter, 128GB microSDXC 160MB/s Full HD & 4K UHD, UHS-I, U3, A2, V30, for Android Smartphones, Tablets, Nintendo-Switch (MB-ME128SA/AM) [Canada Version]

(12,472)
$19.99$18.59
FREE delivery Sun, Aug 10 on your first order
400+ bought in past month
Loading...
Samsung EVO Select Micro SD Memory Card + Adapter, 256GB microSDXC 160MB/s Full HD & 4K UHD, UHS-I, U3, A2, V30, for Android Smartphones, Tablets, Nintendo-Switch (MB-ME256SA/AM) [Canada Version]

Samsung EVO Select Micro SD Memory Card + Adapter, 256GB microSDXC 160MB/s Full HD & 4K UHD, UHS-I, U3, A2, V30, for Android Smartphones, Tablets, Nintendo-Switch (MB-ME256SA/AM) [Canada Version]

(11,340)
$34.99
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
SAMSUNG 870 EVO SATA SSD 500GB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E500B/AM [Canada Version]

SAMSUNG 870 EVO SATA SSD 500GB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E500B/AM [Canada Version]

(41,678)
$74.97
FREE delivery Wed, Jun 18
400+ bought in past month
Loading...
Gigabyte GeForce RTX 3060 Ti Vision OC 8GB V2 LHR Graphics Card

Gigabyte GeForce RTX 3060 Ti Vision OC 8GB V2 LHR Graphics Card

(106)
$2,588.43
FREE delivery Feb 24 - Mar 3Only 3 left in stock.
Loading...
GIGABYTE GeForce RTX 3060 Ti Vision OC 8G Graphics Card, WINDFORCE 3X Cooling System, LHR, 8GB 256-bit GDDR6, GV-N306TVISION OC-8GD REV2.0 Video Card

GIGABYTE GeForce RTX 3060 Ti Vision OC 8G Graphics Card, WINDFORCE 3X Cooling System, LHR, 8GB 256-bit GDDR6, GV-N306TVISION OC-8GD REV2.0 Video Card

(287)
$2,588.43
Loading...
Laptop Parts 78mm T128010SU RTX3060 3060Ti Graphics Fan for GIGABYTE for GeForce RTX 3060 Ti Vision OC 3X for WINDFORCE Video Card(C)

Laptop Parts 78mm T128010SU RTX3060 3060Ti Graphics Fan for GIGABYTE for GeForce RTX 3060 Ti Vision OC 3X for WINDFORCE Video Card(C)

(0)
$36.97
FREE delivery Mar 19 - Apr 10
Loading...
Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black
Best Seller

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

(17,871)
$27.98$22.38
FREE delivery Tue, Oct 14 on your first order
500+ bought in past month
Loading...
CORSAIR iCUE Link XD5 RGB Elite LCD Pump-Reservoir Unit - D5 PWM Pump - 480x480 IPS LCD Screen - 22 Addressable RGB LEDs - 440ml Nylon Reservoir - White

CORSAIR iCUE Link XD5 RGB Elite LCD Pump-Reservoir Unit - D5 PWM Pump - 480x480 IPS LCD Screen - 22 Addressable RGB LEDs - 440ml Nylon Reservoir - White

(17)
$379.99
FREE delivery Sun, Aug 24
Loading...
CORSAIR iCUE Link XC7 RGB Elite CPU Water Block - Transparent Flow Chamber - 24 RGB LEDs - Fits Intel® LGA 1700, AMD® AM5 and Older - White

CORSAIR iCUE Link XC7 RGB Elite CPU Water Block - Transparent Flow Chamber - 24 RGB LEDs - Fits Intel® LGA 1700, AMD® AM5 and Older - White

(56)
$149.99$125.33
FREE delivery Sun, Aug 24
Loading...
CORSAIR Hydro X Series iCUE Link XH405i Custom Cooling Kit – Hardline Water Cooling Loop – XC7 Elite CPU Water Block – XD5 Elite D5 Pump Res – XR5 360mm Radiator – 3X QX120 RGB Fans

CORSAIR Hydro X Series iCUE Link XH405i Custom Cooling Kit – Hardline Water Cooling Loop – XC7 Elite CPU Water Block – XD5 Elite D5 Pump Res – XR5 360mm Radiator – 3X QX120 RGB Fans

(235)
$879.99
FREE delivery Sun, Aug 24
Loading...
STGAubron Gaming PC Desktop, Intel Core i7 up to 3.9G, GeForce GTX 1660 Super 6G GDDR6, 32G RAM, 1T SSD, WiFi, BT 5.0, RGB Fan x 6, Windows 10 Home

STGAubron Gaming PC Desktop, Intel Core i7 up to 3.9G, GeForce GTX 1660 Super 6G GDDR6, 32G RAM, 1T SSD, WiFi, BT 5.0, RGB Fan x 6, Windows 10 Home

(71)
$852.99
FREE delivery Mon, Aug 11
Loading...
HP Stream 14-Inch Laptop, Intel Celeron N4000, 4 GB RAM, 64 GB eMMC, Windows 10 Home in S Mode (14-cb159nr, Jet Black)

HP Stream 14-Inch Laptop, Intel Celeron N4000, 4 GB RAM, 64 GB eMMC, Windows 10 Home in S Mode (14-cb159nr, Jet Black)

(2,765)
$278.00
FREE delivery Jun 17 - 19Only 9 left in stock.
Loading...
MeLE Quieter DL Mini PC Windows 11 Home, N100 4GB 128GB, 2.5G Dual LAN,IoT Industrial Desktop Computer Support Windows 10 11 Linux Ubuntu Debian 4K Triple Display, Dual HDMI, All-in-One USB-C

MeLE Quieter DL Mini PC Windows 11 Home, N100 4GB 128GB, 2.5G Dual LAN,IoT Industrial Desktop Computer Support Windows 10 11 Linux Ubuntu Debian 4K Triple Display, Dual HDMI, All-in-One USB-C

(170)
$239.99
PrimeFREE delivery Sat, Jun 14