Grokking the System Design Interview
Ask Author
Back to course home

0% completed

Vote For New Content
In section 5, are the tables an RDBMS schema representation? If so, how would th...

Prabhakar

Mar 15, 2022

In section 5, are the tables an RDBMS schema representation? If so, how would this scale given the number of users/entities and the UserFollow table may explode in size with 1B (users) x 1B (entities)

  • Assuming we have 1B users that can also be entities

Similarly FeedMedia table size can also be too large for an RDBMS DB.

  1. How would these be modeled in NoSQL and what DBs would be used?
  2. Can we use Cassandra for tracking both UserFollow (User as Key and all followed as column values), UserFeed (User as Key and Feeds as column values)? How would we store FeedMedia in this case?

0

0

Comments
Comments
Design Gurus
Design Gurus4 years ago

For any large data, we need a partitioning scheme to distribute to multiple DB servers. See section 9 (Data Partitioning).

NoSQL DBs can also be used. Facebook is using MySQL to store its social graph. New NoSQL solutions like Graph databases (e.g., neo4j) can also be...