Re: Hierarchy/Many to Many/Temporal data - MIND BENDER

I guess you figured out who "some people" was in my message. :)

I like the nested set model but I find it more difficult to work with and I'm trying to keep this one simple and focus on getting the queries to support the three reports done. If we can do that then yippie!

On the skill representation, are you suggesting to use some sort of path field to represent the skill hierarchy? Are there any good articles around that might suggest how I represent the skills with a Dewey system?

Darcy

"--CELKO--" <joe.celko_at_northface.edu> wrote in message news:a264e7ea.0308181533.4704515e_at_posting.google.com...
> >> (I know some people will tell me to use the nested set model but
> I'm only interested in it if the code for maintaining it is provided
> and it can be shown how to produce the reports). <<
>
> You can Google the nested sets code easily, but I would tell you to
> design a hierarchical encoding scheme for the skills, or see if one
> exists that you can steal. Ever use Dewey Decimal at the library?
Received on Tue Aug 19 2003 - 05:16:26 CEST