The Fifth Model

The column design for storing the tree structure data in RDB table is the heart of the Fertile Forest model. By the design, we can write flexible-fast search query without adding any search efficiency columns.

I am going to explain Fertile Forest model with the origins and the mechanism to search query along the following items.

1. Model Design
2. To Find Nodes (Ancestors)
3. To Find Nodes (Subtree)
4. To Find Nodes (Kinships)
5. To Add Node
6. To Graft Nodes
7. To Remove Nodes
8. To Retrieve Tree