| Searching Synonyms [message #640634] |
Sun, 02 August 2015 00:27  |
 |
orauser001
Messages: 13
Registered: April 2013
Location: us
|
Junior Member |
|
|
Hi
We are creating a Oracle Text Search capability for a field containing company names. In this domain certain synonyms are very common, such as
Inc -> Incorporated
Ltd -> Limited
PLC -> Public Limited Company
So if one searches for
'Tata Steel Limited' - they should also find 'Tata Steel Ltd'
'Sigma Berl Public Limited Company' - they should also find 'Sigma Berl PLC'
What is the best way to achieve this?
I saw some simple examples of the oracle's Thesaurus feature - where i can set up the above as synonyms.
However how would i use that in my contains query. For example if user is entering 'Tata Steel Limited' - i want only the Limited word to be expanded to its equivalent words (not the words Tata and Steel)
Thanks in advance for any pointers
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
