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

Home -> Community -> Usenet -> c.d.o.server -> how to model object containment in relational

how to model object containment in relational

From: Asya Kamsky <asya_at_bayarea.net>
Date: Wed, 17 Mar 2004 21:32:07 -0000
Message-ID: <105hgunh5lci463@corp.supernews.com>


I have a list of base_objects and containers (a table for each: object_table (id, name) and container_table (id, name).

Containers contain objects. That's simple to model. However containers can also contain containers. Is there a cleaner way to represent that relationally than
join_table (container_id, container_or_object_id, flag) where flag says whether the containee is itself container or object.

Is there a good newsgroup for this type of question? Some sort of relational theory and modeling newgroup? :)

--
Asya Kamsky

Come see my band, Monday March 29th, 11pm(sharp) @ Tongue and Groove in SF
http://www.evite.com/asya@bayarea.net/rock
Received on Wed Mar 17 2004 - 15:32:07 CST

Original text of this message

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