Re: Hierarchies in the relational model
From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Mon, 20 Oct 2003 13:54:25 -0700
Message-ID: <l5Ykb.22$Rt2.193_at_news.oracle.com>
Date: Mon, 20 Oct 2003 13:54:25 -0700
Message-ID: <l5Ykb.22$Rt2.193_at_news.oracle.com>
"Paul" <pbrazier_at_cosmos-uk.co.uk> wrote in message
news:51d64140.0310200434.68c75a5f_at_posting.google.com...
> If we are speaking theoretically, how would our ideal DBMS deal with
> Does a transitive closure operator cover
> all hierarchy-based problems? Are there some other examples of common
> problems that require second-order logic and can't be solved with a
> transitive closure operator?
It doesn't seem so. One of the problem not solved even with transitive closure is enumerating all the paths in a graph like this
Edges:
tail head
---- ----
1 2
1 3
2 4
3 4
Paths:
# tail head
- ---- ----
1 1 2 2 1 2 2 2 4 3 1 3 4 1 3 4 3 4 5 2 4 6 3 4