Keyword Searching

Keyword Searching

Post by Mike Murph » Tue, 23 Apr 1996 04:00:00

Has anyone written a database that has a field containing keywords?  If
so, what is the best SQL Statement to search on that field?



Keyword Searching

Post by Andy Dingl » Sat, 27 Apr 1996 04:00:00

Quote:>Has anyone written a database that has a field containing keywords?  If
>so, what is the best SQL Statement to search on that field?


The trick is a smart algorithm to extract the keywords, and store them
as either the keyword, or some sort of hashcode of it. You may even
store different hashcodes simultaneously, with different degrees of
"compression" applied to them. You'll also need some intelligence to
examine the selection criteria entered and work out the best fields to
compare against; how specific you expect the match to be and whether
to compare against the slightly or highly.compressed hashcodes. If the
user enters a lot of data, be optimisitic and try to get quite a
"tight" match. If they didn't enter much beyond a few characters of a
name, assume the worst and check it against something lax like a

When you run the query, use equals. SQL servers, unless you have
something with extensions for free-text handling, just don't do very
well otherwise. If you want good performance, you can do some
processing when you store the original records, you can take your time
building up the query itself, but you must try and avoid operators
such as "Like" which have to do intensive processing on a row-by-row


"Cut the second act and the child's throat"
  - Noel Coward, on seeing the young Bonnie Langford on stage


1. Keyword Search

I am setting up a DB made up of several tables which will create dynamic
HTML pages. The idea behind it is that users should be able to enter
keywords, in a form, as criteria to be searched upon.

My problem is that I would, ideally, want the results to show any
_record_ that contains these keywords. That is, the wildcard search
should not be restricted to one field in one table. Is this even
possible? If so, how do I do it? Would I need to write a Java applet or

Thanks, in advance, for any tips you can give me.


2. Using DiffGram, Call a stored proc

3. keyword search form

4. XP and Sybase

5. Help with creating a keyword search

6. ISAM: Reserved error 1070 (ISAM)

7. help with sql keyword search...please!!!

8. schemabinding and extended stored procedures

9. Full text/keyword search and retrieval?

10. HELPFILES : keyword search

11. Keyword Search

12. What Is Best? Keyword Searching

13. Multiple keyword search