Hi folks, I'm working on creating a schema which will accommodate the following (likely common) scenario and was hoping for some best practices:
We have stories which are objects culled from various fields in our database. We currently index them with a bunch of meta-data for faceting, sorting, etc. We have files which are attached to stories. So if there is a story about a restaurant, there may be a PDF of the menu attached. We would like to index the file in solr using the UpdateRichDocument handler, but also be able to associate it with the story it came from. How do people generally do this? Is there someway to "join" the two on the Solr side, so I don't store the content twice, but have a reference field to the attachment? So a search for "Egg Foo Young" could return the story about a Chinese restaurant even if the attachment which contained the text was indexed later and referenced as part of its data that it belonged to [EMAIL PROTECTED] ? Sort of like a copyTo field but copying to another record. I know the answer to that is probably no. And I know Solr is not a RDBS, but how is this generally tackled? Thanks, Jacob -- +1 510 277-0891 (o) +91 9999 33 7458 (m) web: http://pajamadesign.com Skype: pajamadesign Yahoo: jacobsingh AIM: jacobsingh gTalk: [EMAIL PROTECTED]
