May 6, 2008 at 1:34 pm
I've tried to google how most places implement "keyword" search, but "keyword" and "search" can pull back a lot.
My idea was to have a keyword table:
(KeywordID, KeywordName)
Then have aa table that links the actual data to the keywords
(DataID, KeywordID)
This would work fine for what I'm doing, but I was wondering if there is a better way of doing this.
If there is an article about this kind of stuff because I'm sure fuzzy logic could be helpful.
Thanks
May 6, 2008 at 2:06 pm
I'm not certain from your description, but it sounds like Full Text Indexing might do what you need. Check that out in Books Online.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply