DBSight is a J2EE web application that can quickly create a full-text Google-like or Amazon-like search engine on any database or application. Average under 0.02 seconds for in-memory mode search on 500M data. Used in production websites.
You can create a database search in 3 minutes!
http://wiki.dbsight.com/index.php?title=Create_Lucene_Database_Search_in_3_minutes
Current release 1.3.8 include:
* json template and xml template can automatically generate all displayable column with formatting
* added a load balancing helper: ping a url when its index is ready
DBSight provides a turn-key solution to design Lucene full-text search on any database, and provide many convenient features for both admins and end users. No java coding!
* Design Time:
Integrated index designer to flatten any database objects by SQL
Integrated results designer, Velocity templating
* Daily Maintenance
Incremental Database Indexing
Integrated Database Crawler, Scheduler
* High Concurrency
Separated indexing process
Multiple Searching thread to meet consumer-website level production websites.
* Searching Results
Google-like results, with highlighting, plus ordering
Amazon-like Categorized-results with counts
Hierarchical-Facet Search
Here is one demo, 1.7 million CD albums information by freedb.org provided data.
http://search.dbsight.com/
Here is a detailed step-by-step tutorial on how the demo search is created.
http://www.dbsight.net/mediawiki/index.php?title=Step_by_step
Resources:
Site:
http://www.dbsight.net
Step by step tutorial :
http://www.dbsight.net/mediawiki/index.php?title=Step_by_step
Demo Search on freedb.org's data:
http://search.dbsight.com/