...I seem to spend more and more time doing dba and anaylst stuff, rather than the out-of-control programmer that has all the fun.
With some major corps breathing down my back, I'm having to get the maximum stressful experience in how to optimize hierarchical databases in a relational database using SQL (more specifically T-SQL). Ok, so I improved the performance by about a factor of five by eliminating some unnecessary cruft and tightening up the algorithms. Performance is fair but not great.
Then I stumble across some papers that bespeak of the difference between Adjacency Models vs Nested Set Models, which makes me wish I'd actually paid attention to that whole idea of sets in college and less on beer.
Are there some stored procs to (a) convert a current adjancency model into nested sets; and (b) maintain the sets with the addition, subtraction or reordering of nodes.
I'd prefer them to be optimized for Transact-SQL at this time. Will be converting to Oracle later, but that's a year and a million details away.
Thanks.