Modelling a hierarchy in Data Vault
Lately I have been having interesting discussions regarding modelling hierarchies in Data Vault. It seems that it’s the easiest way to create a new link table between the hubs which contain the hierarchy elements. In this case, the hub contains all the possible nodes and the link table contains all possible relations (parent/child) between these nodes. This can be expanded to add more information about the hierarchy relations including level indication and of course validity periods. The hierarchy itself can also be modelled generically but creating a single hierarchy hub. But this is all optional.