Hi Andy, may be you can look at Scotas products, www.scotas.com/products. They combine the data synchronization in near real time between Oracle and Solr, and also you can consumes data during SQLQ query time with new operators and functions or direct to Solr.
Bye! 2013/3/12 Andy Lester <a...@petdance.com> > > On Mar 12, 2013, at 1:21 PM, Chris Hostetter <hossman_luc...@fucit.org> > wrote: > > > How are these sets of flrids created/defined? (undertsanding the source > > of the filter information may help inspire alternative suggestsions, ie: > > XY Problem) > > > It sounds like you're looking for patterns that could potentially > providing groupings for these FLRIDs. We've been down that road, too, but > we don't see how there could be one. The arbitrariness comes from the fact > that the lists are maintained by users and can be changed at any time. > > Each book in the database has an FLRID. Each user can create lists of > books. These lists can be modified at any time. > > That looks like this in Oracle: USER 1->M LIST 1->M LISTDETAIL > M <- 1 TITLE > > The sizes we're talking about: tens of thousands of users; hundreds of > thousands of lists, with up to 100,000 items per list; tens of millions of > listdetail. > > We have a feature that lets the user do a keyword search on books within > his list. We can't update the Solr record to keep track of which lists it > appears on because there may be, say, 20 people every second updating the > contents of their lists, and those 20 people expect that their next > search-within-a-list will have those new results. > > Andy > > -- > Andy Lester => a...@petdance.com => www.petdance.com => AIM:petdance > >
