lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Lu" <>
Subject Re: Lucene Seaches VS. Relational database Queries
Date Thu, 13 Apr 2006 21:37:48 GMT
Depending on what you are trying to search. Let's say your table A is
the table with the "real" content, and B and C are your lookup table.

You should build one index in this case. And select A's content
together with B and C's lookup value into the documents.

I strongly recommend you take a look at DBSight. You can create the
index or several different index super easily. And you can test with
different index structure with out any coding.

BTW: It's not really user friendly to let users choose a drop-down.
You can try DBSight's narrowBy feature. Like the one you will see

Chris Lu
Full-Text Lucene Search on Any Databases
Faster to Setup than reading marketing materials!

On 4/13/06, Ananth T. Sarathy <> wrote:
> No we do have drop downs selects that would allow for the substitution, but
> we also have a free text fields to allow the user to search. That solution
> would I think work for the DB query replacement, but you would need a
> regular non underscored field to allow for free text.
> On 4/13/06, Erick Erickson <> wrote:
> >
> > Well, that's a problem you must already be solving. Somewhere, you have to
> > construct your DB query and recognize what constitutes a "term". From your
> > previous mail, you imply you can construct this query...
> >
> > select count(distinct Crew_ID) from Crew_TItles where Title="Producer"
> >
> > Where did you get "Producer"? Presumably you have some rules for turning
> > the
> > form-entered data into a SQL query, I assume just the contents of the
> > entry
> > box. So I don't see why it's at all hard to replace all spaces with
> > underscores and send the result term to Lucene. Whatever your process, you
> > have to decide what user entries you use for Title="blah". When you've
> > isolated the "blah", just do the substitution.
> >
> > Or I completely misunderstand your problem, which is entirely possible.
> >
> > Best
> > Erick
> >
> >
> --
> Ananth T Sarathy

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message