Products :: Database Indexer

Description

Database Indexer is an easy to use application that makes it possible to quickly search your relational database content using full-text search. While some databases have built-in full-text search support, they generally don't match products like Lucene or Solr in terms of accuracy, speed, and scale. Our database indexer can index your database in bulk or incrementally, thus allowing frequent indexing without high overhead.

Business Value / Benefits

  • Database Indexer makes it possible to run (complex) full-text search queries on your data

Do You Need It?

How do you determine if Database Indexer is for you? The following are some of the things you could watch:
  • you need more flexible and powerful search functionality
  • you are not satisfied with quality of search results
  • you want faster search
  • your database is using too many resources to support full-text search (e.g. lots of disk space)
  • you would like to handle more data with less hardware and scale horizontally
  • you want happier users

Integration

Database Indexer works by retrieving data from a relational database using JDBC. Retrieved data is converted on the fly to the format suitable for full-text indexing and sent to either Solr or Lucene indexing and search backend. The indexer can be run from the command line, from a scheduler, or embedded into another application.

FAQ

Q: Which databases are supported?
A: Database Indexer has been tested with MS SQL Server, MySQL, and PostgreSQL, and should also work with Oracle and other databases accessible via JDBC.
Q: Are any kind of database modifications required?
A: Database tables need columns with added/modified dates and a boolean column for soft deletion.