make.opendata.ch wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== SQL RDF MAPPER - converts SQL Data into RDF Data =====

[[SQL RDF MAPPER|{{project:ogsrm_mapper1.png}}]]

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

The mapper was used to build RDF data for [[project:glam_rdf_data_online]] and [[project: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

**Note** : This mapper is freely available until July 31 2016. 
From July 25 2016 on, a similar but much more secure service will be available upon https://rdflink.ch


\\ 
\\ 
\\ 

**"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, click on one generated link and see what has been mapped.
\\ 
\\ 
another way to test a map is to define from-which records you would like to test, then to start the online tool by licking on the table symbol on the left of a table record. This online tool permits you to see the table records together with the mapped triples, as pictures 2 and 3 show.
\\ 
\\ 
**Important**: Use this mapper one at a time, since it is not (yet) multi-tenant.

\\ 
\\ 
\\ 
\\ 
\\ 
[[SQL RDF MAPPER|{{project:ogsrm_mapper_detail2recsgugg.png}}]]
Picture 2: Online Tool showing a map of a table - triples above, records below

\\ 
\\ 
\\ 
\\ 
\\ 

[[SQL RDF MAPPER|{{project:ogsrm_mapper_detail2recsguggtransp.png}}]]
Picture 3: Online Tool showing the same map of a table - triples above, transposed records below

\\ 
\\ 
\\ 
\\ 
\\ 

[[SQL RDF MAPPER|{{project:ogsrm_mapper_exec1.png}}]]
Picture 4: Execution dialog (before start)

\\ 
\\ 
\\ 
\\ 
\\ 

[[SQL RDF MAPPER|{{project:ogsrm_mapper_exec2.png}}]]
Picture 5: Execution results

\\ 
\\ 

**MAPPER FUNCTIONS**
\\ 
\\ 
\\ 
\\ 
\\ 

[[SQL RDF MAPPER|{{project:mapper_explode.png}}]]
Picture 6: Mapper explode function (German)

\\ 
\\ 
\\ 
\\ 
\\ 

[[SQL RDF MAPPER|{{project:mapper_regex.png}}]]
Picture 7: Mapper regex function


\\ 
\\ 
\\ 
\\ 
\\ 

[[SQL RDF MAPPER|{{project:mapper_tlookup.png}}]]
Picture 8: Mapper table lookup function

\\ 
\\ 
\\ 
\\ 
\\ 

[[SQL RDF MAPPER|{{project:mapper_conditions.png}}]]
Picture 9: Mapper if-then function



===== Data =====

Data for this tool are SQL tables.

Date must be uploaded into the table.

If you do not find an upload mechanism on the main page, please ask me (Fabio Ricci) to upload your table data.

===== Team =====

  * [[user:fabioricci]]
  
{{tag>status:demo needs:dev needs:design needs:data needs:expert glam semantic}}