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: Setting parameters at Hierarchy within a hierarchy

Re: Setting parameters at Hierarchy within a hierarchy

From: karl wettin <wettin_at_users.sourceforge.net>
Date: Tue, 4 Mar 2003 02:24:23 +0100
Message-ID: <20030304022423.6657a240.wettin@users.sourceforge.net>


On 3 Mar 2003 14:54:38 -0800
harry827_at_yahoo.com (hs) wrote:

> > > This is an important design consideration for me since there will be
> > > other parameters that may follow a similar pattern in the future and
> > > performance is very important.
> >
> > Have you considered using a hierachial database (LDAP, et al)?
>
> This is coming too late in the game. We already have our product
> developed in Oracle and this is coming in as an enhancement.

It's not impossible to run booth an LDAP and the current RDB, even if there are associations between the two contexts. I would even say it saves you quite some clockticks compared to the nested SQL. RDB:s just aren't fitted for heirachial design.

If you don't want to consider that option, Oracle actually offeres some kind of heirachial plug that could help you out. I don't know more about it than it exists. If you look in to it I would be intrested in a review.

But if it's only a few nodes in your tree and you need a solution now, I would probably end up with a quick and dirty solution where each node is represented as its own table. Since you're asking for performace and easy extention of the implementation in the future, don't do it that way.

karl Received on Mon Mar 03 2003 - 19:24:23 CST

Original text of this message

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