Databases · Senior · Question 58 of 75

When does a graph database (like Neo4j) fit better than a relational one?

1For time-series metrics
2For storing simple key-value settings
✓Correct answer: When queries traverse many-hop relationships of variable depth, like social networks, recommendations or fraud rings

Explanation

Relational databases can do it with recursive CTEs, but deep traversals get slow and awkward. For shallow relationships SQL is fine.

Further reading

Test yourself

Take the Databases · Senior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.