-
Database for languages synonyms
Hi,
I have to store the languages known by an interpreter. The problem is that many languages are also known with other names (es: Ashanti, Asante, Ashante, etc...).
So, my idea is to have a Language Table in a Many-to-many relationship (called synonyms) with itself.
Language : IdLanguage, Name
Synonyms : IdL1, IdL2
How to populate the synonyms table?
An option is to insert for every couple (idL1, IdL2) also the specular couple (IdL2, IdL1).
Another option is to insert only couples where IdL1<IdL2.
With the first option it's easy to find all synonyms (idL1 = id_to_find), with the second I should query on IdL1=id_to_find or IdL2=id_to_find.
Am I right?
Do you have other solutions ?
Thanks.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|