[Data-modeling] Products with ingredients

[Gordon Mackenzie]

On Jun 16, 2009, at 3:10 PM, Jeff Prucher wrote:

> I've been working on a model for Products With Ingredients (catchy  
> name, eh?) over on sandbox:
> <https://www.sandbox-freebase.com/view/business/product_with_ingredients 
> >
>
> It's pretty minimal, with two types: Product and Ingredient. The  
> "product with ingredients" type can be used both with a consumer  
> product (<https://www.sandbox-freebase.com/view/guid/9202a8c04000641f800000000c461acb 
> >) or with a brand or product line (<https://www.sandbox-freebase.com/view/en/corn_flakes 
> >), depending on where the ingredients make the most sense (i.e.,  
> all packages of Corn Flakes have the same ingredients, so putting  
> the type at the Brand level makes the most sense).
>
> There are two things I'm seeing with my example data that don't  
> quite work in the model, though, and I'm not quite sure what the  
> best way to resolve them is. One is the Corn Flakes ingredient  
> "Milled corn". Should the Ingredient topic be "Milled Corn", should  
> it just be "Corn", or do we need a CVT to allow people to modify the  
> ingredient ("Corn", "milled")?  The toothpaste has this ingredient  
> also: "sodium lauryl sulfate (from coconut oil)", which I think is  
> the same issue.

I like CVT, ingredient, how it is treated/processed

> The other one is ingredients within ingredients: the toothpaste tube  
> lists this ingredient: "fruit extracts (strawberry, banana, and  
> other natural flavors)". Treat as four separate ingredients, and  
> punt on the relationship? I'm tempted toward this one -- if you're  
> looking for potential allergens, or animal-based ingredients, or the  
> like, you don't care whether the offending item is in a main  
> ingredient or is an ingredient of an ingredient.
>

All ingrediants...

Maybe a property for common allergens contained by this product ( a  
great reverse in real life for my wife is the feature of Whole Foods  
stores as they clearly label for Gluten-Free by using a pale green  
special border around the price sign?)?

Allergens: Shellfish, peanuts, dairy products (lactose?), gluten, etc.

> Thoughts?
>
> Jeff
>