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.