Re: Generic Modeling

Based on the structure you presented, and assuming that the hiearchy can be expanded to several car manufacturing companies and their assets, how hard would it be to ask the following question in Xdb?

 "List the plant names of companies that have line units with the same type of equipment, provided that the cities where the plants are located are not in the same city and that the number of plant floors exceeds three. List the results in a structure that is representative of company name, plant name, plant location, number of floors, and line units per floor."

Is there a data access language or syntax that would allow a somewhat rapid construction of this query? Or would it involve a degree of hard-coding? Would performance be degraded in terms of access paths since the query doesn't seem to follow the natural hierarchal structure? And if so, can indexes be modified or added to enhance performance in a flexible way?

An example of how the query would be manifested in Xdb would be great!

TIA, Dan

> I meant along the lines of "in arrangements that I cannot predict
> ahead of time". For example, a manufacturer like GM owns various
> pieces of equipment. The equipment can get moved around to various
> parts of a hierarchy that might represent GM and the hierarchy itself
> changes over time.
>
> MfgFolder
> GM
> NorthAmerica
> USA
> MI
> Detroit
> VortexEnginePlant
> Equip1c[Equip]
> Plant1
> Floor1
> PistonArea
> Equip1d[Equip]
> ForgingCell
> Line1
> Equip1a[Equip]
> Equip1b[Equip]
>
> www.xdb1.com/Example/Ex046.asp
Received on Sun Jan 06 2002 - 04:43:04 CET