Does RANK and weightage goes hand in hand 
Author Message
 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 document/row compared with the
frequency of the
word occuring in all documents/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



Wed, 21 Dec 2005 12:00:05 GMT
 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 document
rank is proportional to the number of times the term occurs in the document
and inversely proportional to the number of documents in which this term
occurs. Then the score is normalized by the document length. Generally the
more often "backstreet" occurs in the document, 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.


Quote:
> Hi,
> ranking is determined by a formula that accounts
> for the frequency of the word in the document/row compared with the
> frequency of the
> word occuring in all documents/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



Thu, 22 Dec 2005 01:39:17 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL Server 2000 Hands On Advice

2. Splitting a large query up into slices, and handing them off one by one

3. Stock (goods in hand) program writen with vb

4. Microsoft Sql Server Training : Hands-On, Self-Paced Training for Microsoft Sql Server Version 6.5

5. restore hands

6. Second Hand sql server?

7. Hand needed with t-sql

8. Error handing

9. Right hand alignment

10. DBA Stuff handed over to ME!

11. Novice would appreciate a hand


 
Powered by phpBB® Forum Software