Grokking the System Design Interview, Volume II
Vote

0% completed

​

Google News: Data Model and Storage

Step 5: Data Model and Storage Design

Step 4 drew the system. This step names what it stores, so we know what each part reads and writes. The diagram above shows the pieces we now define, one at a time.

Article data. Each article is one record. Its fields include article_id, title, content_snippet, url, source_id, publish_time, category, keywords, and image_url. We might also store a content vector for recommendations, and flags like trending or breaking.

Every article gets a globally unique article_id

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content