A P P E N D I X

Image

The HIERARCHYID Datatype

Microsoft introduced the HIERARCHYID datatype as part of SQL Server 2008. A HIERARCHYID instance represents a hierarchy tree structure. Each node of a hierarchy tree can be manipulated and retrieved from the HIERARCHYID instance. When using HIERARCHYID, access is provided via a managed set of Common Language Runtime (CLR) data type methods that support creating, reading, updating, and deleting (CRUD) nodes in a hierarchy. An employee dimension, usually modeled as a self-referencing parent-child dimension, is a good candidate for HIERARCHYID.

In the following sections, you will create an employee table, ...

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.