RE: Full Text Searches

["Richard J. Grundy" <RickGrundy@xxxxxxxxxx>]

Martin,

Lucene looks perfect for what I am trying to accomplish. Thank you so
much for pointing me in that direction. And Toby, great job on McKoi, I
continue to use it and always consider it when starting new projects.
Thanks again.

Respectfully,

Rick Grundy
RickGrundy@AVTECH.com

````````````````````````````````````````````````````````````````````````
``````
AVTECH Software, Inc.   *    Newport, RI
www.AVTECH.com         *    888.220.6700
````````````````````````````````````````````````````````````````````````
``````


-----Original Message-----
From: mckoidb@mckoi.com [mailto:mckoidb@mckoi.com] On Behalf Of Martin
Cordova S.
Sent: Thursday, May 15, 2003 8:40 AM
To: mckoidb@mckoi.com
Subject: Re: Full Text Searches

There is a famous and robust search engine product, 100% java, open
source
and free, hosted at jakarta.apache.org, called Lucene.

Toby, I am not sure but I think that a few months ago someone offered an
extension for McKoi that would solve the problem of
text/search/indexing? Do
you remember?

Regards,
Martin


----- Original Message -----
From: "Richard J. Grundy" <RickGrundy@AVTECH.com>
To: <mckoidb@mckoi.com>
Sent: Thursday, May 15, 2003 9:31 AM
Subject: RE: Full Text Searches


> Great. Thanks Toby.
>
> Respectfully,
>
> Rick Grundy
> RickGrundy@AVTECH.com
>
>
````````````````````````````````````````````````````````````````````````
> ``````
> AVTECH Software, Inc.   *    Newport, RI
> www.AVTECH.com         *    888.220.6700
>
````````````````````````````````````````````````````````````````````````
> ``````
>
>
> -----Original Message-----
> From: mckoidb@mckoi.com [mailto:mckoidb@mckoi.com] On Behalf Of Tobias
> Downer
> Sent: Thursday, May 15, 2003 12:39 AM
> To: mckoidb@mckoi.com
> Subject: Re: Full Text Searches
>
> Richard J. Grundy wrote:
> > Does McKoi support full text searching of a column in a table? For
> > example, if a table called 'content' has a column called
> 'description',
> > could the following query be performed?
> >
> > SELECT * FROM content WHERE contains(description,'  "search text"
')
> >
> > Is 'contains' a valid query parameter? Basically, I am looking for
> > search engine type behavior where a couple keywords could be used to
> > search the text stored in tables in the database. Any feedback and
> query
> > examples would be greatly appreciated. Thank you.
>
> Hi Rick,
>
> You can use the following query to search for a string in a column;
>
>    SELECT * FROM content WHERE description LIKE '%search text%'
>
> However this requires a full scan of the 'description' column and may
be
>
> inefficient if you have a lot of data.  There are efficient algorithms
> and data structures for implementing free text search engine
behaviour.
>   I recommend you search the internet for some ideas.  The Mckoi
mailing
>
> list archives implements text search with a unique word dictionary and
a
>
> word/document relationship table.
>
> Toby.
>
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com
>
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com
>
>



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com