Post reply

Need help or sugesstion on Implementing Full Text search or universal search facility in website.

  • November 6, 2014 at 1:50 am

    #298205

    Hello,

    I have a question as well as confusion regarding how to implement a universal search in my site And it must be give result precised up to 90%.

    Scenario is like that whenever customer come to our site he/she can search for example: Car parts

    My Table structure is like below:

    Column 1 Column 2 Column 3 Column 4 column 5 column 6 (Keyword)

    Toyota camry 2000 wheel ABC123 Toyota camry 2000 wheel abc123

    Toyota camry 2000 wheel cover 123 Toyota camry 2000 wheel cover 123

    Now i have created a full text search index on column 6(keyword)

    so whenever someone search exactly describe in column 6 it gives result

    For ex: if i search (Toyota Camry wheel) with CONTAINS Option

    Select * from mytable where Contains

    (Keyword,'Toyota and Camry and wheel')

    It gives me rows which contains Toyota Camry wheel and other rows which having wheel cover also.

    so i get multiple rows.

    because of we have very large table which contains data in millions its not to feasible to have that thing

    another thing is :

    if i search (Toyota Camry wheels) with CONTAINS Option

    Select * from mytable where Contains

    (Keyword,'Toyota and Camry and wheels')

    it won't give any result back to me which is embarrassment for me.

    because customer can search anything so if its not giving result its bad impression.

    Also i tried to use FREETEXT option

    but it gives result in combination of all this word which i searched. so its huge amount of data in result.

    So please let me know or guide me regarding this.

    Thanks & Regards

    nids

  • November 6, 2014 at 4:29 am

    #1756939

    nids,

    Looks like the problem goes beyond just mastering a query. It's rather system design problem.

    May be your site should be more interactive helping user to put his question in proper terms.

    Or you should have some extra layer (dictionary) which can handle plurals, synonyms or something.

    Can you be more specifc is your database all about Car parts?

  • November 6, 2014 at 7:12 am

    #1756989

    Hello

    i agree with you that we need to create some dictionary layer as well as there is little bit issue with system design.

    And yes our db is specific to car parts.

    If Possible,can you please send me your private email id so i can you explain more .

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply