1. A database for the Archaeological Collection of the University of Vienna
Thanks to the invitation of Marion Meyer (Head of IKA - Institute for Classical Archaeology, Vienna) a course called "Databases for Archaeologists" was organised at the IKA in 2009/10. The intention was to provide basic knowledge of contemporary archaeological information design to the students.
The participants (Anne-Marie Avramut, Martin Alexander Gretscher, Luise Schintlmeister, Nina Antonella Zaminer, Doris Antonie Ziliachovinos) designed together with their instructor a state of the art modeled database for the administration of gypsum casts and original artifacts owned by the institute's collection. The DB was developed on basis of Filemaker Pro and is now available via the LAN of the institute. It comprises all necessary features including the documentation of restorations as well as an administration tool for the lending of objects.
2. A web based low cost tool to create archaeological distribution maps on the fly
Small research projects or data collections produced for a diploma thesis or dissertation may not always be able to find funding for publishing the data in an adaquate and sustainable way. The aim of this project was to show that web based analysis tools and publishing of data collections can be done without additional funding on low cost level by using already available tools that have been developed by CHC in other projects.
The data (about 1850 records on Bronze Age and Urnfield Period swords) were produced by student of Prehistoric Archaeology Christine Hahnekamp for her diploma thesis. These data should be shown on multiple distribution maps for further analysis. During the course "Databases for Archaeologists" (see above) Christine learned how to improve the modelling of her data and performed all the necessary steps of data cleaning. The hierarchically flat data were transformed into a more efficient relational database. After on CHC programmer Jakob Egger designed a minimalist web application that provides only the absolute necessary features to create archaeological distribution maps on the fly. Using a simple MS Access database as a frontend for local data administration, the web application is working in an open source LAMP environment and employs an AJAX based map interface.