Data Management and Data Services

Principal Investigators: G. Bareth, O. Bubenzer

Data storage and exchange in interdisciplinary research projects, that focus on spatially distributed field data collection in an organised framework are key issues. The overall and sustainable success of such projects depends on the well organised data management and data exchange of/for all projects. Therefore, the aim of this project is to solve the main problems of data storage and exchange within an interdisciplinary project by using a complex spatial database that allows the management of heterogeneous spatial and attribute data. Besides geographical and attribute data, e.g. multi-scaled field maps, this database includes metadata, literature, file management, project staff and publication, as well as picture and video data and provides as a basis for the external and internal presentations of partial results and conclusions. A special focus is the sustainable use of all gathered data within the proposed CRC also after the project is finished.

Organised data management and the implementation of comprehensive project databases are essential in interdisciplinary research projects. The establishment of a project database is a key task. Examples of research projects with a central project database are: CRC/TR32, CRC 299, CRC 522, CRC 564, IRTG 769, the GLOWA projects (Danube, IMPETUS, Volta etc.), as well as the EU funded NOFRETETE project.

The overall aim and task of this project is to implement and maintain a project database that stores, manages and aggregates all data from the other projects. The work programme will be divided into three major periods.

  1. Within in the first period, the focus will be on the development of the database framework. This includes the determination of the relevant data by implementing a questionnaire about data and software.
  2. The second project period will be characterised by the design, development and implementation of the project database. Besides the storage of the collected data, the focus will also be on its metadata.
  3. The development of an online graphical user interface (GUI) which accesses the database will be realised within the third period. To meet the requirements of creating a user-friendly comprehensive database management system, self developed functionalities and interfaces, based on Web-GIS technologies, will be carried out.

For the implementation of the online project-database, ESRI’s product family will be used since the working group of G. Bareth has profound knowledge about implementing spatial databases with these and open source products. In addition to the GIS products, PostgreSQL and MySQL will be obtained in order to manage the attribute and metadata. The file database will just be organised in a folder system (e.g. AFS) and the files will be accessible via the Online-GUI. The implementation of the whole system requires extensive programming in Java, CGI, PHP, XML, AJAX, HTML and AXL. Additionally, the staff must be highly qualified in database, GIS, and remote sensing (RS) technologies. Similar approaches were lately implemented by the working group of G. Bareth (www.tr32db.uni-koeln.de) for the CRC/TR32 (Curdt et al. 2008).

As a result of the comprehensive database and the use of highly resolute raster data, the project offers the potential to generate multi-scaled standardised field maps of the main study areas of the CRC, which will be helpful in the fieldwork. In CRC 389 (ACACIA project E1), positive experience was obtained in combining Landsat/ASTER and QuickBird/Worldview I/II satellite images with the relevant spatial data of the projects. Thus, archaeological survey of an investigation area can be combined with a geographical raster from topographic maps (e.g. 500 m squares). In addition, the results can be presented in an atlas-framework (e.g. Bubenzer et al. 2007a).

This project has a key role in the overall project due to its general task of ensuring the sustainable use of all collected and measured data. Consequently, there is strong linkage and cooperation to all projects within the CRC due to the data management and data exchange tasks of this project.

 

1st Phase - Research Programme
  2nd Phase - Research Programme
806_Z2_Poster_small   806 Z2 Poster 2013 small
view Poster   view Poster

CRC 806 - Database

The CRC806-Database is the central data infrastructure of the Collaborative Research Centre 806 (CRC806).

database
read more ...


According to the German Research Foundation (DFG) proposals for safeguarding good scientific practise (DFG 1998), the CRC806 endeavours to provide a sustainable long-term data archive for the project data. The project is planned for an overall period of twelve years, and is subdivided into three four-year project terms which are underlying an evaluation at the end of each term. According to the demand of the DFG, to provide access to research results at least 10 years after the end of the project, the CRC has to make sure to be able to provide access to the data for up to 22 years.

 

logo koeln schrift 120x120 transparent

     logo uni bonn 40x40 transparent      dfg logo transparent
 

RWTH Aachen University

  logo geoverbund small 
logo qsga small new  
QR-Code