SQL Server surely has some FTS (Full Text Search) facility as of 7.0 and later,
and DB2 should have something similar too (probably constrained to some
specific edition of DB2 though). Oracle has interMedia Text/Oracle Text for
this. Since there is no standard and no common solution to this problem,
each vendor solves it differently and there's no common approach.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"--B" <akshard_at_vsnl.com> wrote in message news:y9FQ8.14998$U7.170692_at_vixen.cso.uiuc.edu...
> What about SQL Server, DB2, etc?
> Do they provide this functionality or similar functionality like Oracle,
> mentioned by Thomas?
> Is it that only Oracle supports latest stuff ?!!
>
> Thanks.
>
> "Thomas Kyte" <tkyte_at_oracle.com> wrote in
> > >
> > >hi all,
> > >
> > >can anybody suggest me on how to perform search on large data(e.g.
> essay),
> > >size upto 32 kb, using DB?
> > >Should I breakup the data into # of columns,each with 2000 bytes, and
> > >search in each column , but I guess memory will be a problem because if I
> > >return 100's of rows!!
> > >Any ideas ?
> > >
> > >Thanks,
> > >
> > >A.Dave
> > >
> > >
> > >
> >
> > using interMedia text. put the data into a clob or blob (text or binary)
> and
> > index it. Then, use the contains functionality to search it.
> >
> >
> http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/inter.8
> 17/a77063/toc.htm
> > ...
> >
> > --
> > Thomas Kyte (tkyte@oracle.com) http://asktom.oracle.com/
> > Expert one on one Oracle, programming techniques and solutions for Oracle.
> > http://www.amazon.com/exec/obidos/ASIN/1861004826/
> > Opinions are mine and do not necessarily reflect those of Oracle Corp
> >
>
>
Received on Fri Jun 21 2002 - 13:18:00 CDT
