Semweb provides its own developped SQL RDF Mapper to convert table data into RDF Data.

The mapper was used to build RDF data for glam_rdf_data_online and glamsearchportal.

For each table in a database, it displays table schama with information on keys and permits the definition of one or several maps using TURTLE expressions, which are evaluated inside a sesame RDF model.

A single tenant online version will be available for the duration of the hackaton under the link https://ch.semweb.ch:8151/SQLRDFSTAR/GUI.jsp

“User manual”
The user selects one table and press the orange button to create a first blank TURTLE MAPPING SCHEMA. Once the TURTLE SCHEMA appears, the user can define a mapping for the key of the record and several mappings for each of the table columns. Inside each mapping several functions can be used:

* Explosion of a single column value by means of a separator (e.g. “one,two,three” exploded by “,”)
* Extraction of regular expressions out of values
* If-Then expression (do map, donot map)
* Table lookp in other table while mapping


Inside a TURTLE Mapping several maps can be defined, one for each SPARQL Endpoint. For instance if you wish to scan a table and map one RDF code to one RDF Store and another RDF code (might be different) to another RDF Store, then you define two mappings.

Testing a Mapping
Before you execute a map you should validate the TURTLE syntax and after successful validation you should store that mapping and make a version.

Then you can test a validated map on 1 or 2 records using the verbose option.

• List and link your actual and ideal data sources.

• fabioricci