Store and present hierarchies as:
- Nested Set (Nested Intervals)
- Adjacency List (ParentId, Children)
- Lineage Column (Materialized Path, Path Enumeration)
- Closure Table /w triggers (Bridge Table)
Large process model based on a nested-set datastructure:
path-notation (f.e. 01.01.02) and subtree count.