Professional Web Applications Themes

Does RANK and weightage goes hand in hand - Microsoft SQL / MS SQL Server

Hi, ranking is determined by a formula that accounts for the frequency of the word in the doent/row compared with the frequency of the word occuring in all doents/rows weighted against the total number of unique non-noise words in your catalog. Does this means that if I have fulltext enabled on single column (having Product Name-- 3times + Manufacturer name ---2Times + Category name-- Once) And I search for "Toshiba Notebook" Does weightage is maximum on Product name then manufacturer name then categry Name.???? will I be having records up where Product name is "Toshiba Notebook" ? Hope to see ...

  1. #1

    Default Does RANK and weightage goes hand in hand

    Hi,
    ranking is determined by a formula that accounts
    for the frequency of the word in the doent/row compared with the
    frequency of the
    word occuring in all doents/rows weighted against the total number of
    unique
    non-noise words in your catalog.

    Does this means that if I have fulltext enabled on single column (having
    Product Name-- 3times + Manufacturer name ---2Times + Category name-- Once)
    And I search for "Toshiba Notebook"
    Does weightage is maximum on Product name then manufacturer name then
    categry Name.????
    will I be having records up where Product name is "Toshiba Notebook" ?

    Hope to see respone this time :-(

    Regards

    Abhijeet


    Abhijeet Raje Guest

  2. #2

    Default Re: Does RANK and weightage goes hand in hand

    Abhijeet,
    While you have a basic definition of RANK correct, the "spamming", i.e.,
    multiple words in one row to get a higher rank is incorrect, for example, if
    you search for "backstreet", hits for "backstreet",
    "backstreet boys" and "backstreet boys albums" are all really hits for
    "backstreet" and they are all exact match for "backstreet". The doent
    rank is proportional to the number of times the term occurs in the doent
    and inversely proportional to the number of doents in which this term
    occurs. Then the score is normalized by the doent length. Generally the
    more often "backstreet" occurs in the doent, the shorter the doc, the
    better the rank is...


    Regards,
    John
    BTW, you best source of FTS answers in the
    microsoft.public.sqlserver.fulltext newsgroup.


    "Abhijeet Raje" <abhijeet2804hotmail.com> wrote in message
    news:eOfcqSuQDHA.2432TK2MSFTNGP10.phx.gbl...
    > Hi,
    > ranking is determined by a formula that accounts
    > for the frequency of the word in the doent/row compared with the
    > frequency of the
    > word occuring in all doents/rows weighted against the total number of
    > unique
    > non-noise words in your catalog.
    >
    > Does this means that if I have fulltext enabled on single column (having
    > Product Name-- 3times + Manufacturer name ---2Times + Category name--
    Once)
    > And I search for "Toshiba Notebook"
    > Does weightage is maximum on Product name then manufacturer name then
    > categry Name.????
    > will I be having records up where Product name is "Toshiba Notebook" ?
    >
    > Hope to see respone this time :-(
    >
    > Regards
    >
    > Abhijeet
    >
    >

    John Kane Guest

Similar Threads

  1. give me a hand!!!!!
    By camilo in forum Macromedia Director Basics
    Replies: 1
    Last Post: May 7th, 06:02 PM
  2. need a hand
    By Comrade in forum Sun Solaris
    Replies: 8
    Last Post: July 26th, 09:12 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139