Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Creating a Hierarchical Structure

Re: Creating a Hierarchical Structure

From: watf22 <watf22_at_yahoo.com>
Date: 6 Sep 2001 06:27:23 -0700
Message-ID: <a12de98f.0109060527.71958180@posting.google.com>


Thanks, for your answer

Unfortunetly this can't be done in this case. As their are no "positions" at all. The only thing is that it has to create something like a pyramid. Is there a way to do this ?

thanks,

Fernando

"David Cressey" <david_at_dcressey.com> wrote in message news:<g0ul7.437$Iw2.27054_at_petpeeve.ziplink.net>...
> One technique for reducing the number of inserts is to have a hierarchy for
> roles of people, not people themselves.
> One of the columns in this hierarchy table is Person_Id which is a foreign
> key. When a person leaves a role, the Person_ID is set to null, indicating
> the role is vacant. When a new person is named to the role, Person_ID is
> updated again.
>
> The other columns of the hierarchy table follow the nested set concept.
>
> Now, the only time we have to re do the nested sets themselves is when a
> new role is created. This is presumably less often than the reassignment
> of persons.
Received on Thu Sep 06 2001 - 08:27:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US