When to use which NoSql dB?

In a typical system design questions, when making a DB choice, after deciding on SQL vs NoSQL, the question usually asked is why you chose the said NoSQL out of the other 3 types.

Could anyone help me list some pros and cons for some of the applications to understand the thought process behind? So For example, for the following applications:

  1. Music streaming service to get top k songs in past 7 days
  2. File storage service
  3. Web crawler

What are the pros and cons for each of the following categories if used in the above applications:

  1. Key-Value type
  2. Document type
  3. Wide-column based
  4. Graph based

Basically, the interviewers don't want an answer directly on the choice of db but the thought process on why is used over another.

Comments (0)