Thursday, July 28, 2005

SQL Lattice Structures?

Just a quicky, but if anyone can point me to a good resource on creating lattices in SQL Server I'd appreciate it. I'm familiar with Nested Sets, but I'm looking for something that doesn't seem so update intensive, but even more, I need to create lattice like structures, not just trees.

I could do it with parallel trees, but then I have to choose between reporting sacrifices, or n*depth row explosion depending on how parallel I want to get. This one really has me stumped.

I could always go with an adjacency model, but the intensive nature of walking the trees makes that unappealing...
Comments: Post a Comment

<< Home

This page is powered by Blogger. Isn't yours?