1. For theserverside.com, tried on Jun/09
Announcing DBSight - Search Engine on any relational database
DBSight is a deployable j2EE web application that can create one or several search engine on any JDBC relational databases.
Is Google's search always the best? No!
You can beat it with something Google can not have: your own database!
With DBSight, you can quickly turn your database into a search engine that rivals Google or Yahoo!
With DBSight, the search on your database usually is under one second.
Here is one demo, 1.7 million CD albums infomation by freedb.org provided data.
DBSight is a highly configurable platform to create search. It can crawl your database, create indexes, display search results. You can customize most of the components -- all by web interface!
DBSight is built with Lucene for searching, JDBC for crawling, and Velocity for rendering.
Here is a step by step tutorial on how the demo search is created.
Resources:
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/
Posted:
http://www.theserverside.com/discussions/thread.tss?thread_id=34464
2. For freedb.org
DBSight demo search on freedb data
DBSight is a new deployable j2EE web application that can create one or several search engine on any JDBC relational databases.
To demonstrate the search capability, DBSight created a demo search on 1.7 million CD albums infomation by freedb.org provided data.
http://search.dbsight.com/
DBSight is a highly configurable platform to create search. It can crawl your database, create indexes, display search results. You can customize most of the components, and manage the indexes -- all by web interface!
Post a question on freedb forum
"licenese on search on freedb data" June 09 2005,21:44 Last Post by: chrislu
From megari in freedb.org
With proper attribution and by publishing the imported database you should be fine. We're not very strict about this as long as the intention is clearly to keep all changes public and not misrepresenting the source of the data. So should be allowed to make such a search (which you already have) if you provide a way to download the converted database and link back to freedb and the GPL.
I've seen your news submission and I'm a bit uneasy about publishing it - especially because joerg is on vacation which prevents me from discussing this with him. To me it looks like an advertisement for your product. I understand you are anxious about letting everyone know about it, but we prefer not to advertise. Perhaps you could rephrase the submission and move some of the advertising to the search page itself? That way we could just say in the news post that you've made a search page to demonstrate your technology without going into detail. People would test your technology and should they be impressed, they may follow a link from the search result page to the DBSight main page.
Revised, Posted: June 10th, 2005
DBSight demo full-text search on freedb database
To demonstrate the search capability, DBSight created a demo search on 1.7 million CD albums infomation by freedb.org provided data.
http://search.dbsight.com/
Major difference with existing search is: Search highlighting, categorized result counts, etc.
The data will be updated when freedb.org has new data available.
3. For MySql full-text FAQ page
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
Posted by Grant Harrison on June 9 2005 10:44pm [Delete] [Edit]
Maybe a little off topic here.
Alternatively, instead of doing all full-text search within MySql
database, you can pull data out and create an index on it.
It's a much faster search.
I am using DBSight to search on 1.7million records of 1.2G data, on a P3 450MHz, 256MRam, with sub-second performance.
Taking search out of database also give you capability to customize stemmer.
4. sent to editor0406 at searchtools dot com, on Jun 9th, 2005, 2pm
sent to consult4 at searchtools dot com, on Jun 16th, 2005
Hi,
I am a Developer Manager of DBSight.com
DBSight is a deployable j2EE web application that can create one or several search engine on any JDBC relational databases.
It would be great to add DBSight to your page.
http://www.searchtools.com/info/database-search.html
More information can be found:
http://www.dbsight.net
Just ask if you have any questions.
Chris Lu
5. to lucene mail list, Jun 10th, 2005
Hello Lucene developers,
I would like to introduce myself and say thanks to Lucene contributors
and this mailing list.
We have just released DBSight 1.0, which is a J2EE application that can
create a search engine on any relational database.
You can build a vertical search website within hours if your data is in
a JDBC-enabled database.
To demonstrate the search capability, DBSight created a demo search
on 1.7 million CD albums information by freedb.org provided data.
http://search.dbsight.com/
DBSight is a highly configurable platform to create search.
It can crawl your database, create indexes, display search results.
You can customize most of the components, and manage the indexes -- all by web interface.
DBSight is built with Lucene for searching, JDBC for crawling, and Velocity for rendering.
Here is a step by step tutorial on how the demo search is created.
Resources:
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/
Feature List:
http://www.dbsight.net/?q=node/34
Chris Lu
6. some small sites
http://www.livejournal.com/users/peter_zaitsev/12809.html?view=25353
I would like you to take a look at DBSight.
It's a J2EE app, which has
a scheduler to retreive database updates by JDBC
index content by lucene
display search results on your templates
It's for any JDBC supported databases, including MySQL.
And you can try it at
http://search.dbsight.com
There is a step by step tutorial on how this search is created.
7. Prepared for theserverside.com
Search Engine DIY
For IT managers, they may have one or several databases lying around. They want to do search on the database, while the annoying search always returns "No Results Found". The "Advanced Search", if there is one, is often complicated and hard to use, performance is often slow and resource-consuming.
Why not create a search as simple and elegant as Google? Well, your reply may be, "I don't think I can do that".
Actually you can!
With DBSight, you surely can create a search engine on your database, by Do-It-Yourself!
DBSight is a free-to-download J2EE application. It has
A scheduler to retrieve database updates by JDBC
Index content by Lucerne
Display search results on your templates
Most of the customization, like content retrieval, index configuration, template design, are done via browser. You actually don't need to write any code.
Check out the demo of a CD albums search. The data is from freedb.org.
http://search.dbsight.com
Step by step tutorial explains how this search engine is built.
8. mediawiki, meta
http://meta.wikimedia.org/wiki/Fulltext_search_engines
DBSight
http://www.dbsight.net/
J2EE application
Database + Lucene + Display Template, with Scheduler
Scalable, online demo
http://search.dbsight.com holds 1.2G data, 1.7 million records
Work on live systems, new or old legacy systems, without changing existing code.
Customizable crawl, customizable indexing, customizable searching, customizable results templates
9. Google AdWords
The ads will display as:
Database Search Platform
Full-text search engine for any SQL
databases: Oracle, DB2, MySQL
www.dbsight.net
Keyword: database search
Maximum CPC: $0.05
Campaign Daily Budget: USD $1.00
10. hotscripts.com
Category: Java/Applications (ID #735)
Listing Title: DBSight
Summary: Enterprise Database Full-Text Search Engine Platform(J2EE) crawl, search, and display
Long Description: DBSight is a deployable J2EE web application that can create one or several search engines on any JDBC relational databases.
It's a highly configurable platform to create search. It can crawl your database, create indexes, display search results.
You can customize most of the components, and manage the indexes -- all by web interface.
License Information:
License Type: Free for non-commercial use
Price: $ 0
Platform: linux, windows, freebsd, osx, sun
Size: > 5 MB
Version: 1.0.7
Site URL:
http://www.dbsight.net/
Download URL:
http://www.dbsight.net/download/dbsight.war
upgraded to 1.0.9
11.
http://www.dbforums.com/showthread.php?p=4348870#post4348870
Summary: Enterprise Database Full-Text Search Engine Platform(J2EE) crawl, search, and display
Long Description: DBSight is a deployable J2EE web application that can create one or several search engines on any JDBC relational databases.
It's a highly configurable platform to create search. It can crawl your database, create indexes, display search results.
You can customize most of the components, and manage the indexes -- all by web interface.
License Type: Free for non-commercial use
Platform: linux, windows, freebsd, osx, sun
Site URL:
http://www.dbsight.net/
Scalable, online demo
http://search.dbsight.com holds 1.2G data, 1.7 million records
Work on live systems, new or old legacy systems, without changing existing code.
Customizable crawl, customizable indexing, customizable searching, customizable results templates
12.
http://www.icewalkers.com/
chrislusf2
upgraded to 1.0.9
attracted one user who created
http://techreport:8080/dbsight/search.do?indexName=legal&templateName=search&q=%2Bauto+%2B109
13. java.net
https://dbsight.dev.java.net/
14. try on TheServerSide.com, Jul 20th, 2005
DBSight releases v1.0.9 Database Search Tool
DBSight has released version 1.0.9 of its J2EE Database Search Tool.
DBSight develivers an off-the-shelf search functionality for quick and easy integration with websites, applications, intranets and portals. DBSight uses the Lucene Search API and incorporates integrated database-crawler, supports for any kind of data structure, including tables, views, and materialized views, and their combinations, supports CLOB/BLOB, supports for any legacy content systems on database, supports indexing and searching content in international languages. All features are controlled from a broswer-based administration console.
Major features:
Document ranking
Categorize search results
Highlight and Summarize search results
Scheduler to sync with database updates
RSS and Atom result feeds
Velocity based easy-to-customize templates
Search in multiple databases
DBSight is available as a Web Archive(WAR) and can be deployed to most Java Application Servers.
DBSight is available free of charge right now. Online demo is available.
15. A more generic PR release
DBSight 1.3.2 - Instant Search Engine on any database/application
DBSight is a J2EE web application that can create a search engine on any databases or applications.
With DBSight, you can turn the slow database into a Google-like search engine in 15 minutes.
Required knowledge is: simple SQL.
Just using web UI, you can configure DBSight to crawl your database, create indexes on file system, search and display search results. And you can control everything, like result ordering, ranking algorithms, display, web services.
Quick to develop
Instead of weeks or even months to develop a full-text search for your data, if you know how to use DBSight, you can easily create the full-text search literally in minutes.
Feature-rich
Besides Google-like full-text search, you can have:
* Adjust Ranking by combination of relevance and fields like product price, score, comments cout, etc
* Summarized and highlighted results
* Amazon-like Results counted for each category, and sub-category
* Order results by the field you choose
* Recent searches history
* RSS feed for latest match
* Spelling check
* Pagination of the results
* Automatic results clustering
* Multi-Server mode for Server Clustering
And you can have several database searches available in one central page. They can be different applications, or different databases like Oracle, DB2, MySQL, SQL Server, Postgres, or any JDBC supported databases. SQL-based content retrieval is flexible, versatile, and customizable.
Easy to Customize
You can choose one of existing templates to start with. You add your own logo, change the layout, and add/remove components -- all by web UI. You can render the search results similar to Google or Yahoo style, or render them like product catalog, or results that fit for mobile phones, or, if you prefer, directly jump to the most relevant match.
Easy to Integrate
With the result template based on simple Velocity macro language, you can send back the search results in HTML, XML, JSON, CSV (Comma Separated Values), or just a list of document IDs so you can process later.
Easy to Manage
With Incremental Indexing, Hot Index Swapping, DBSight is maintenance free with 100% uptime and less than 0.5 seconds performance. DBSight also has statistics for performance analysis.
DBSight is built with Lucene for searching, JDBC for crawling, Quartz for scheduling, and Velocity for rendering and result templates.
Here is one demo, 1.7 million CD albums infomation by freedb.org provided data.
http://search.dbsight.com/
Here is a 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/