Re: A new approach to storing ordered hierarchical data in RDBs.

> I've discovered a new approach to storing ordered hierarchical data in RDBs.

Looks interesting. Below is a similar example using dbd (non-RDB). I would be interested in making comparision with this example or its extentions.

(; Create persons)
(new 'king 'person)
(new 'jones 'person)
(new 'scott 'person)
(new 'adams 'person)
(new 'smith 'person)
(new 'blake 'person)
(new 'allen 'person)
(new 'marie 'person)
(new 'clark 'person)
(new 'gable 'person)

(; Create verb to relate things in hierarchy)
(new 'employee 'verb)

(; Create employee hierarchy)
(create king employee jones)
(create jones employee scott)

(create king employee adams)
(create adams employee smith)
(create smith employee blake)

(create king employee allen)
(create allen employee marie)
(create allen employee clark)
(create allen employee gable)

(; Find all employees of king)
(; Returns jones, scott, adams, smith,

   blake, allen, marie, clark and gable)
(selectRel king employee *)

See www.dbfordummies.com/example/ex007.asp for another similar example. Received on Tue Nov 21 2006 - 17:39:56 CET