Subject Re: Google-like scoring in databases
Author Roman Rokytskyy

> The primary design question of a search engine is whether the search
> index is single field, single table, single schema, or database wide
> (Netfrastructure is database wide, so for variety Firebird would
> probably want to implement single field).

For me search happens within documents. Depending on the mapping of
the document to the relational schema I will search in whole database,
table or single column.

Hower, in addition to words, phrases, etc. St.Google uses some
meta-information that is not available in the document itself:
directed relations between documents. This meta-information is added
manually by human to link one document to another (except Wiki). And
exactly this meta-information is believed to make Google results far
more relevant than results of other search engines.

And exactly absense of this information in the database does not let
me relax. We loose this information when we map object (document)
model of the application to the relations. And this leads me to belief
that without introducing some mechanism to keep this information in
database, we will not be able to implement search in Firebird at all
(or, more correct, implementation will produce too much garbage).


Best regards,
Roman Rokytskyy