Welcome Guest, Not a member yet? Register   Sign In
Ideas for database structure / Dictionary
#10

[eluser]Crafter[/eluser]
Well, you could always try the sticky-tape-and-paper-clip solution. Wink

For example, create a tag soup type entry of all related words in a single field. including all transacriptions/transaltiona and a mapping
transcription : ‘to put” , “setzen” , “stellen”, “legen”
translation : "en", "de", "de", "de"

In this way you could search for the word and read the correspoding mapping.

Again, you will have to weigh the benefit of a string-based index field and and regex use against your table join method.

You could hash the values, I read somewhere that MySQL automatically uses a hash index, but this only happens under certain conditions,


Messages In This Thread
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 07:22 AM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 07:25 AM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 07:33 AM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 10:25 AM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 10:48 AM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 12:42 PM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 12:52 PM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 01:50 PM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 02:01 PM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 03:25 PM



Theme © iAndrew 2016 - Forum software by © MyBB