Grokking the System Design Interview, Volume II
Vote

0% completed

​

Step 5: Data Model and Storage

The data splits into two halves with different needs. Articles and feeds are large, written constantly, and read by key, so they go to a wide-column NoSQL store. Accounts and subscriptions are small and must stay correct, so they go to a relational database.

Articles

Each article is one record with article_id, title, content_snippet, url, source_id, publish_time, categories, entities, and image_url, plus flags such as breaking. A stored article looks like this:

{
  "article_id": "9f2c41d07a",

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content