Re: Oracle IntermediaText

From: Thomas Hesse <thomas.hesse_at_team.xtra.co.nz>
Date: Tue, 26 Feb 2002 09:46:43 +1300
Message-ID: <3C7AA2B3.64B80506@team.xtra.co.nz>

Hi,

from the Intermedia Text side you can index documents via FILE_DATASTORE or URL_DATASTORE, that
means you have a table like this

filename-table

---

/remoteserver/documents/docu1.pdf
/remoteserver/documents/docu2.pdf

or
URL-table

---

http://remoteserver/documents/docu1.pdf
http://remoteserver/documents/docu2.pdf

Then you can build an Text Index on it and retrieve the filenames from the other database via a database link (select filename from table_at_remote where contains(index,'token')>0;

You have then write an application which inserts/updates the table if there are any changes in the files.

I recommend to use 8.1.7 with latest patchset. (pdf 1.3) If you have pdf 1.4 you have to wait for 9i Version 2.

Cheers
Thomas

S wrote:
>
> Hi,
> I want to use Oracle IntermediaText.
> I have files (in PDF) management server but I also want to enable full-text
> searching so I decided to use Intermedia to keep paths to files in Oracle
> DB. My Management System would be able to take an search parameters, post
> query to DB, get paths as answer and show documents to the user.
>
> But I have technical question: can I set both servers on separated machines?
> I would like to have a database with indexes of files on one machine, files
> on second and management systems installed on clients.
>
> What do You think of it?
> I would be greatful for advices.
>
> Thanks!
> Maciej
Received on Mon Feb 25 2002 - 14:46:43 CST