This Blogger site is just a holding place for our news!

To access the Latin dictionary, click this link:

Numen - The Latin Lexicon - An Online Latin Dictionary

Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Thursday, May 7, 2020

Ping! & English to Latin Fixed

Yes! This site is still alive and actively maintained. Sorry that there's not much news. It's literally because there's not much of new! 

But... here is one news item. 

Today a kind Latin teacher let me know that the English to Latin page was not working. I fixed it. Sorry about that!


Tuesday, July 20, 2010

The big day is coming ... New Sources!

I've finished the preliminary data load from Lewis and Short's "A Latin Dictionary". For those interested, there are approximately 51500 lemmata* (compared to 17500 in the Lewis Elementary).

The data is not live for users yet, so you won't be able to see the new data. But I wanted to tell you about this great breakthrough that I've made. The data needs a little bit more massaging to be considered production ready, but it's very, very clean data so far. I spent several weeks mining the data, and my heuristic algorithms** are getting pretty smart. A few more tweaks!


The big news is how this is going to affect the dictionary. I plan on adding a smart option-box in the bottom right-hand corner that will do two things. 1) List which dictionaries are available for searching and 2) allow the user (that's you!) to change the order in which they are searched and turn them on or off. You can see my mockup of this concept to the right. (Incidentally, this is my first post with graphics!)

The biggest benefit of the LNS (Lewis and Short) dictionary is that it contains 3 times the number of words -- granted, most of them are proper names and place names, but sometimes it's nice to know who and where those crazy ancient authors are talking about.

Keep your eyes peeled. It will only be a matter of weeks until this new data is live!

*For those who don't have experience in the field of lexicography, a lemma is a "head word" ...
** Experience-based methods ...

Friday, July 2, 2010

Regular Updates

What's going on now? As always, work goes on in the background, but nothing big has changed. Regardless, I want to make sure the front page stays fresh, so this update is to let you know that I continue to make small improvements to the dictionary data and the paradigms that the Latin parsing engine runs on.

Mostly, I spend a good amount of time correcting bad data, fixing wonky definitions, etc. But from time to time I find an error in a paradigm (for instance, recently I found macrons on -unt verbs) and fix it. Just a few days ago I discovered that short form 3rd adverbs like potenter don't parse properly; that's one of my current projects.

What's going on in the future? I'm still pulling data out of the big Lewis dictionary. I haven't loaded it yet because I'm happily discovering that the big Lewis dictionary has a wealth of information that can be extracted. The hard part, as it turns out, is extracting it. I don't know when the new data will be online, but rest assured I'm working on it often.

Until next time, feedback is always welcome!

Wednesday, October 14, 2009

J's and U's Updated / Speed Increases

I mentioned a few weeks ago that I planned on making I's/J's and U's/V's look the same on the back-end, while preserving their traditional orthographies on the front-end. I've just completed this task!

My main motivation for making this update is because certain passages stored in The Latin Library reflect the older conventions of using J's for consonantal I's or U's for both consonantal and vocalic V's. Numen's parsing engine was having trouble recognizing forms like jecit (iecit) and uuius (vivus). So now as a result -- after a bit of work -- the engine is updated and now recognizes more possibilities than ever. Incidentally, internally J's are stored as I's and U's are stored as V's.

Another project I completed at the same time is an order-of-magnitude speed improvement for parsing. I was trying to figure out ways to make the engine faster and I discovered a shortcut that boosts speed tremendously. When parsing a word, the engine used to spend between 250ms and 500ms parsing each word! That was always disappointing to me, but I had gotten around the problem by caching the results. Now, however, word parsing takes about 25ms!

Why bother improving the speed? Because soon I will be implementing word lists and frequency lists! A word list, of course, is just a "mini-lexicon" that defines only the words in your chosen passage, and a frequency list is a list of words in order of how often they appear in a passage. The word list will be helpful to quickly work on vocabulary for a passage, and a frequency list will help Latin students study more effectively by giving them the most frequent words first. I'm very excited about this feature, but I don't anticipate it will be done before January 10th (giving me the winter holiday to work on it).

That's all for now!

Wednesday, May 27, 2009

Speed Improvements

Sometimes I take a little bit of time off from reading and cogitating to work on important stuff -- stuff like speed improvements for this website.

This is incredibly nerdy stuff. It actually takes my mind off harder things. Don't ask!

The biggest improvements came in database queries. Some of the queries I was using were executing more slowly than I would have expected. In researching this problem I discovered something called prepared queries. I had no idea they would improve execution speed of certain queries by nearly 10x! On the back-end of things, that's a considerable improvement. On some pages it reduced the overall server load of each page by half -- to 35ms from 65ms! On the front-end, the site will probably feel a tiny bit snappier. Overall your average page load will reduce from about 160ms to about 130ms (since it takes about 100ms for intercommunicative data to traverse the internet from your computer to the server and back). That may not seem like much on your end (a 15% drop in latency) but on the server side it's quite dramatic (a 50% drop in latency).

Wednesday, August 6, 2008

Prettying up the Joint

So I haven't had as much free time as I wanted this week. I've been busy at my day job getting everything "taken care of" before my last day there on August 13th. After that, I'll just be contracting with them for 5 hours a week, because I'll be a full time teaching and grading assistant for the University of New Mexico Foreign Languages and Literatures Department. I'm pretty excited about that!

Nevertheless, I had a few hours free tonight, so I did some sprucing up. I made some icons, fixed some style sheets and squashed some small bugs. There are a few things I want to include before the semester starts:
  • Add a few pronoun paradigms: is and iste for sure.
  • Add some verb paradigms: perhaps volo verbs.
  • Fix up the database backend, especially in the realm of update cascades (it's technical, and you're probably wondering what that means -- don't worry, it'll make things better).
  • Speed up the morphology lookup. It's not slow by any means, coming in at approximately 100 milliseconds per word. But still, I think I can get it down to 40ms. Every bit helps, especially if this site ever gets popular!
  • Make a new database and web server. Right now it's being graciously hosted at the place I work here on campus (Natural Heritage New Mexico). I've been the system admin there for about 5 years, but now -- as I wrote earlier in this post -- I won't be there for very much longer.
I'm sure there's more to update, but I think it's time to take a break for the evening. Enjoy!

Video Tutorials