A few questions re Valentina compared with SQLite

[Ruslan Zasukhin]

On 4/19/08 5:47 PM, "bigbird" <greg at hawkmount.com> wrote:

> Hi Ruslan,
> 
> Just to clarify, I have a column that could contain the following
> dummy text records:
> 
> 1 The man had a HAT.
> 2 The HAT was on his head.
> 3 HAT day at the school was a great success.
> 4 We all saw tHAT the beach was crowded.
> 5 He was as mad as a HATter.
> 6 He did not know wHAT he was talking about.
> 7 HATs are very popular this year.
> 
> If the user types 'HAT' into the search field, I would like to return
> records 1, 2 and 3 but NOT records 4, 5, or 6.
> 
> There will never be just a single word in the column, so '= hat'
> won't work (as far as I know) - the column may contain well over a
> hundred words.

Right,

But IndexbyWords split our string to 100 words and add each of them into
index.

> Ideally, also I would like to be able to return simple 'plurals' like
> record 7 when 'HAT' was the word searched for.

Valentina not support this directly because this is language dependable.
 

> I would also like to offer an option to the user that would find HAT
> on its own OR embedded in another word like wHAT if they chose to do
> so (SQLite ONLY offers this choice, as far as I can see).

I doubt ...

Try in SqlLite this also   fld LIKE 'hat'

 
>> IndexbyWords build special index that keep separate WORDS.
>>     then search as  WHERE fld = 'hat'  should find EXACT matches

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]