How to exchange data between DB Systems on Early Humans. A case study based on the SFB 806 DB and the ROCEEH ROAD system

Abstract

In the recent past data base systems providing information on early humans and their environment are becoming more and more important and increase rapidly in number. However, this increase in different DB systems is concomitant with an increasing redundancy in the digital information stored in these database systems. Therefore, in this study we explore ways to reduce redundancies due to multiple storage of data and, hence, we show solutions to minimize the requirements to store and manage digital information in the prehistory and paleoenvironment domains.

The example is based on the database systems of the DFG financed SFB 806: “Our Way to Europe” and the Heidelberg Academy of Sciences and Humanities project entitled: “The Role Of Culture in Early Expansion of Humans (ROCEEH). We focus especially on the spatial data available in both systems as well as on the environmental information. Therefore, we examine and test exchange interfaces based on Spatial Data Infrastructure technology (OGC Standards) and metadata/schema mappings.

The poster presents currently implemented interfaces of both data base systems in terms of their main commonalities and differences. Based on this overview, we discuss ways of direct links between the DB systems. Moreover, we identify procedures that need to be developed in the future to integrate and exchange data between both systems.

We show that DB-linking activities based on the OGC standards yield valuable results and lead to a more efficient, sustainable management of these DB systems providing added values for the related research groups.

Resources

• ROCEEH_SFB806DB.pdf

Bibliography

Märker, M., Willmes, C., Hochschild, V., Bareth, G. (2015): How to exchange data between DB Systems on Early Humans. A case study based on the SFB 806 DB and the ROCEEH ROAD system. CRC806-Database, University of Cologne, 2nd Data Management Workshop, Cologne, DOI: 10.5880/SFB806.11