Joe Celko Nested Sets
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Author | ||
 |
|
Innovation award Nominee: 5x | |||||||||||||||||||
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.
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.
| Classes of Setec Astronomy | > | Joe Celko Nested Sets | > | Download .zip .tar.gz | > |  Support forum |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||
| Groups |  User ratings |
Trackback | Applications |  Files |
||||||
| Groups | ||
 |
Algorithms | Numerical and statistical algorithms | View top rated classes |
|
Databases | Database management, accessing and searching | View top rated classes |
|
Data types | Modeling and manipulating data types | View top rated classes |
| User ratings | ||
| Ratings | ||||||||
|---|---|---|---|---|---|---|---|---|
| All time: | ||||||||
| Month: | ||||||||
| Trackback links | ||
| Link | Description |
|---|---|
| Help! My Hierarchy is Slow - Faster Hierarchies with Nested Sets | A great many applications, including many that I’ve worked on, have a hierarchy of things: of parts, of people, of organizations, etc... |
| Nested Sets | Once again faced with a situation where this simple algorithm is vital and again confronted with the fact that on the Internet nothing is working under PHP... |
| Nested Sets | Once again faced with a situation when the algorithm is simply vital and again confronted with the fact that the proposed network is nothing working under PHP.. |
| Applications that use this class | ||
No application links were specified for this class.
If you know an application of this package, send a message to the author to add a link here.| Files |
||
| File | Role | Description |
|---|---|---|
 ccelko.php |
Class | CCelkoNastedSet class file |
| sample.php |
Example | Sample file for CCelkoNastedSet class |
| Download all files: celkonestedset.tar.gz celkonestedset.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2013