[Data-modeling] Products with ingredients

Faye Harris faye at metaweb.com
Thu Jun 18 21:59:19 UTC 2009


Jeff Prucher wrote:
> ----- "Robert Cook" <robert at metaweb.com> wrote:
>
>   
>> One solution would be to create a topic with a long name -- enter it 
>>
>> exactly as it appears on the label such as "Enriched flour - (wheat, 
>>
>> niacin, iron, baby powder, sawdust, DDT)".
>>     
>
> This would answer. Anyone else have any comments or thoughts on this before I load the schema?
>   

The main problem with this is you can't arrive at the products that use 
enriched flour by clicking on a property link from a single "enriched 
flour" topic. Rather, you have to do a keyword search for products based 
on matching all the various "enriched flour - (foo, bar, bat, baz)" 
ingredient topics with the words "enriched" and "flour". That's quite a 
loss in queriability.

The schema is fine to get us started, but we're still going to try to 
put together some phylogeny pattern in place (in the near future) right?

-- Faye


More information about the Data-modeling mailing list