Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!ucsd!ucbvax!mtxinu!rtech!ingres!ingres.com!jpk
From: jpk@ingres.com (Jon Krueger)
Newsgroups: comp.databases
Subject: Re: Integrated relational and full text database
Message-ID: <1990Sep25.220623.22979@ingres.Ingres.COM>
Date: 25 Sep 90 22:06:22 GMT
References: <1990Sep20.213542.21478@eagle.lerc.nasa.gov>
Lines: 26

>yost@DPW.COM (David A. Yost) writes
>I want to see an RDBMS that has
>   * full text search capability
>   * fuzzy word matching
>with SQL extensions to cover the added functionality.

tprife@venus.lerc.nasa.gov (Mike Rife (Boeing)) writes:
>At last year's International Oracle User's Week in Dallas, Oracle had a 
>presentation on one of their products called SQL*Textretrieval.

Is it still the case that Oracle accomplishes this through custom
front end tools, not in the engine?

If so, I know of no products that meet David's requirements.
Nor do I expect any in the near future; "full text" is a fairly
complex data type.

If not, could Mike or somebody provide some sample queries?  E.g.
SQL to insert a document, perform a full text search for it?

-- Jon

Does not necessarily reflect the opinions of Ingres Corp.
--

Jon Krueger, jpk@ingres.com