In practice, I've found that the adjacency list works well enough in most cases. One good data warehousing habit is to generate the closure table as a materiali

In practice, I've found that the adjacency list works well enough in most cases. One good data warehousing habit is to generate the closure table as a materialised view of the original adjacency list table, so you effectively have both interfaces available for the same data.