One technique you might look into is "Materialized Path": * usually one single query to fetch an entire tree or subtree * more work on reconstructing tree from

One technique you might look into is "Materialized Path": * usually one single query to fetch an entire tree or subtree * more work on reconstructing tree from query result * requires prefix pattern matching operator, e.g. "like" from RDBMS