Re: Hierarchical table design, child has multiple parent

  • From: Peter Robson <peter.robson@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 11 Jan 2005 14:58:35 +0000

This confuses me, as it looks as though you may have 'parent' and
'child' juxtaposed. Surely, to use the analogy of the cake, the cake
is the parent, and the ingredients are the children, rather than

No matter - if you are indeed simply dealing with one-to-many (the
classic parent-child), then, as already advised, the BOM is your first
port of call.

If you are dealing with a many-to-many situation, then take care to
resolve the dependencies in your logical model first, before you get
anywhere near any physical implementation.


On Mon, 10 Jan 2005 22:55:20 +0530, sanjay.khangarot@xxxxxxxxx
<sanjay.khangarot@xxxxxxxxx> wrote:
> Hello All,
> I wanted to create a schema in which Parent child relationship needs to be 
> maintained where a child can have multiple parents. Like addition of 
> ingredients to create a final product, where the ingredients are the parents 
> and resultant product is the child.
> How should I go to store this kind of data? My requirment also includes to 
> explode this structure and should be able to reach up to the top most parent 
> in the heirarchy?
> If anyone has any reference, from where I can pick this information please 
> advise.
> Thanks in advance.
> Regards
> sanjay
> Confidentiality Notice
> The information contained in this electronic message and any attachments to 
> this message are intended
> for the exclusive use of the addressee(s) and may contain confidential or 
> privileged information. If
> you are not the intended recipient, please notify the sender at Wipro or 
> Mailadmin@xxxxxxxxx immediately
> and destroy all copies of this message and any attachments.
> --
> //

Other related posts: