Handling Graphs, Trees, and Hierarchies in Microsoft SQL Server

Download this episode

Download Video

Description

Graphs are specialized data structures that represent relationships between pairs of items. Examples for graphs include an Employee Organizational Chart and a Bill of Materials. This session explains how to query graph data stored in SQL Server to answer common requests, including: Subgraph, e.g., return all subordinates of a given manager. Path, e.g., return all management chain of a given employee. Presentation, e.g., sort employees such that a subordinate would be returned after a manager. This session explains how to handle such requests with recursive queries in SQL Server 2005 and also with the new HIERARCHYID datatype introduced in SQL Server 2008.
For more information, check out this course on Microsoft Virtual Academy:

Day:

0

Code:

08_NA_DAT3

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.