On Thu, Mar 17, 2011 at 1:49 AM, Otis Gospodnetic <otis_gospodne...@yahoo.com> wrote: > The dreaded parent-child without denormalization question. What are one's > options for the following example: > > parent: shoes > 3 children. each with 2 attributes/fields: color and size > * color: red black orange > * size: 10 11 12 > > The goal is to be able to search for: > 1) color:red AND size:10 and get 1 hit for the above > 2) color:red AND size:12 and get *no* matches because there are no red shoes > of > size 12, only size 10.
What if you had this instead: color: red red orange size: 10 11 12 Do you need for color:red to return 1 or 2 (i.e. is the final answer in units of child hits or parent hits)? -Yonik http://lucidimagination.com
