Die Suche ergab 71 Treffer

von Lúthien Meliel
Mi Sep 21 2011 22:41
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

The editorial procedure of joining the references is already done in the wordlists: For example, the entries "böse, boshaft, falsch (moralisch), schlecht (moralisch)" all have the reference PE/17:149,170, VT/48:32, the entries "düster, Düsterkeit" all have the reference PE/18:88, PE/17:149. The res...
von Lúthien Meliel
Mi Sep 21 2011 14:34
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

I should explain how the entries are constructed. Tolkien's translations have often variations, so one has to decide whether they're the same word or not. For example, we find: paran 'naked, bare' PE/17:86 paran 'bald, bare' PE/17:171 paran 'smooth, shaven' RC/433 I think these three are reasonably...
von Lúthien Meliel
Mi Sep 21 2011 14:17
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

I think that Eryniel put a topic for "feature requests" on Parendili. Could you maybe write it down in there? Well, I don't see it as an optional 'feature', it's just a basic thing the dictionary has to provide. ok, I'll rename that topic to Mandatory & Optional Requirements then :) - but seriously...
von Lúthien Meliel
Mi Sep 21 2011 7:59
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

Hi, I did now run into something that I am uncertain about. It's this: since I have now transfered the attributes to the Sindarin entries, I am now assigning the values from your wortliste table to the Sindarin entries. I did get an unequal number of rows, which turns out to be cause by the fact tha...
von Lúthien Meliel
Mo Sep 19 2011 22:04
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

What about sorting the alternative words into the main list? For example, you should be able to search for atlaud or agr , find them in the list and be referred to aclod and agor . Sure, that's no problem at all. Because the structural information is contained within parent_id -> id relationships, ...
von Lúthien Meliel
Mo Sep 19 2011 16:18
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

to answer your question about self-referencing the ENTRY table, here's an example how it works. If you execute this query: select es.GLOSS sindarin, 'pl.', ep1.GLOSS, ep2.GLOSS, ep3.GLOSS, ep4.GLOSS, ' alt.:', ea1.GLOSS, ea2.GLOSS from ENTRY es left join ENTRY ep1 on es.ID = ep1.PARENT_ID and ep1.PL...
von Lúthien Meliel
So Sep 18 2011 20:24
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

hi, thanks for the comments! That's a great help. Thanks for bringing this up. How should we proceed? Should I check it all (including the second column) and update the lists once more for you to download? I'm sure you already have a script to break them up into normalized lists which you can run ag...
von Lúthien Meliel
So Sep 18 2011 20:08
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

I changed the datamodel a little bit because I made a mistake: the "plural" and "alt" markers were on the TRANSLATION table, so that they would have been properties of a combination of a Sindarin and a German entry -> a 'translation' row. This wasn't right, because plural and alternative forms don't...
von Lúthien Meliel
So Sep 18 2011 13:51
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

Hm, this is giving me more of a headache than I hoped - especially those collation issues in MySQL are very annoying. Never have that at work, where we just put everything in utf8. Maybe Oracle is a bit smarter with these things, too. Another thing that came up is this: I wanted to make a list of al...
von Lúthien Meliel
Do Sep 15 2011 13:48
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

ok, will do.
Thanks :)
von Lúthien Meliel
Do Sep 15 2011 11:11
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

The dôl/dol matter is intentional - there seems to have been a change of conception regarding the etymology of the word. The former comes from ndolo and has the plural duil , the latter from *ndoll- (hence the alternate doll ) and probably has the plural *dyl . What do you propose? To keep those as...
von Lúthien Meliel
Mi Sep 14 2011 23:14
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

Suilad Aran, I've got some more questions about the data set. As expected, there are some rows that are duplicate with regards to the primary key *if* that's set to a combination of *unique German + unique Sindarin entry*. It seems that for some of those there is a second entry because of an alterna...
von Lúthien Meliel
Mi Sep 14 2011 14:35
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

Maybe it's easier if I first load in the dataset you provided, and then give you the whole thing to test? I'm currently looking into SQLite, which is maybe somewhat faster than the Derby (Java) database that I used for the previous version. Since SQLite stores everything in just one file, it's easy ...
von Lúthien Meliel
Mi Sep 14 2011 14:17
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

Is #LANGUAGE_ID really needed there? Also, how do you exactly handle various translations of the same Sindarin word? The rule is that Tolkien's entries are like this: baug 'tyrannous, cruel, oppressive'; and the amount of glosses will likely vary among the languages of translations. "really needed"...
von Lúthien Meliel
Mi Sep 14 2011 11:10
Forum: Ressourcen
Thema: Überarbeitung der Wortliste
Antworten: 161
Zugriffe: 123511

with the remaining columns added, plus the other comments table: https://img.skitch.com/20110914-x4a3s6399143dee4ebp98jmdu8.jpg I'll next create an instance of this schema on MySQL and migrate the data therein, so further test if it stands up to expectations. NB - it's entirely possible to merge the...