Lorenzo Alberton

Contact me   ·  

Articles » Oracle

Filter articles by topic

AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Hadoop, Imagick, INFORMATION_SCHEMA, JavaScript, Kafka, Linux, Message Queues, mod_rewrite, Monitoring, MySQL, NoSQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend Framework

PHP UK 2010: RDBMS in the social networks age

PHP, Database, PostgreSQL, Firebird SQL, Oracle, SQL Server, Data structures

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

27 February 2010

Speaking at the PHP Barcelona conference 2009

PHP, Database, PostgreSQL, Firebird SQL, Oracle, SQL Server

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

26 October 2009

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

Database, PostgreSQL, Firebird SQL, Oracle, SQL Server, Tutorial, Data structures

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

7 September 2009

Graphs in the database: SQL meets social networks

Database, PostgreSQL, Firebird SQL, Oracle, Data structures

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

7 September 2009

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

PHP, Database, PostgreSQL, Firebird SQL, Oracle, SQL Server, Data structures

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

27 June 2009

Speaking at the Dutch PHP Conference 2009

PHP, Database, PostgreSQL, Firebird SQL, Oracle, SQL Server

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

10 April 2009

Database identifiers, quoting and case sensitivity

PHP, PEAR, PostgreSQL, Oracle

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

3 December 2008

Updated articles to extract META informations from databases

PHP, Database, PostgreSQL, Firebird SQL, Oracle, SQL Server, INFORMATION_SCHEMA

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.   Read article

9 September 2008

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

PHP, PEAR, Database, Oracle, Book Review

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

17 November 2007

Extracting META information from Oracle (INFORMATION_SCHEMA)

PHP, Database, Oracle, INFORMATION_SCHEMA

Extracting META information from an Oracle database using the Oracle Data Dictionary views (INFORMATION_SCHEMA)   Read article

17 June 2007