
The Virtual Waiting Room - Fairly Queuing 1 Million Fans Under Extreme Load
DynamoDB Football Data Modeling Challenge #1
Welcome to the first of our new four part DynamoDB data modeling challenge . Improve your DynamoDB skills with an opportunity to win some AWS swag in the process!
Tickets go on sale in 10 minutes. One million fans are watching the clock. The stampede is coming.
When tickets for the biggest match of the year drop, a million fans hit the system simultaneously. Before anyone can buy a seat, the platform must absorb the initial stampede, fairly assign every fan a place in line, and progressively admit them to the purchasing flow without overwhelming downstream systems. A perceived unfairness in the queue - or a system that buckles under the load - can make international headlines. The waiting room itself is the first and most critical bottleneck: get it wrong, and nothing else matters.
Your challenge: Design a DynamoDB-powered virtual waiting room that fairly queues up to 10 million concurrent fans arriving within seconds, assigns each a verifiable queue position, and progressively promotes batches of fans from "waiting" to "eligible to browse" based on their position and available purchasing capacity. Your system must handle the initial burst without dropping or misordering fans, prevent queue-position gaming, and provide fans with real-time status updates on their position and estimated wait time.
Getting started: There are several tools and resources which will help you get started regardless of your experience with DynamoDB.
First, NoSQL Workbench for DynamoDB will help you organize your data model and access patterns, input sample data, and provide a standard way for you to share and submit your model.
If you're new to DynamoDB, keep the documentation on data modeling handy and visit the NoSQL Builder Space If you have more time available, DynamoDB NoSQL Designs will provide additional foundation.
Finally, if you'll be using Kiro (or your favorite agentic IDE), make sure to enable the DynamoDB MC P server for better accuracy in data modeling queries.
Your deliverables:
- A DynamoDB table design that models the waiting room queue (fan identifier, queue position, entry timestamp, eligibility status, batch assignment) with a key schema optimized for high-throughput concurrent writes during the initial stampede
- An explanation of how fans are assigned a fair queue position when they arrive (e.g., timestamp-based ordering with randomized tie breaking to prevent gaming), including how your design handles clock skew and near-simultaneous arrivals at scale
- A batch promotion strategy that describes how groups of fans are moved from "waiting" to "eligible to browse" as purchasing capacity frees up - including how batch size is determined, how promotion is triggered, and how you prevent promoting more fans than the purchasing system can handle
- A fan status query design that lets each fan check their current position, estimated wait time, and eligibility status with low-latency reads - even while millions of fans are polling simultaneously
Stretch goals (not required, but we'd love to see them):
- A mechanism for ensuring the number of active users purchasing tickets is 1,000, drawing new batches of users from the waiting room to fill back to 1,000 without waiting for all slots to empty
What you'll gain: Experience designing high-throughput ingestion systems where fairness and ordering matter. You'll learn how to handle extreme write bursts in DynamoDB, model ordered queues in a system that doesn't natively support global sorting, and build promotion workflows that regulate downstream load - patterns that apply to any system managing access to a scarce resource under contention.
How to submit: Push your solution to a public GitHub repository, complete the AWS Pulse survey , and post a comment on this page sharing something you learned. See the full Terms and Conditions for details. Submissions open at 12:00 a.m. PDT July 3 (07:00 July 3 GMT) and close at 12:00 p.m PDT July 10 (19:00 July 10 GMT).
Support: Problems? Questions? Please email dynamodb-developer-challenges@amazon.com for any issues. Builder Center support will be unable to provide assistance.
The DynamoDB Data Modeling Challenge is open to participants in select countries who are 18+ with an AWS Builder Center profile. See the full Terms and Conditions on the challenge page for eligibility details and restrictions.
Enjoyed reading this content? Let the author know!
Your likes, comments, shares, and saves help creators reach more builders.
Loading recommendations
Loading article