This is an old revision of the document!


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




Description
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

  • List and link your actual and ideal data sources.
  • project/sqlrdf_mapper.1467223621.txt.gz
  • Last modified: 2016/06/29 20:07
  • by fabioricci