From the course: AWS for Developers: DynamoDB

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Data modeling in DynamoDB

Data modeling in DynamoDB - Amazon Web Services (AWS) Tutorial

From the course: AWS for Developers: DynamoDB

Start my 1-month free trial

Data modeling in DynamoDB

- [Instructor] If you're coming from a Relational SQL database background, modeling your data to get the most out of DynamoDB requires a little shift in thinking. In this video, I'm going to tell you how to spread your data across partitions, and I'm going to explain what we mean by a cold partition or a hot partition, and why you'll get so much benefit out of understanding this. Let's look at a traditional relational database schema for capturing AtBats in a baseball game. Remember, the baseball game has teams, players, games, and every time a batter comes to the plate, that's considered an AtBat. As you can see, we have all the elements represented here to store a log of AtBats for a professional baseball game. Now you might be tempted to create four tables in DynamoDB to represent the same data, but that's not how DynamoDB works. Ideally, you should have one table for your entire application, and explain why that's going to help you, you need to understand how DynamoDB gets its…

Contents