Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-18 : 18:52:15
|
Kirby writes "I'm very new to SQL and am more of the "idea" person than the
actual programming person. Anyway, we have a very straight-
forward database in SQL 7 that has mailing list kinds of data for
small to extremely large corporations. The problem is that we
need a way to zero in on specific functions within a company,
which can vary from one department to the next. We have decided
that either a synonym list or a list of terms arranged hierarchically
will help us the most. While there appear to be a number of
OTS products out there that will interface with SQL 7, they are
expensive and seem to be much more than what we need (i.e. heavily
into thesaurus construction). Is it possible to build a quasi-
thesaurus or synonym/hierarchical term list that will map to the
many records in our database for automatic update and will also
allow for its integration into the search function (i.e. if we
search on "shipping", we will find all the records that list
"Shipping Department", "Mail Department", and "Administrative
Assistant", as they are indexed for that record and function)?
I hope this is clearer than mud. We are just unsure if we need a
new database to address this, or if we just need to develop a
table....and if the programming hours are worth it.
Thanks for your help!" |
|
|
|
|
|
Building a synonym or hierarchical term list in SQL 7