Grokking the System Design Interview, Volume II
Vote

0% completed

​

Reminder Alert System: Data Model and Storage

Step 5: Data Model and Storage Design

Designing the right data schema is critical for performance. We need to support two primary access patterns efficiently:

  1. Lookup reminders by next execution time (for the Scheduler to find what’s due now).
  2. Lookup reminders by user (for user queries and for computing next occurrences, etc.).

To achieve this, we will use a denormalized approach with two main tables/collections:

  • Reminders Table (Definition Storage): This stores the primary data for each reminder. Each entry includes: ReminderID (primary key, could be a UUID),

.....

.....

.....

Like the course? Get enrolled and start learning!