Example importing R2RML script for Northwind database and generating RDF Linked Data Views

The following example describes how to import R2RML script for Northwind database using the Virtuoso Conductor R2RML Import Wizard and how to generate the necessary RDF Linked Data Views for Virtuoso hosting and deployment.

Prerequisites

Ensure the following VAD packages are installed:

Basic Steps

  1. Assume the following R2RML script for the Northwind database.
  2. Go to http://<cname>[:<port>]/conductor:



  3. Enter dba credentials:



  4. Go to "Linked Data" -> "R2RML" tab:



  5. Select the "Choose File" button and select the R2RML file from above to load:



  6. Specify "Target Graph IRI", for ex. "http://northwind_r2rml.com":



  7. Select the "Validate button" to verify the R2RML mapping script:



  8. Select the "Generate" button to generate the RDF Linked Data Views mappings for the Northwind R2RML mapping script:
    • Optionally you can set "Physical Graph Name" for ex. as "urn:northwind:r2rml". If the "Generate RDB2RDF triggers" and "Enable Data Syncs with Physical Quad Store" check-boxes are selected, the Physical Graph Name (persistent) can be used to run a SPARQL query against the materialized triples in the Quad Store:



  9. As result the RDF Linked Data View creation should be completed and a status should be displayed:



  10. The Default Graph Name (transient) specified from above, i.e. "http://northwind_r2rml.com#" can now be used to run a SPARQL query against the created Linked Data View:



  11. The results set for the Linked Data View graph should be displayed:



Related