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: David Cressey <david_at_dcressey.com>
Date: Wed, 05 Sep 2001 18:18:52 GMT
Message-ID: <g0ul7.437$Iw2.27054@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.

--
Regards,
    David Cressey
    www.dcressey.com
"watf22" <watf22_at_yahoo.com> wrote in message
news:a12de98f.0109050920.6f1668d8_at_posting.google.com...
Received on Wed Sep 05 2001 - 13:18:52 CDT

Original text of this message

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