Celko Visitation Model 1.0

Celko 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 the current tree (nodes have no children)
- Find out nodes of a sub-tree for given node
- Find out the context path of given node
- Find out the level or depth of a given node
- Find out how many descendants a given node has

License type: GNU General Public License
Date added: 7 years, 11 months 10 days ago | Last updated: 3 years, 3 months 22 days ago

More popular Algorithm

This is actually one of the most advanced image hosting script. The imagetize key features: SEO, Ads Ready, Admin

Listing Files

celko-visitation-model
  • gnu.png
  • 262 Bytes
  • 05/16/2006 20:30:10
  • hierarchical-data-4.png
  • 5.9 KB
  • 05/16/2006 20:30:10
  • background.png
  • 238 Bytes
  • 05/16/2006 20:30:10
  • hierarchical-data-5.png
  • 7.4 KB
  • 05/16/2006 20:30:10
  • example.sql
  • 881 Bytes
  • 05/16/2006 20:30:10
  • hierarchical-data-3.png
  • 7.4 KB
  • 05/16/2006 20:30:10
  • nosoftwarepatents.gif
  • 199 Bytes
  • 05/16/2006 20:30:10
  • mysql.gif
  • 1.1 KB
  • 05/16/2006 20:30:10
  • mhillyer.jpg
  • 2.2 KB
  • 05/16/2006 20:30:10
  • xhtml10.png
  • 1.3 KB
  • 05/16/2006 20:30:10
  • empty.png
  • 206 Bytes
  • 05/16/2006 20:30:10
  • mysql_100x52-64.gif
  • 1.2 KB
  • 05/16/2006 20:30:10
  • Diagram1.GIF
  • 1.9 KB
  • 05/16/2006 20:30:10
  • w3c_validcssb.png
  • 1.1 KB
  • 05/16/2006 20:30:10
  • php.png
  • 949 Bytes
  • 05/16/2006 20:30:10
  • w3c_linkcheck.png
  • 1.2 KB
  • 05/16/2006 20:30:10
Hot Scripts
Sponsors