lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Lu" <chris...@gmail.com>
Subject Re: Searching over multiple indexes with 1:m relationship
Date Thu, 28 Jun 2007 17:46:57 GMT
What you should do is denorm the 1:m relationships.

Don't try to mimic the database. If you need to, you can keep the original 2
indexes and create a third one.

-- 
Chris Lu
-------------------------
Instant Scalable Full-Text Search On Any Database/Application
site: http://www.dbsight.net
demo: http://search.dbsight.com
Lucene Database Search in 3 minutes:
http://wiki.dbsight.com/index.php?title=Create_Lucene_Database_Search_in_3_minutes

On 6/28/07, Michael Böckling <Michael.Boeckling@dmc.de> wrote:
>
> Hi folks!
>
> I know there is a MultiSearcher for searching over multiple indices, but
> my
> requirement is a bit special.
> I have two indices whose documents have a 1:m relationship. Most queries
> will only use the primary index, but some will have to look for detailed
> information in the secondary index (the index fields are of course
> different).
>
> What I plan to do:
> - first get the results from the primary index
> - then use the pk of the found documents and the additional search
> constraints to search in the secondary index
> - discard any primary results that did not match in the secondary index
>
> Is this ok, or am I completely nuts by doing that? Is there a better
> alternative?
>
> Thanks for any clues!
>
> Michael
>
>
> --
> Michael Böckling
> Java Engineer
> dmc digital media center GmbH
> Rommelstraße 11
> 70376 Stuttgart (Germany)
> Telefon: +49 711 601747-0
> Telefax: +49 711 601747-141
> E-Mail: Michael.Boeckling@dmc.de
> Internet: www.dmc.de
>
> Handelsregister: AG Stuttgart HRB 18974
> Geschäftsführer: Andreas Magg, Daniel Rebhorn, Andreas Schwend
>
> ---------------------------------------------
> Besseres E-Business.
> dmc ist die kreative Vernetzung von Agentur, Systemhaus und Service. Seit
> über 10 Jahren entwickeln und realisieren wir zukunftweisende und
> erfolgreiche E-Business-Lösungen. Zu unseren langjährigen Kunden zählen
> neckermann.de, Kodak und Telekom Training.
>
> dmc auf Platz 8 im aktuellen New Media Service Ranking.
> Als inhabergeführte und netzwerkunabhängige Agentur gehören wir mit einem
> Umsatz von 13,50 Mio. Euro zu den Top 10 der erfolgreichsten New Media
> Dienstleister in Deutschland.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message