We're investigating migrating from an RDMBS to Solr to add text search support, as well as, offload the text storage from our RDMBS (which is arguably not designed for this kind of stuff).. While whiteboarding the basic requirements, we realized that we have some 'special' requirements:
Basic setup: - A subset of data is immutable and is perfectly suited to be stored in Solr - A subset of data is dynamic and changes frequently (should still be stored in an RDBMS) Question: 1) We need access to dynamic data stored in our RDBMS to perform filtering 2) When Solr returns its result set, we need to augment the results with meta-data from our RDMBS For (1), based on my research we're in fairly standard territory: implement a custom Filter, or a ChainedFilter to return a bitmask based on an RDBMS query. However, can this step be somehow coupled with (2), where the data we retrieved in (1) is also appended to the result set? With proper caching policies, I don't think this implementation will be all that painful. (Sanity check?) So having said that, are there any features or mechanisms in Solr/Lucene that you would recommend / are there any best practices we should be aware of to help us with the migration? Appreciate the help. ig -- View this message in context: http://www.nabble.com/Solr-%28text%29-%3C%3E-RDMBS-%28dynamic-data%29---best-practies--tp17093678p17093678.html Sent from the Solr - User mailing list archive at Nabble.com.
