How to handle unstructured data with Oracle 7

From: Felix Honold <100551.3551_at_compuserve.com>
Date: 1996/09/05
Message-ID: <322EF716.1930_at_compuserve.com>#1/1


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 Received on Thu Sep 05 1996 - 00:00:00 CEST

Original text of this message