AWS Builder Center
The Infinite Leaderboard — Creative Competition at Global Scale

The Infinite Leaderboard — Creative Competition at Global Scale

DynamoDB Football Data Modeling Challenge #4

DynamoDB Solutions Architect
A billion fans. Unlimited creativity. Leaderboards that update faster than the crowd can roar.
The tournament isn't just about what happens on the pitch — it's about the fans competing with each other off it. Organizers want to launch a platform where fans create and participate in an open-ended set of leaderboards: "Best Prediction Streak", "Most Accurate Lineup Builder", "Fastest Trivia Responder" — anything the community dreams up. Each leaderboard is identified by name, tracks scores for individual participants, and must support more than 1,000 score updates per second at peak. A score entry is simple: a leaderboard name, a participant identifier, and an integer value. The scale and variety of leaderboards make this a serious data modeling challenge.
Your challenge: Design a DynamoDB-backed leaderboard platform that supports an unbounded number of named leaderboards, each capable of handling over 1,000 write operations per second, with the ability to query top-N rankings, individual participant standings, neighboring records on the leaderboard, and cross-leaderboard profiles.
Your deliverables:
·         A DynamoDB table design (keys, indexes, item structure) that supports creating arbitrary leaderboards by name, recording scores per participant per leaderboard, and querying top-N rankings efficiently
·         An explanation of your partition key strategy for distributing writes across a high-velocity leaderboard without creating hot partitions (e.g., write sharding, scatter-gather for reads)
·         A strategy for serving the core access patterns: (1) top N scores on a given leaderboard, (2) a specific participant's rank and score on a given leaderboard, (3) list neighboring records, and (4) all leaderboards a participant is active on with their scores
Stretch goals (not required, but we'd love to see them):
·         Provide leaderboard users with their current rank
·         Support for additional data types on the leaderboards beyond integer
·         A cost analysis showing how on-demand capacity mode handles the spiky nature of leaderboard traffic (quiet between matches, explosive during live play) without over-provisioning
What you'll gain: Deep experience with one of the hardest problems in DynamoDB data modeling — high-write-throughput ranking systems. You'll learn how to balance write distribution against read efficiency, a trade-off that shows up in any system where aggregation and real-time ingestion must coexist.
How to submit: Complete the  AWS Pulse Survey , push your solution to a public GitHub repository, and post a comment on this page sharing something you learned. See the full Terms and Conditions for details. Submissions close at 12:00 p.m PDT August 21 (19:00 August 21 GMT).
Support: Problems? Questions? Please email  dynamodb-developer-challenges@amazon.com  for any issues. Builder Center support will be unable to provide assistance.
Not sure where to get started? Join the  NoSQL Launchpad in Builder Center  — that's where AWS NoSQL specialists knowledge share, review designs, and help teams pressure-test their DynamoDB configurations before the stakes are real.
Any opinions in this article are those of the individual author and may not reflect the opinions of AWS.
Enjoyed reading this content? Let the author know!

Your likes, comments, shares, and saves help creators reach more builders.

Loading recommendations

Loading article