hi dave, had a look at Google Search Appliance and thought it was only for searching our web pages, do you think i could possibly utilize it in some way to get the synonyms for my database searches?
thanks > > We use ColdFusion and MySQL (innodb) in our applications and when > users search for data we want it to also find records containing > related words > > / synonyms. > > > > What is the best way to achieve this? > > A good enterprise search solution can do this for you. For example, > the Google Search Appliance can do this automatically. I wouldn't be > surprised if Solr/Lucene has similar functionality. > > If you're strictly doing this through database queries, it's up to > you > to manage a synonym list. This isn't something that relational > databases do especially well, either. But if your synonym list is > fairly small, it might do it sufficiently well. You could conceivably > use a full-text indexing solution against your synonym list, then use > the returned record to filter your database search. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
