DBSight – The Ultimate Faceted Database Search

02 Aug

DBSight Logo

Information Retrieval” as a science has attained a certain level of maturity and we are seeing a lot of companies offering nice products making use of the most advanced techniques. I recently came accross such a product that’s worth mentioning here. I was able to set it up on my pc in less than 3 minutes. It comes with a very easy to use web interface. It makes use of JDBC to retrieve data from virtually any database. You can specify an SQL query to specify the search able records. DBSight automatically retrieves the records from database, creates the search index and it can automate the process as per a schedule specified by you. The figure below shows the possibilities for search results retrieval once an index has been created.

DBSight Overview

DBSight Overview

As shown in the diagram above, the search results can be retrieved in the form of HTML, RSS or can be returned via a built in web service. This shows the kind of flexibility that has been built into the system out of the box. I followed a very nice tutorial available on the DBSight Wiki and found it very useful. You can find the tutorial here.


Tags: , , , , , , , , , , ,

Leave a Reply


  1. M Atif

    August 4, 2008 at 9:43 am

    That's very cool post. Its really amazing to built the high search in less than 3 minutes.

    What kind of configuration required on the server to use this JDBC based search and is it licensed or open source ?

  2. Abbas Ahmed

    August 4, 2008 at 9:35 pm

    It makes use of Java 5 (JRE 1.5) and it is not open source, but you can download a free version from

  3. Websites tagged "lucene" on Postsaver

    August 25, 2008 at 4:00 pm

    […] – DBSight – The Ultimate Faceted Database Search saved by spitfire14332008-08-11 – Stanford chooses Zimbra saved by […]