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: Transitive Closure with XDb1

Re: Transitive Closure with XDb1

From: Neo <neo55592_at_hotmail.com>
Date: 12 May 2004 17:59:35 -0700
Message-ID: <4b45d3ad.0405121659.67fa8ac3@posting.google.com>


> > Could you show RDM's transitive closure equivalent?
>
> Paul said: But we can extend our DBMS by explicity including a "TClose"
> operator that takes a (two-columned) relation as its argument and returns
> a relation that is the transitive closure. Then TClose(Contains) is:
>
> whole part
> ===== ====
> universe john
> universe mary
> universe mars
> universe venus
> mars john
> venus mary

Technically, the above output using TClose(Contains) is incorrect. The parts of universe should be mars, venus, john and mary. No output row represents a person or a planet. It instead lists relationships between universe and john, universe and mary, etc.

In addition, using the more appropriate schema T_Contains, T_Planet and T_Person, how does one use TClose()? XDb1's T_Relative() works for hierarchies consisting of different kinds of things (ie Planet, Country, State, City, House, Person, including those added at run-time). In addition, how does one use TClose() to get parts of mars, since mars is not a table but a row? XDb1's T_Relative() returns parts of mars. Received on Wed May 12 2004 - 19:59:35 CDT

Original text of this message

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