I am looking for a an open source tool for java application which can do some of google's search functionality such as fuzzy searching, ranking, etc, but will look into rdbms records (or indexed records from rdbms) and not from a text-based index. Can lucene help me with this?
Connect to the database using JDBC and use an SQL "SELECT" statement to query the database. Then create one Lucene Document object per row and add it to the index. You will probably want to store the ID column so you can later access the matching items. For other (text) columns it might make more sense to only index (not store) them, as the original data is still available in your database.