Dimensional & Recursive. Dimensional levels of the hierarchy are in separate columns/dimensions & Recursive: relationships are stored in a parent/child relationship.