Sensor Database Extractor

The main purpose extractor is to extract data from a relational database and map it into an ontology format. We used D2RQ for this process and a self-written mapping file (Turtle script) to be provided by the user. Based on the specifications in the mapping file, data is extracted from the database and populated into an RDF graph that can be accessed online or queried using SPARQL.


Copyright 2013 TECO - Karlsruhe Institute of Technology

Find at

Go to the Sensor Database Extractor's page on for more details about requirements, interaction and source code by following the link above.

More Information About The Sensor Database Extractor
There is not publication related to this tool yet. The only documents that can be referred to are 6.10 and D8.3.

Create a New Extractor
To learn how to develop an extractor, follow this link to a tutorial by Caixa Magica Software:

How to Install Sensor Database Extractor
First of all, you need to download required components:

  1. Download the newest version of D2RQ from and move into the downloaded folder. This folder will further be handled as the extractor’s main folder.
  2. Download the specific jdbc driver for your database client, e.g. ojdbc6.jar for Oracle 11g ( Move the downloaded JDBC driver into the extractor’s subdirectory "lib/db-drivers"
  3. Now, you have to create your own mapping file (timbus.ttl). Such a file can be opened with any common text editor. Adjust this file to your database and ontology by specifying the prefixes and the required mappings. An example file archive can be found on the GIT website: Example File Archive. You can unzip it and you will find all d2rq files and a mapping file. To run the service, first open your command line or terminal. Move to the extractor’s main folder. Run the d2rq-server batch file or the shell script in the following way: Windows: "d2r-server.bat timbus.ttl" Linux/Mac: "sh d2r-server timbus.ttl" You can now browse the extracted RDF graph by visiting the website that was specified in the mapping file as “d2r:baseURI”.

Learn more about the Sensor Database Extractor in the video below.

Back to Context Population Framework