Fyi, block join query doesnt require denormalization, performant, but has own limitations, of course. Many to many is the most painful point. I deal with it but quite far from contributing generally applicable approach. 29.09.2012 5:21 пользователь "Biff Baxter" <tom.bren...@acmedata.net> написал:
> Hi Walter, > > I have bought into the denormalize approach. My remaining questions are > around how to > construct the denormlized view and any solr functions that would support > issues related > to a) minimizing the denormalization explosion for 3 or more tables and b) > handling many > to many relationships. > > One issue I am concerned with is, if I search for IBM and Steve Jones in my > example > above, no records should be returned. How do I manage that with the > equivalent of the > one denormalized record approach? > > I appreciate your help. > > Biff > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/need-best-solution-for-indexing-and-searching-multiple-related-database-tables-tp4009857p4011010.html > Sent from the Solr - User mailing list archive at Nabble.com. >
