lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From igrigorik <>
Subject Solr (text) <> RDMBS (dynamic data) - best practies?
Date Wed, 07 May 2008 00:26:17 GMT

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
 - A subset of data is dynamic and changes frequently (should still be
stored in an RDBMS)

 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.

View this message in context:
Sent from the Solr - User mailing list archive at

View raw message