n-ary trees and complex objects in SQL

P

PrOpHeT

Member
Joined
Sep 1, 2004
Messages
18
Has any one ever tried to do such a thing? We have been researching this in effort to make an open ended class/sub-classification system for one of our projects, rather than having to flatten the objects and normalize them into relations we have approached this from a n-ary tree perspective. Really cool stuff, however the foremost authority on this seems to be Mr. Joe Celko and his work on the subject from 96 and then disturbing part is that it seems so elegantly simple despite its relative complexity and makes us wonder why there have not been more references to it in the last 10 years.

Has anyone here had any experience with this and its real world?

Thanks.
 
Back
Top