Latest articles
RDBMS in the social networks age
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.
Lorenzo Alberton
Lorenzo 
has been working with large
enterprise UK companies for the past years and is now Chief Tech Architect at
DataSift.
He's an international
conference speaker and 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,
Message Queues,
mod_rewrite,
MySQL,
NoSQL,
Oracle,
PDO,
PEAR,
Performance,
PHP,
PostgreSQL,
Profiling,
Scalability,
Security,
SPL,
SQL Server,
SQLite,
Testing,
Tutorial,
TYPO3,
Windows,
Zend Framework