[Data-modeling] Products with ingredients

[Alec Flett]

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.

Alec

>  It also seems like recipies have the same
> containment tree pattern.  A cherry pie has a "double butter crust" as
> an ingredient, but this is a recipe as well.  So products should be
> able to contain other products as ingredients.  For example, there is
> a Ritter chocolate bar that contains corn flakes as an ingedient.
>
>
>
> 								Kurt :-)
>
> _______________________________________________
> Data-modeling mailing list
> Data-modeling at freebase.com
> http://lists.freebase.com/mailman/listinfo/data-modeling