Quoted: I Have found four methods used to encode tree structures in relational databases. Each one has its advantages and disadvantages, and I have used Adjacency Lists and Materialized paths many times in different kinds of applications. Now I will try a mixed approach: Materialized Path + Nested Sets.

Quoted: In this article I'll investigate two out of four well known approaches to modeling a tree in the database and show a connection between them. We'll discover a new method that could be considered as a "mix-in" between materialized path and nested sets.

Quoted: Oracle tools tips - Trees in SQL - Materialized Path, Finding a Set of Intervals Covering a Point

Quoted: Способы хранения деревьев в базах данных

Quoted: Прежде всего посмотрим, как выглядят деревья Nested Sets, как они организованы и в чем удобство их использования.

Quoted: Migrate a MySQL Database Preserving Special Characters -- article related to Developers and Databases.

Quoted: SitePoint.com - » Flickr mySQL DBA Blog