ANDS Logo

Software is available at:

https://sourceforge.net/projects/rdb2rdfmapper

Software categories:

Sensor Networks

Integration metadata from various systems which are internal to an institution

Project Members:

Danqing Zhang (Project Manager, )

Dr. Joseph Young (Project Manager, j.young@qut.edu.au)

Lance De Vine (Lead Developer, l.devine@qut.edu.au)

Mark Cottman-Fields (Developer, mark.cottmanfields@qut.edu.au)

Professor Paul Roe (Research Officer, )

Stephanie Bradbury (Data Librarian, s.bradbury@qut.edu.au)

Craig Milne (Data Librarian, c2.milne@qut.edu.au)

ANDS Contact:

Andrew White (Andrew.White@ands.org.au)

Project Status:

Completed

Biodiversity

Queensland University of Technology

Project Description:

Study the effects that humans have on the environment.
Adopt acoustic sensing, database and web service technologies to capture audio data.
Generate audio data and tags.

Software to facilitate the mapping and transformation of data contained in the relational database, into a form that will be able to be ingested into QUT's Metadata Hub.
The Bio-diversity Data Capture Project aimed to study the management and publishing of audio data collected from acoustic sensors for environmental health monitoring led by Professor Paul Roe?s research group at Queensland University of Technology (QUT). The researchers have developed a research application, the Environmental Health Sensor Monitoring (EHSM) system, which adopts acoustic sensing, database and web service technologies to capture audio data from different environments for monitoring species that have regular and predictable vocalisations. The research project generates two main types of data: audio data and tags that indicate an acoustic event. Audio is collected in a range of formats using a recording device which is placed at a location of interest. The audio data produced are uploaded to a web site using a web interface. Some recording devices are capable of uploading automatically over a wireless network. The audio data are stored on a file system with links to the files stored in a relational database. Other information relating to Projects, Sites, Sensors and audio files with their tags are also stored in the relational database.

To help researchers to publish the information that are collected using the EHSM system, a Java-based desktop application called "RDB2RDF Mapper" was developed through the Bio-diversity Data Capture Project. The application assists a researcher and data manager to create a mapping between the metadata stored within the relational database and a given schema or web ontology. The mapping can then be used to transform the relational database data into a form (e.g., Resource Description Framework, or RDF) which can then be easily ingested into QUT?s Metadata Hub and published to Research Data Australia.

The "RDB2RDF Mapper" application is not constrained by a specific relational database schema or ontology. It will be able to be applied to schemas from most popular relational databases and a broad range of RDFS or ontologies. Thus the "RDB2RDF Mapper" software is extensible so that support for other mapping rules and languages could be added in the future to cover wide range of data management needs.

The Bio-diversity Data Capture Project has helped a researcher, data manager and the project team with:

a) better understanding of the requirements of managing data for environmental sensing;
b) improved understanding of the most suitable technique (e.g., D2R server) which has general applicability for metadata management using relational databases and the semantic web;
c) better understanding of ontologies;
d) better understanding of the construction of mapping rules which will help with the future audio sensing database development;
e) much better understanding of data models and meta-models for managing environmental sensing data.

This knowledge is valuable and will help the Research Group manage their environmental sensing data more effectively.

In addition, the Bio-diversity and the other two data capture projects provided QUT with an opportunity to establish a system architecture and suitable workflows for publishing research data information to Research Data Australia. The system architecture and workflows are now existing components of infrastructure that other research groups can use in the future, and therefore support the broader development of research data management and the publishing of QUT research data.

ANZSRC-FOR code:

270700
279901
260000