Re: vehicle to autoparts relationships
Date: 7 Dec 2006 09:40:07 -0800
Message-ID: <1165513207.865135.313590_at_80g2000cwy.googlegroups.com>
Neo wrote:
> At extremes, there are two type of solutions to your problem in RMDBs.
> One solutions ends up with many specialized tables. The other solution
> ends up with fewer generalized tables with recursive joins. Each has
> advantages and disadvantages. You will have to find the right balance
> for your specific requirements.
And the third alternative is to use sets (where atomic parts are elements, and the part assemblies are sets). No recursion is needed then! The ancestor chain query is a relational division, but in a typical autoparts shop application, why would one like to know what chain of assemblies includes an atomic part?
BTW, it seems like your replies progressed from crankish to knowledgeable -- congratulations! Gonna miss your db4d stuff. Well, maybe not:-) Received on Thu Dec 07 2006 - 18:40:07 CET