Lorenzo Alberton

London, UK   ·   Contact me   ·  

Talks » Graphs in the database: RDBMS in the social networks age

PHP Barcelona 2010 , Barcelona, Spain, 30 October 2010

Despite the NoSQL movement trying to flag traditional databases as a dying breed, the RDBMS keeps evolving and adding new powerful weapons to its arsenal. In this talk we’ll explore Common Table Expressions (SQL-99) and how SQL handles recursion, breaking the bi-dimensional barriers and paving the way to more complex data structures like trees and graphs, and how we can replicate features from social networks and recommendation systems. We’ll also have a look at window functions (SQL:2003) and the advanced reporting features they make finally possible.  


Back