In this section

TIMBUS Partners

caixa
dpc
inesc
intel
kit
lne
sap_grad
sba
sqs
westfalische

Sensor Database Extractor

Details
Last Updated on Friday, 09 January 2015 15:22

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.

Creator
KIT

License
Copyright 2013 TECO - Karlsruhe Institute of Technology

Find at opensourceprojects.eu
https://opensourceprojects.eu/p/timbus/context-population/extractors/wiki/Sensor%20Database%20Extractor/

Go to the Sensor Database Extractor's page on opensourceprojects.eu 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: https://opensourceprojects.eu/p/timbus/context-population/extractors/wiki/How%20to%20create%20a%20new%20Extractor/

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

  1. Download the newest version of D2RQ from http://d2rq.org/ 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 (http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html). 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