Results 1 to 3 of 3
  1. #1
    rehinagrasia is offline Member
    Join Date
    Dec 2010
    Posts
    2
    Rep Power
    0

    Question Confusion between Lucene and MySQL fulltext search

    Hi. I am currently doing a simple newspaper clipping system in java for project. Our professor wants it to have the google algorithm search. It will not anymore scan the contents of the newspaper, just the tags (i.e, author, publisher, date etc.)

    So, I was kind of having a problem with what to really use. Its a desktop application purely written in java. The database used is mySQL. Ive been to this fulltext search and I do not know what I should use. Our professor wants it to be like google or similar to google search. I need ideas on how I could implement this. I've been through readings but sometimes I find terms I do not know... Some sites suggest Lucene to be used. But I do not know how to simply implement it in java with mysql... T_T

    I usually find codes in PHP. Im kind of beginner but I know java fundamentals. Just sometimes im having a hard time understanding the advanced. Please help, anyone?

  2. #2
    Join Date
    Dec 2010
    Posts
    22
    Rep Power
    0

    Default

    Lucene is an index based search engine and you can implement it without using SQl Server. the way Lucene works is as follows:
    - Create an index file based on criterion
    - Search on index and get results

    now, if you have records stored in MySQL and you want to implement a search a full-text search in SQL will be slower. Use the crawler approach - any new additions to the SQL, or edits to existing records should update indexes in Lucene. and thena seach can be fired in lucene.

  3. #3
    rehinagrasia is offline Member
    Join Date
    Dec 2010
    Posts
    2
    Rep Power
    0

    Default

    Thank you for pointing that out. Currently for our thesis demonstration we used the MATCH-AGAINST function of MySQL, however, trying it out we found some really perks using it like when we search "computer", it does not return "computers" or if we do "compters" it doesn't show results like "computer / computers".

    Yes, are records are stored in MySQL and all are just text. I do not really know how to use Lucene but i have tried an example and it searched from text declared in the said program, not in the sql.

    Is there any way that I can connect it to MySQL? And can it do searches like "google-search"? Thank you for your response.

Similar Threads

  1. Lucene search with French words
    By Maulin in forum Lucene
    Replies: 1
    Last Post: 08-18-2010, 06:06 PM
  2. Replies: 2
    Last Post: 03-27-2010, 10:01 AM
  3. Replies: 0
    Last Post: 11-17-2009, 02:58 PM
  4. Replies: 0
    Last Post: 06-28-2009, 02:10 AM
  5. Need help in lucene with hibernate search
    By gopalbisht in forum Java Software
    Replies: 1
    Last Post: 04-20-2009, 02:54 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •