Re: Table Design for Hierarchical Data

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Table Design for Hierarchical Data
Дата
Msg-id 201004080956.06446.achill@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Re: Table Design for Hierarchical Data  (Yeb Havinga <yebhavinga@gmail.com>)
Ответы Re: Table Design for Hierarchical Data  (Yeb Havinga <yebhavinga@gmail.com>)
Re: Table Design for Hierarchical Data  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-sql
Στις Wednesday 07 April 2010 23:33:07 ο/η Yeb Havinga έγραψε:
> Achilleas Mantzios wrote:
> > Στις Wednesday 07 April 2010 11:06:44 ο/η Yeb Havinga έγραψε:
> >
> >> Achilleas Mantzios wrote:
> >>
> >>> You could also consider the genealogical approach, e.g.
> >>>
> >>>
> >>> The parents of any node to the root, i.e. the path of any node to the root are depicted as
> >>> parents[0] : immediate parent
> >>> parents[1] : immediate parent of the above parent
> >>>
> >>>
> >> What I have more than one parent?
> >>
> >
> > Then it is no longer neither a tree, nor a hierarchical structure, but rather a graph.
> > This a totally different problem.
> >
> My question was actually an attempt to point at the inability of what
> you call the 'genealogical approach' database design to store
> information of more than one parent.


Are you suggesting that we should change our definition of trees ADT, just because it does not
fit the mere detail that humans have two parents?
Or are you just suggesting that the "genealogical" term is inaccurate?

Take a look here: www.tetilab.com/roberto/pgsql/postgres-trees.pdf

>
> regards,
> Yeb Havinga
>
>



--
Achilleas Mantzios


В списке pgsql-sql по дате отправления:

Предыдущее
От: Yeb Havinga
Дата:
Сообщение: Re: Table Design for Hierarchical Data
Следующее
От: Yeb Havinga
Дата:
Сообщение: Re: Table Design for Hierarchical Data