Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Data Model Questions /

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Online translator


Go to End


1738 Views

Avatar
pali

Community Member, 33 Posts

4 September 2009 at 3:58am

Hello great SS community,

im creating simple translator (from one language to other language) -> currently only from Slovak to English and from English to Slovak. In the feature are planned other languages (Slovak <-> other language) and some glossary (slovak terms). Something similar to http://webslovnik.zoznam.sk/

Im asking, which schema do you like more:

1)
Table slovak_to_english
ID | Slovak | English
1 | mesiac | month, moon, orb
...

Table english_to_slovak
ID | English | Slovak
1 | month | mesiac
2 | moon | mesiac, luna
3 | orb | hviezda, kruh
...

2)
Table slovak
ID | Word
1 | mesiac
2 | luna
3 | hviezda
4 | kruh
...

Table english
1 | moon
2 | month
3 | orb

Table english_slovak
ID | Slovak_id | English_id
1 | 1 | 1
1 | 1 | 2
1 | 1 | 3
...

3)
any other suggestion?

Application should be fast in front & back too. I need to search for similar words too (if somebody will look for "moon", "moonwalk" will be showed and translated too).

Thanks for your opinion

Pali