Jump to:

3430 Posts in 1057 Topics by 734 members

Data Model Questions

SilverStripe Forums » Data Model Questions » Online translator

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

Page: 1
Go to End
Author Topic: 1054 Views
  • pali
    Avatar
    Community Member
    33 Posts

    Online translator Link to this post

    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

    1054 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.