The Cusp of Helix

Fertile Forest Model
[C.1: Hierarchical Data in a RDB]

The Points

Contents of this chapter contains an important point in understanding the FF model. Please check the following three points, and then proceed to the next chapters.

  1. A model to store hierarchical data in a database contains two kinds of column. One is "column for storing hierarchical data", and Two is "column for efficiency search".
  2. A criteria of excellent model for storing hierarchical data in a database, is that it can write a search query to find a subtree and child nodes of an arbitrary node with reference the index.
  3. An second criteria is that total number of hierarchical structure column and search efficiency columns is fewer.