Can I index RDB with lucene?

Question

I have a RDB and I index it. But the fields in de database that are related, in the lucene index aren't. So how can I index this relation? And, of course, then can I search it well?

I search in google but I only find that I have, without the relation, I think should be something for this, but I didn't find

Thanks for response! :)

Rob Stevenson-Leggett · Accepted Answer · 2011-02-23 10:12:31Z

1

The key thing you can do in lucene is store the ID from your relational db against each index record. You need to place an amount of data in lucene from your relational store. You then fire a search off against lucene which gives you the ID or IDs of the relational records that have matched the search and you could then use that to retreive the data from your relational store.

Here's a presentation on the subject: http://www.slideshare.net/frankmashraqi/lucene-and-mysql

answered Feb 23, 2011 at 10:12

Rob Stevenson-Leggett

35.8k21 gold badges93 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bonsai Over a year ago

I found LuSql, it does the relation I was looking for, but not index like my application, I am trying to understand the LuSql code for implement my own relational indexation. If I discover how do it, I say here. Does someone have that I am trying to do?

Collectives™ on Stack Overflow

Can I index RDB with lucene?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related