Tag
#data-modeling
3 articles tagged data-modeling.
HLDintermediate
Google Calendar DB Design: Store the Recurrence Rule, Not a Million Rows
A database deep dive on modelling Google Calendar: storing a recurrence rule instead of infinite instances, expanding on read, cancellations and overrides, timezones/DST, and time-range queries.
10 min read
HLDintermediate
Reddit Comments DB Design: Modelling a Threaded Tree That Scales
A database deep dive on modelling Reddit-style threaded comments in SQL: adjacency list vs materialized path vs closure table, fetching a subtree in one query, plus scores and sharding by post.
9 min read
HLDbeginner
A Rookie's Guide to HLD: Design Zomato with Nouns and Verbs
How to approach any high-level design interview: extract the data model and APIs from plain sentences — nouns, verbs, hidden tables — applied live to a Zomato-style food delivery system design.
6 min read