Re: How to handle unstructured data with Oracle 7

Felix Honold wrote:
>
> Hello
>
> We are currently in a project where we need to handle a big number of
> unstructured text strings in a Oracle database and to search for single
> words within these strings ...
> The whole database with structured and unstructured data will contain
> serval GB of data.
>
> Does anybody know how to solve this problem with respect to an optimal
> query performance?
>
> Question 1:
> Is it o.k just to keep the text strings in varchar2(2000) fields or do
> we have to keep every word in its own database field for beeing able to
> create an efficient index on these words?
>
> Question 2:
> Are there any add-on tools for Oracle to cope the problem of
> unstructured data?
>
> Many thanks
>
> Felix Honold
> 100551,3551_at_compuserve.com or fh_at_innovate-it.ch

The simplest solution is to use Oracle's TextServer3 which allows text to be stored in a LONG column and provides facilities for indexing and searching.

Before TextServer, SQL*TextRetrieval was the answer. Received on Tue Sep 10 1996 - 00:00:00 CEST