Search found 71 matches
- Wed Sep 21 2011 22:41
- Forum: Ressourcen
- Topic: Überarbeitung der Wortliste
- Replies: 161
- Views: 306778
- 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...
- Wed Sep 21 2011 14:17
- Forum: Ressourcen
- Topic: Überarbeitung der Wortliste
- Replies: 161
- Views: 306778
- 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...
- 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, ...
- 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...
- 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...
- Sun Sep 18 2011 20:08
- Forum: Ressourcen
- Topic: Überarbeitung der Wortliste
- Replies: 161
- Views: 306778
- 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...
- Thu Sep 15 2011 13:48
- Forum: Ressourcen
- Topic: Überarbeitung der Wortliste
- Replies: 161
- Views: 306778
- 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...
- 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...
- 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 ...
- Wed Sep 14 2011 14:17
- Forum: Ressourcen
- Topic: Überarbeitung der Wortliste
- Replies: 161
- Views: 306778
- 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...