Integrated Archaeological Database


The Integrated Archaeological Database system, or IADB for short, is an open-source web-based application designed to address the data management requirements throughout the lifespan of archaeological excavation projects, from initial excavation recording, through post-excavation analysis and research to eventual dissemination and archiving.

History

Development of the IADB began in the late 1980s at the Scottish Urban Archaeological Trust in Perth, Scotland. The aim was to develop a computerised integrated database to record and help with the analysis of several large excavation projects on which SUAT was working at the time. Initial components included a simple stratigraphic analysis program, a basic Context and Find cataloging application and an early attempt at a single context plan digitising solution.
The original concept of the IADB was to make available digital versions of the various excavation records as an easily accessible integrated resource for use in post-excavation analysis and to provide a framework within which that analysis would be undertaken. Initially, the IADB only dealt with simple artefact records and stratigraphic unit or context records. Over time, the scope of the IADB has widened to include other digital resources including single context plans, photographs, stratigraphy diagrams, etc. Initially the IADB was described as a "digital workbench" or a "computerised desktop", today we would probably call it a virtual research environment.
Early versions of the IADB ran under MS-DOS and were written in Clipper and C using the dBase database format. Vector graphics used the GEM graphics library, a precursor to Windows. With the launch of Visual Basic, the IADB was moved to Windows using an MS Access database. In 1997 development of the IADB moved from SUAT to York Archaeological Trust and shortly afterwards the IADB programs were re-written in Delphi, still using an Access database. In 1999 work was begun on converting the IADB to a web application using MySQL and PHP.
In recent years, development has continued in collaboration with the Silchester Town Life Project at the University of Reading. Grants from the UK Arts and Humanities Research Council have funded the development of the IADB as a web publication tool, and grants from the UK JISC have funded the OGHAM and VERA projects for the development of the IADB as a Virtual Research Environment for archaeology using the Silchester project as a test-bed.
In September 2005, an edition of the BBC Radio 4 programme The Material World featured a discussion on the role of the IADB in the Silchester project with particular reference to the development of the IADB as a virtual research environment. As of September 2010, this programme remains available online at http://www.bbc.co.uk/radio4/science/thematerialworld_20050922.shtml.
The IADB was Highly Commended in the Best Archaeological Innovation category at the 2010 British Archaeological Awards ceremony held at the British Museum on 19 July 2010.

Structure

An IADB project database consists of data resources and the links, or connections between them.
The IADB includes built-in editors for creating and manipulating Structure Diagrams, creating and editing internal documents, and for digitizing single Context plans. No third party software is required.
Any number of user-defined tags may be applied to any resources within a project database.
Each IADB project, each Tagged list, each individual resource record, and each SQL Query in an IADB project database has a unique URI which allows links to individual IADB resources to be included in web publications, external databases, etc.

Recent Developments

An innovative approach to Context recording has been developed which uses a scanned image of the original Context Recording Sheet and some associated metadata as an alternative to the traditional IADB context record which was essentially a full transcription of the CRS. An example of a facsimile Context record may be seen here. A discussion of the background to the Facsimile Context Record may be downloaded from here.
Work is continuing on the development of a Section record within the IADB. The aim is to produce a fully interactive system of digitised section drawings linked to the Contexts, Finds and Samples represented on them. In many ways, this will be similar to the existing system for digitising and storing single context plans within the IADB.
Work has begun on the development of a web service to provide IADB project data in XML format, possibly with an associated RSS feed. The XML web service will be in addition to the unique URIs mentioned above which provide IADB project data as formatted HTML.

IADB Users

Some current users of the IADB include:
In addition, the IADB is used as a teaching tool within the Department of Archaeology at the University of Reading and, most recently, in the RADII project, a British Academy funded joint project between University College London and the University of Reading.