Grokking the System Design Interview
Ask Author
Back to course home

0% completed

Vote For New Content
Hi, are there any downsides to partitioning 1 keys table instead of creating 2 s...

Alex Wells

Sep 4, 2022

Hi, are there any downsides to partitioning 1 keys table instead of creating 2 separate tables? I believe this helps us with database normalization

1

0

Comments
Comments

On this page

  1. Why do we need URL shortening?

Try it yourself

Designing URL Shortener (video)

  1. Requirements and Goals of the System
  1. Capacity Estimation and Constraints
  1. System Interface Definition
  1. Create Short URL API
  1. Redirect API
  1. Analytics API
  1. URL Management API
  1. Delete Short URL API
  1. Database Design
  1. Basic System Design and Algorithm

a. Encoding actual URL

b. Generating keys offline

  1. Data Partitioning and Replication
  1. Cache
  1. Load Balancer (LB)
  1. Purging or DB cleanup
  1. Telemetry
  1. Security and Permissions