%META:TOPICPARENT{name="VirtRdb2RDFViewsGeneration"}%

---+ Virtuoso Linked Data Views for a JDBC Database

This document details the steps required for building RDF-based Linked Data Views of schema objects in JDBC data sources, using the sample Northwind database.

   1 Go to the Virtuoso Conductor (<code>http://&lt;cname&gt;:port/conductor</code>). Note, the appropriate cname (hostname) and port number for dereferencing URIs must be set for the <code>[[http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ini_URIQA][URIQA:DefaultHost]]</code> Virtuoso configuration parameter before creating the Linked Data Views.
   1 Log in as user <b><code>dba</code></b> (or another user with DBA privileges).
   1 If not already done [[VirtOJDBCLinkingObjects][Link the JDBC tables into OpenLink Virtuoso]].
   1 Select the <b>Linked Data</b> -> <b>Views</b> tab of the Conductor.  (In previous versions, this path was <b>Database</b> -> <b>Linked Data Views</b>.)
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_01.png" style="wikiautogen"/>%BR%%BR%
   1 Select the <b>Database Name Qualifier</b> (e.g., "<code>NWND</code>")  that exposes the Tables / Views for this exercise.
   1 Enter the <b>Base URL</b> to which your URL rewrite rules will be bound (e.g., <code>http://&lt;cname&gt;:8890/NWND</code>).
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_02.png" style="wikiautogen"/>%BR%%BR%
   1 Select the specific Tables containing the data to be published.
   1 Choose <b>Generate via Wizard</b> to perform a custom generation and continue with Step 9 or choose <b>Generate & Publish</b> to perform a one click generation of the Linked Data Views, in which case skip to Step 17.
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_03.png" style="wikiautogen"/>%BR%%BR%
   1 At this point, you are presented with the option to edit your column selection.  Select the "Edit" link, for example, for table <code>NWND..Customers</code>.
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_04.png" style="wikiautogen"/>%BR%%BR%
   1 For images or other binary data in MIME formats to be revealed as anything other than generic "binary objects", you must map large <code>varbinary</code> types.
to the appropriate MIME types like <code>image/gif</code>. To do so, select the <b>Edit</b> link for <b>Binding/MIME Type</b> of the relevant table columns.  You can: 
      * Leave the <b>Binding/MIME Type</b> literal; or
      * Set to skip, such that the column will not be used in RDF generation; or
      * Select the <b>binary object</b> value in order for the column to be referenced as binary.
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_05.png" style="wikiautogen"/>%BR%%BR%
   1 After finishing with your changes click the <b>Save</b> button, or cancel the changes and go back by clicking the <b>Cancel</b> button.
   1 Make sure you click the "Next" button.
   1 At this point, the <b>RDF View Definition</b> form will let you <b>Select Generation Targets</b> options:
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_06.png" style="wikiautogen"/>%BR%%BR%
      * Data Source Ontology Mappings
      * Instance Data View Mappings
      * [[http://www.w3.org/TR/void/][VoID]] statistic
   1 Make sure you click the "Next" button.
   1 Based on your selections in the prior form, the <b>RDF View Definition</b> <b>Deployment Options</b> form will be offered:
      * Data Source Ontology Rules
      * Instance Data Rules
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_07.png" style="wikiautogen"/>%BR%%BR%
   1 Select the desired option(s) and click the "Prepare to Execute" button which unveils a generated Instance Data and/or Ontology form.
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_08.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <b>Execute</b> button and Virtuoso will:
      1 Apply the generated declarations (instance data and ontology) to your Virtuoso instance.
      1 Publish / Deploy declarations that expose the Wizard-generated Rewrite Rules and associated endpoints.
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_09.png" style="wikiautogen"/>%BR%%BR%
   1 Click on one of the <b>Instance Data</b> Sample links to view some of the deployed Linked Data Views.
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_10.png" style="wikiautogen"/>%BR%%BR%
   1 Click on the <b>Statistics Data (<nop>VoID Graph)</b> link to view the <nop>VoID Statistics.
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_11.png" style="wikiautogen"/>%BR%%BR%
   1 Click on the <b>Ontology</b>  link to view the ontology information.
   %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_12.png" style="wikiautogen"/>%BR%%BR%