Graphs in the database: how to store a graph data structure in a DBMS, and answer the most common queries typical of social networks, like "You might also know" or "You might also like", or "How you are connected to XYZ" (degrees of separation).
This morning a new article of yours truly has been published on the TechPortal.
The title is Graph in the database: SQL meets social networks, and it's a natural sequel to my talk about Trees in the database.
You will learn how to retrieve linked nodes, and how to answer some of the queries typical of social networks like LinkedIn, Facebook, or recommendation systems ("You might also know/like", "How you are connected to XY", ...).
A special "thank you" to my colleague and friend Ian for reviewing the article with patience and a lot of suggestions.
» Have a nice reading!