File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database search Engine in Struts 2

 
Abhilash Chander
Ranch Hand
Posts: 39
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 12617
IntelliJ IDE Ruby
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 39
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 12617
IntelliJ IDE Ruby
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Lucene can search anything that's indexable, including things in databases.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic