[Data-modeling] Products with ingredients

[Jeff Prucher]

----- "Faye Harris" <faye at metaweb.com> wrote:

> From: "Faye Harris" <faye at metaweb.com>
> To: "Freebase data modeling mailing list" <data-modeling at freebase.com>
> Sent: Thursday, June 18, 2009 2:59:19 PM GMT -08:00 US/Canada Pacific
> Subject: Re: [Data-modeling] Products with ingredients
>
> 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?

I plan to add a phylogeny pattern before moving the schema to freebase.com, which should help queryability. It doesn't address the fact that topics named things like "enriched flour (that, that, the other thing)" are exceedingly ugly, however (no-one said it was called "prettybase.com", though).  I was going to post a revised schema to sandbox, with the double-phylogeny pattern suggested by Robert, but it got horribly munged in the process. I'll try to fix it, but it might not be till next week.

Jeff