[Data-modeling] Products with ingredients

[Jeff Prucher]

----- "Alec Flett" <alecf at metaweb.com> wrote:

> From: "Alec Flett" <alecf at metaweb.com>
> To: "Freebase data modeling mailing list" <data-modeling at freebase.com>
> Sent: Tuesday, June 16, 2009 3:51:48 PM GMT -08:00 US/Canada Pacific
> Subject: Re: [Data-modeling] Products with ingredients
>
> On Jun 16, 2009, at 3:47 PM, Kurt Bollacker wrote:
> 
> >>>
> >>
> >> This is probably a good guideline - if there are sub-ingredients, 
> 
> >> they
> >> should probably be broken out when the data is added.  The only
> >> problem here is that ordering matters -- on the original contents
> >> list, there is more of item N than item N+1 in the product.  If
> you
> >> break them out, it's unclear where they should end up in the list.
> >
> > This is exactly the same problem that Kirrily has to solve with her
> > Recipe schema.  It seems like the ingredient type should work for
> both
> > products and recipies.
> 
> +1
> 
> I know data input is simpler without the CVT, but at the same time  
> having "Amount" in some for makes it much easier to query for  
> "products which have > 10g dextrose per serving" - you can't do that 
> 
> if you just say that the ingredient amounts can only be inferred by  
> their index within the product.

There is a separate model for nutritional information, which applies only to food products. The amount of dextrose in a serving can't be determined from a list of ingredients, since you'd have to know the quantity of dextrose in each ingredient as well as the quantity of each ingredient in the product.

Jeff