Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!uunet!dev!dgis!jkrueger
From: jkrueger@dgis.dtic.dla.mil (Jon)
Newsgroups: comp.databases
Subject: Re: Summary: Full Text Database Products
Keywords: full text storage retrieval
Message-ID: <768@dgis.dtic.dla.mil>
Date: 20 Feb 90 02:12:31 GMT
References: <1990Jan30.204658.1822@comp.vuw.ac.nz> <1990Feb19.235547.8915@comp.vuw.ac.nz>
Organization: Defense Technical Information Center (DTIC), Alexandria VA
Lines: 18

tony@rata.vuw.ac.nz (Tony Martindale) writes:

>Empress from Empress Software in Toronto is a relational database that
>supports arbitrarily long byte strings.    You can define your own
>SQL operators so just about any text operation should be possible.

You can't define indexing on these objects, however.  So the
operation will execute in time linear to table size.

There's nothing inherent in the relational model that prevents one from
handling user-defined types as first-class objects.  But to date no
commercial RDBMS has done so.

-- Jon
-- 
Jonathan Krueger    jkrueger@dtic.dla.mil   uunet!dgis!jkrueger
The Philip Morris Companies, Inc: without question the strongest
and best argument for an anti-flag-waving amendment.