Search found 71 matches

by Lúthien Meliel
Wed Sep 21 2011 22:41
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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...
by Lúthien Meliel
Wed Sep 21 2011 14:34
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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...
by Lúthien Meliel
Wed Sep 21 2011 14:17
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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 :) -...
by Lúthien Meliel
Wed Sep 21 2011 7:59
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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...
by Lúthien Meliel
Mon Sep 19 2011 22:04
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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, ...
by Lúthien Meliel
Mon Sep 19 2011 16:18
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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...
by Lúthien Meliel
Sun Sep 18 2011 20:24
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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...
by Lúthien Meliel
Sun Sep 18 2011 20:08
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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 alt...
by Lúthien Meliel
Sun Sep 18 2011 13:51
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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...
by Lúthien Meliel
Thu Sep 15 2011 13:48
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

ok, will do.
Thanks :)
by Lúthien Meliel
Thu Sep 15 2011 11:11
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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...
by Lúthien Meliel
Wed Sep 14 2011 23:14
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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...
by Lúthien Meliel
Wed Sep 14 2011 14:35
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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 ...
by Lúthien Meliel
Wed Sep 14 2011 14:17
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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 ne...
by Lúthien Meliel
Wed Sep 14 2011 11:10
Forum: Ressourcen
Topic: Überarbeitung der Wortliste
Replies: 161
Views: 306778

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...