Celko

Joe Celko Nested Sets 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... Platforms: PHP

elko Visitation Model can be use to manipulate hierarchic trees of records stored in a MySQL database using Joe Celko visitation model. It can perform the following tasks in a very effecient way mostly using one SELECT query statement.Features of Celko Visitation Model:- Find out leaf nodes in... Platforms: PHP

MPTTA for PHP and MySQL is a script can manage hierarchic trees of information stored in a MySQL database.It can add, move or delete branches inside a database tree created using the Modified Preorder Tree Traversal Algorithm described by Joe Celko in the DBMS Magazine in 1996.MPTTA for PHP and... Platforms: PHP