Subject Re: [Firebird-Architect] Re: Full Text Search
Author Milan Babuskov
Roman Rokytskyy wrote:
> Lester, let's assume we have this full-text feature. How do you want
> to use it? Please sketch some queries.

SELECT table_name, record_id, title, details
FROM movie, actor, director
WHERE any_field HAS TEXT SIMILAR TO 'usual suspects'
ORDER BY relevance_factor DESC;

Of course, it's not that simple. For example, movies and actors have
M:N relationship in table "cast". I believe relevance_factor should be
computed by number of required terms found, plus it should honor
foreign key relations between tables, giving more relevance to
connected records that both found a term. For example, if you do the
above search for 'suspects spacey' your top hits should be "The Usual
Suspects" and "Kevin Spacey".

There are some things that Google does that make it special. AFAIK,
the pages that are refenced by other pages get better ranking. Also
text in larger font, bold, and otherwise accented gets higher points,
etc. Of course, only they know the exact algorithm. :)

Milan Babuskov