XML RSS feed Articles » Oracle

PHP UK 2010: RDBMS in the social networks age

Wrapup of the PHP UK Conference 2010. Uploaded slides of my talk "RDBMS in the social networks age" about graphs in the database.

Speaking at the PHP Barcelona conference 2009

Speaking at the PHP Barcelona Conference 2009. Talk: "Trees in the Database: Advanced Data Structures".

New article: Graphs in the database, SQL meets social networks

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

Graphs in the database: SQL meets social networks

How to store a graph data structure in a DBMS, and query it to solve many of the problems of social networks.

Trees in the database: It sure ain't no CouchDB!

Wrap-up of the Dutch PHP Conference, Amsterdam, 11-13 June 2009.

Speaking at the Dutch PHP Conference 2009

Speaking at the Dutch PHP Conference 2009. Talk: "Trees in the Database: Advanced Data Structures".

Database identifiers, quoting and case sensitivity

Exploring database delimited identifiers and case sensitivity: the effect of quoting table and field names in the various DBMS.

Updated articles to extract META informations from databases

By popular request, I've updated my articles explaining how to retrieve meta data from your DBMS (Firebird SQL, PostgreSQL, Oracle, SQL Server). Have fun.

Book review: "PHP Oracle Web Development" by Yuli Vasiliev

Review of the book "PHP Oracle Web Development" by Yuli Vasiliev (Packt Publishing). Book contents, highlights and impressions. A sample chapter is included.

Extracting META information from Oracle (INFORMATION_SCHEMA)

Extracting META information from an Oracle database using the Oracle Data Dictionary views (INFORMATION_SCHEMA)
1   2   Next »

Lorenzo Alberton

Lorenzo Alberton Lorenzo has been working with large enterprise UK companies for the past 10+ years and is currently CTO at DataSift. He's an international conference speaker and a long-time contributor to many open source projects. Lorenzo Alberton's profile on GitHub Lorenzo Alberton's profile on LinkedIN View Lorenzo Alberton's profile on PHP PEAR
View Lorenzo Alberton's Twitter stream Lorenzo Alberton - Sun Certified MySQL 5 Developer PHP5 ZCE - Zend Certified Engineer