search engine for text blobs

[Alan Goodman]

Hi,

I was wondering how you people have implemented search engines on text
blobs.

For example, I am going to keep track of trouble calls from the software
support department. I will save the notes from each support call into a
text blob that is part of the support call record.

I would like some way of searching those notes in the blobs for a specific
string, like "AIX" or "-408".

I really don't want to select each blob out of the database and then
"grep" it. That might be a little slow. 8-)

I could generate a keyword list from the notes, and search using the
keywords, but I wanted to see if anyone had a better way?

So, anyone have a better way?

Thanks,

Alan
------------------------------------------------------------------------------
Alan Goodman | Data Systems Support
Senior Systems Analyst | A Client Technologies Company
internet : al...@dssmktg.com | 1228 Shelly Ct.
Voice 714-771-0454 Fax 714-771-3028 | Orange, CA 92668 USA
------------------------------------------------------------------------------

[Chris Drauch]

Alan Goodman wrote

>
>I was wondering how you people have implemented search engines on text
>blobs.
>
>For example, I am going to keep track of trouble calls from the software
>support department. I will save the notes from each support call into a
>text blob that is part of the support call record.
>

>I really don't want to select each blob out of the database and then
>"grep" it. That might be a little slow. 8-)
>

>So, anyone have a better way?

Don't know if this is a better way. What about using WAIS? Write the blob
through a SP, get a uniqe field (or a serial), write a text file containing
your blob. Those text file must be indexed by WAIS, then delete it. If you
start a search against this WAIS database, the (temporary) file name will be
returned and you can easily find the blob using the return value as unique
field.

--
Chris Drauch
......................................................................
. c/o DRAUCH Ges.m.b.H. Tel. 43/ 3135/46387-0 .
. Gewerbestrasse 5 Fax 43/ 3135/4638728 .
. A-8071 Hausmannstaetten EMail c...@xteam.co.at .
......................................................................