Hi Santosh,
We have a similar lucene-db combo here at www.uniprot.org. We have
lucene index over our datasets for searching and for database we have
simple serialized memory mapped file ("a database" in some sense).
Lucene index and database are linked through another memory mapped file
that
Basically, I need indexing only for fuzzy search on entities. So, I’m thinking
to create Index out of DB tables (for the search term) and store it on server
(cloud foundry, yet to figure out how to achieve this). Now whenever, a user
creates/updates/deletes any entity(es), I would like to perfor
2017-12-28 6:35 GMT+01:00 Kumar, Santosh :
>
> While looking up for examples of fuzzy search with Lucene, I came across
> examples that demonstrate Lucene with file system predominantly, so was
> wondering if there are any samples on ‘How to use Lucene with DB’ or if the
> Java logic remains same f
Hi Trejkaz, Evert, Riccardo,
Thank you for your inputs. We have an application which we plan to migrate to
Cloudfoundry and are yet to make a decision on DataBase with the contenders
being PostgreSQL, MySQL, HANA DB, MongoDB. In the current setup, we use HANA DB
which already has a fuzzy search
On Thu, Dec 28, 2017 at 1:07 AM, Riccardo Tasso
wrote:
> Hi,
> I am not aware of any lucene integration with rdbms
Derby has a plugin of some sort. I haven't tried it so I have no idea
what it actually does, but it looks like it adds table functions which
you could join to other queries.
https:/
Lucene just makes rdms system faster.
On Wed, 27 Dec 2017 at 17:08 Riccardo Tasso
wrote:
> Hi,
> I am not aware of any lucene integration with rdbms but I don't think it
> would be very usefull, what do you mean with "guideline for using Lucene
> with Database"?.
>
Hi,
I am not aware of any lucene integration with rdbms but I don't think it
would be very usefull, what do you mean with "guideline for using Lucene
with Database"?.
Sometimes it makes sense a database integration with lucene (for example
Neo4J and OrientDB use lucene as one of
the 2nd point above is fine, then is there any general guideline or example
that I can follow for creating a global index for the application? Also, is
there any guideline for using Lucene with Database.
Appreciate your help!!!
Thank you and Regards,
Santosh
