Search database

Question

Say I have a large database with product information. I want to create a search engine for this database, preferably with indexing and auto-correction features. How should I do it? Are there any good libraries that I could use, so I don't need to start from scratch with basic SQL? Just some basic recommendations, links, will be highly appreciated.

I am familiar with PHP, C #, VB and Java, but I know little about databases.

Answer 1

If your product database creates web pages, you are best off using lucene or htdig . Those will do a really good text search based on your content.

Otherwise, you will want to search the large fields of your database using the full text search capabilities in mysql .

To perform autocompletion, you will need a standalone indexing process that works similarly to Google. Create another table called wordIndex. It contains words and the number of occurrences in your db product.

When the user starts typing, you do ajax search in this table and based on autocomplete.

Answer 2

mySQL FULLTEXT , ( , ), Solr ( Lucene) Sphinx. mySQL. .