Hi, I am trying to develop a search engine in my website based on keywords. It will search tables in the database for matching words and will display the most relevant results. I'm using struts 2 framework. Can anybody guide me what is the most efficient way to do it. Is there any particular technology I can implement ? And what should be the architecture of the database to implement it efficeintly ? Thanks for your time and support.
That's about as broadly as that question could have been asked--without more details it's impossible to help.
Personally I'd use Lucene, but that might just be me.
Joined: Oct 18, 2009
Thanks David for giving your time. You said Lucene but isnt it just for searching pages for text and not database items. I am not sure but as much as I have read and understood about lucene. Elaborating my requirement this how it goes - there are say 10 categories. Each category has sub categories. Now there can be tens of items listed under each sub category. I want to tag each item with some keywords in the database. Now when a user enters a keyword in the search box, that keyword is matched with the tags I have created in the database. the items which have those matching tags associated with them will be displayed to the user. To futher simply it, its like the search feature on ebay. Where you enter say 'Drives' and it will display you the results like combo drive, hard disk drive etc. I hope it clarified a bit what i am trying to achieve here. thanks