Algorithms: Joe Celko Nested Sets Setec Astronomy (contact me)
This class is meant to manage tree database structure using Jeo Celko's nested sets approach.
You can add node with 7 queries, delete a node with subnodes with 4 queries and move node with 11 queries.
The number of queries per action does not depend on the number of sub-nodes, so it is a scalable solution.