Emdb: yet another db for the stratigraphic record

Emanuel Demetrescu, Cristina Gonzalez-Esteban, Filippo Sala

«Archeologia e Calcolatori» 2023, 34.1, 21-30; doi: 10.19282/ac.34.1.2023.03

Abstract

The collection of stratigraphic data has been done for years with offline tools like the Microsoft Access software, which was considered a user-friendly tool with the ability to print standardised context sheets (like the Italian ministerial US sheets) directly and ‘without’ the need for technical expertise. It is well known to the scientific community the limitation inherent in this type of approach: the data is not shared online and is not easy to be collaboratively edited; the data is locked within a proprietary format with repercussions on medium- to long-term preservation; and it is not immediately possible to integrate the data with other projects due to a lack of precise reference standard. Despite these issues, the offline approach remained viable in a whole range of situations where it is necessary to have a fast and easy-to-manage database. This contribution starts from the hypothesis that an offline standardised and encapsulated tool in an open format (such as SQLite, LibreOffice Base or MySQL), editable with open source software, can offer additional solution because it is easy to use and disseminate in the form of a free, downloadable template. EMdb aims to collect and manage not only stratigraphic data but also reconstructive unit sheets to cover the need to analyse, interpret and validate scientific hypotheses in the field.

Figures

Preview