Subject Re: Document Indexing/Querying experience with FB?
Author mspencewasunavailable
--- In firebird-support@yahoogroups.com, "Tom Conlon"
<tomconlon@...> wrote:
>
> Hi All,
>
> Does anyone have experience of the above and can offer some tips?
>
> Especially with regard to extracting results using bracketed
keywords
> and phrases (nothing more fancy is required currently, but I have
> found mapping this query to SQL to be much more challenging than
first
> appears):
>
> ("TRAINEE POLICEMAN" OR "TEAM LEADER") AND
> (MONETARY OR INSURANCE AND "PRIVATE BANK")
>
> I've got a certain amount working with one of the key tables
> documented below:
>
> CREATE TABLE DOCUMENTwORD
> (
> DOCID INTEGER NOT NULL,
> WORDID INTEGER NOT NULL,
> WORDNO SMALLINT DEFAULT 0 NOT NULL,
> LINENO SMALLINT DEFAULT 0 NOT NULL,
> );
>
> The wordno column is used in locating phrases.
>
> For the sake of storing the lineno it allows for the
> recreation of a plain text version of the document.
>
> Is FB the best db for this type of task (250,000+ documents). The
full
> text features of some other db's didn't quite give me what I was
after.
>
> Any thoughts certainly appreciated.
> Tom

There's also this: http://www.ibobjects.com/ibofts.html, which may
or may not be helpful to you.

Michael D. Spence
Mockingbird Data Systems, Inc.