mercredi 4 février 2015

Multi- Language translation

I am designing a database for multi language translator. A particular word can have more than one word in another language(like synonyms of a word).


For example, word a(in language1) -> word b & c(in language 2). Both are correct. I need to store all the words in the database. I researched ann found Schema for a multilanguage database.


But the problem i am facing is there is many to many mapping in my words. I also referred Good database and structure to store synonyms. Currently this is my database design



CREATE TABLE Language1 (
Word_number int,
Word int,
other char(10)
)
CREATE TABLE Language2 (
Word_number int,
Word int
other char(10)
)
CREATE TABLE Language3 (
Word_number int,
Word int,
other char(10)
)
CREATE TABLE Linkwords (
Language1_Word_number int,
Language2_Word_number int,
Language3_Word_number int
)


Although language tables looks neat. The link table is messy.

For example if language3 has 3 words for same word in language 1&2 entries in table looks like



1 1 1,1 1 2, 1 1 3,...


Could anyone please suggest a better design?


Aucun commentaire:

Enregistrer un commentaire