Unfortunately, not all hierarchies are this simple.
#Hierarchical database example how to
The article first provides an overview of how to create and populate the tables necessary to support a hierarchy and then focuses on how to query hierarchical data that contains multiple types of relationships. This article digs deeper into the topic of hierarchies, particularly those that contain more complex relationships than what you saw in the examples. One of the topics that the articles touched upon was how to work with hierarchical data and their relationships, as they applied to the FishGraph database used in the examples.
#Hierarchical database example series
This first three articles in this series focused on using SQL Server graph databases to work with data sets that contained relationships not easily handled in a typical relational structure, the types of relationships you might find in a social network site or product recommendation engine.