aspose file tools*
The moose likes Struts and the fly likes Database search Engine in Struts 2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Database search Engine in Struts 2" Watch "Database search Engine in Struts 2" New topic
Author

Database search Engine in Struts 2

Abhilash Chander
Ranch Hand

Joined: Oct 18, 2009
Posts: 39
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.
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

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.
Abhilash Chander
Ranch Hand

Joined: Oct 18, 2009
Posts: 39
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
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

Lucene can search anything that's indexable, including things in databases.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database search Engine in Struts 2