At a glance
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).
Latest articles
New article: Graphs in the database, SQL meets social networks
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!
Lorenzo Alberton
Lorenzo 
works as a Consultant / Software Engineer / Technical Team Leader at Ibuildings, always busy with many cool clients.
He's a long-time contributor to many open source projects.
Tags
AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Imagick, INFORMATION_SCHEMA, JavaScript, Linux, mod_rewrite, MySQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend Framework
Leave a reply