The Endless Thread

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

We're building an analytics warehouse for a consumer social network where users share photos and video. Users create posts, follow one another one direction at a time, and like posts, and the model has to make a duplicate follow or a repeat like impossible to store on its own, not through application checks. A comment either sits on a post or replies to another comment, so with the growth team tracking virality and the product team tracking engagement per content type, design the warehouse model.

Summary

Follows, likes, replies to replies. It never stops.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.