Topic: 2014 EMEA
Subtopic: Cross Platform DB2 for z/OS & LUW
Managing hierarchies in an efficient way can be a daunting task when it comes to relational databases. In this session we will discuss four
common implementations of hierarchies in SQL; Common Table
Expressions, Materialized Path, Nested Sets and Transitive Closure
tables. We will discuss benefits and drawbacks with each model, as well as algorithms for common operations and their space and time complexity.
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.