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.

Composite keys and sort keys

Composite keys and sort keys - Amazon Web Services (AWS) Tutorial

From the course: AWS for Developers: DynamoDB

Start my 1-month free trial

Composite keys and sort keys

“

- [Instructor] As I've said before in this course, ideally, you want just one DynamoDB table for your entire application. But how do we continue to do that and get the speed we desire with more items? Back to our baseball example. We've already said that we want to partition our data based on team name or team ID, but how do we store different kinds of data about baseball games on team name or team ID? Well, this is where composite keys come in. Composite keys allow us to save different kinds of data, but still evenly spread the requests across multiple partitions. Remember, we said that an application that tracks at-bats in a professional baseball game should store players, teams, games, as well as at-bats. How do we create our partition keys to represent this data in a single table? Imagine if we have table called BaseballApp. Well, we could save our roster keyed with the word PLAYERS, and then <TeamID>. We could store information about our teams, such as the stadium location…

Contents