Chapter 3. Path Enumeration Models
One of the properties of trees is that there is one and only on path from the root to every node in the tree. The path enumeration model stores that path as a string by concatenating either the edges or the keys of the nodes in the path. Searches are done with string functions and predicates on those path strings. The code in this book is product specific, but easily generalized.
Keywords: edge enumeration, node enumeration, subordinates, superiors, path string, HIERARCHYID, XML, XPath
One of the properties of trees is that there is one and only path from the root to every node in the tree. The path enumeration model stores that path as a string by concatenating either the edges or the keys of the nodes in the ...
Get Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd 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.
