How to handle unstructured data with Oracle 7
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