Re: cross reference index

In article <909d0o$s91_at_dispatch.concentric.net>,   "Jim Poe" <jpoe_at_fulcrumit.com> wrote:
>
>
> --
> Jim Poe ( jpoe_at_fulcrumit.com )
>
> > One could automate this for the user -- parsing out spaces and
> > converting then into '%'. Not hard programming.
> >
> > I have written code that did lookup based on the initial letters -->
> > looking for 'ACME' as company_name like 'A%C%M%E%'. Again for small
> > tables (~10,000 rows) the database was more than fast enough
 especially
> > if the company_name was part of an index. Again not hard
 programming in
> > forms.
>
> Hmm, maybe I am not being creative enough with the 'like' syntax.
 What is
> 'A%C%M%E%' saying?

Is is trying to match anything with A followed by zero of more letters than 'C' followed by zero or more letters ...

It is useful to match kind-a-sorta spelling of words

       eg mcdonald would find 'mac donald', 'mc donald', 'mcdonalds'

       Oracle is of course case sensitive and would not find 'McDonald'

       Good news is that indexes can have functions like upper() to convert all data to upper for searching.

>
> >
> > Approach two is to generate the company word index table/index. You
 can
> > create the rows by doing the parsing and inserting the data into the
> > table. You might want to develop triggers -- to add/update/delete
 rows
> > in the index table when you add/update/delete company rows. Not hard
> > programming -- but a little bit of work.
>
> I thought about this, and I think it may be the closest match to the
 cross
> reference index.
>
> >
> > By the way what database has this cross referencing built-in?
> > --
>
> It is called Advanced Revelation, a Pick derivative.
>
> Thanks
>
>

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rosetta.org
              Ususual disclaimers


Sent via Deja.com http://www.deja.com/
Before you buy.