|Subject||Re: [Firebird-Architect] Indexing tales - part 1 - Siblings|
> >> Historically, database guys don't "get" search. You're never going toa
> >> get any where trying to convince them you have a better way to handle
> >> the index (I don't think you do) until you convince them that there is
> >> difference between full context word search and "containing". Goodluck.
> >>And *manch - is that allowed?
> > Ji,
> > how would you handle partial word searching with <table, field, record,
> > word position>?
> > eg: a search for "and" could/should return "Gandalf"
> That's not a reasonable thing to ask for (try it with Google, for
> example). It is reasonable to ask for a root word search ("manch*" for
> Manchester), that is easy to do.
> Taking your example further, "and" will almost always be a "stop" word"and" was just an example.
> ignored my searches. Falcon searches for "jim and ann" by finding
> candidates "jim * ann" then checking each for an "and" in the index with
> the correct word position.
> Finally, things like depluralizing make sense to do in a preprocessingRight, indeed.
> step rather than in the index.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!