List functional requirements for the system (Ask the chat bot for hints if stuck.)...
shorten url
redirect url
tracking clicks
user management
expireation of short url
analytics dashbord
List non-functional requirements for the system...
latency
scalability
Estimate the scale of the system you are going to design...
Write QPS = 200
Read QPS = 20,000
daily storage = 4.4 GB
Define what APIs are expected from the system...
1) Post /short/url
request
{
"user_id":"",
"url":""
}
response
{
"short_url":"",
"ttl":""
}
2) Get /short/url/{short_url}
request
{
"long_url":""
}
Defining the system data model early on will clarify how data will flow among different components of the system. Also you could draw an ER diagram using the diagramming tool to enhance your design...
URLMapping table:
| Column Name | Data Type | Description |
| short_url | VARCHAR(8) | Primary key for the shortened URL |
| long_url | VARCHAR(2048) | Original long URL (may vary in length) |
| created_time | TIMESTAMP | Timestamp of when the short URL was created |
| user_id | VARCHAR(255) | ID of the user who created the short URL (optional if user management is implemented) |
| expiration_time | TIMESTAMP (nullable) | Expiration time for the short URL (optional) |
You should identify enough components that are needed to solve the actual problem from end to end. Also remember to draw a block diagram using the diagramming tool to augment your design. If you are unfamiliar with the tool, you can simply describe your design to the chat bot and ask it to generate a starter diagram for you to modify...
To illustrate the interactions between these components, here’s a high-level flowchart representing the typical request flow:
Explain how the request flows from end to end in your high level design. Also you could draw a sequence diagram using the diagramming tool to enhance your explanation...
Dig deeper into 2-3 components and explain in detail how they work. For example, how well does each component scale? Any relevant algorithm or data structure you like to use for a component? Also you could draw a diagram using the diagramming tool to enhance your design...
Explain any trade offs you have made and why you made certain tech choices...
Try to discuss as many failure scenarios/bottlenecks as possible.
What are some future improvements you would make? How would you mitigate the failure scenario(s) you described above?