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 
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