Re: Ranking problem w/FreeTextTable

From: John Kane (jt-kane_at_comcast.net)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 07:14:18 -0700

Kris,
Are you using CONTAINSTABLE or FREETEXTTABLE to return the RANK value? Could
you post your exact query and the rank results? You should also review the
last paragraph in the SQL Server 2000 title "Full-text Search
Recommendations" on RANK as well as the recently released Yukon (SQL Server
2005) white paper "SQL Server "Yukon" Full-Text Search: Internals and
Enhancements" as it describes in more detail what the RANK formula is for
Yukon. While this white paper is specific to Yukon, and the exact RANK
formula for SQL Server 2000 most like is somewhat different, it does explain
in more details how ranking works under "Ranking". Although, I would
disagree with the statement "The science of ranking is far from mature" as
the ranking as used in traditional IR systems is very mature and based upon
years of academic research.

Regards,
John

"Kris Kimbrough" <KrisKimbrough@discussions.microsoft.com> wrote in message
news:A8011BA5-7FBA-481A-BFCC-0D1441449830@microsoft.com...
> We are having problems with the ranking of search results being incorrect.
The index is built on 1.6 million rows.
>
> An example of the issue is the user searches for three words 'cowboys hat
dallas'. Searching for 'Cowboys' alone brings back 21 results, 'Dallas'
alone 460 results and 'hat' alone 1338 results. So the highest ranking
result returned has only the word 'hat' (3 times), neither of the other
words. The first product that contains all three words is ranked 8th.
>
> Any explanation for why these results? I've read that the ranking of
common terms would be scored lower, so these results make no sense to me.
Any help or suggestions would be appreciated.
>
> Environment: SQL Server 2000 - SP3
>

Relevant Pages

  • RE: How EXACTLY does Indexing Service determine rank
    ... the point that they are adjacent becoming a phrase and raising the rank ... The ranking mechanism is weighted so that the more highly inflected ... the linguistic engine and ranking algorithm ... Indexing Service is based on ranking formulas that are used everywhere from ...
    (microsoft.public.inetserver.indexserver)
  • Re: Increasing your PAGE RANK
    ... >> Participating in link schemes is a way to increase page rank, ... so the site 'spam ranking' will ... I have a "useful links" page on one site for people who want ... > to do a link exchange. ...
    (alt.internet.search-engines)
  • Re: Ranking problem w/FreeTextTable
    ... the master Merger is also done after full and incremental populations. ... ranking values are only correct after a master merge has been completed. ... > to start returning incorrect rank results. ... While this white paper is specific to Yukon, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Integrating results from different pages? (No luck w/ INDEX &
    ... ranking for every player that has a ranking. ... Most of my source come in the format "Rank. ... Lastname" match a cell that is a formula that gives the same result? ... > Now you have all the names in sheet3 ...
    (microsoft.public.excel.misc)
  • RE: Ranking different groups in one column
    ... Thank you for the ranking different groups within one colmun formula: ... As you see, three regions, a bunch of store names and scores. ... Gary''s Student - gsnu200776 ... a.n.other user from this datasheet and just 'pulling' the rank no into the ...
    (microsoft.public.excel.misc)
Quantcast