This HTML5 document contains 38 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n2:VirtMysRDFViewUI

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:42:39.987082

dcterms:modified

2017-06-13T05:42:39.987082

rdfs:label

VirtMysRDFViewUI

foaf:maker

n7:this n32:this

dc:title

VirtMysRDFViewUI

opl:isDescribedUsing

n11:rdf

sioc:has_creator

n24:this n31:this

sioc:attachment

n12:png n13:png n14:png n17:png n18:png n19:png n20:png n21:png n23:png n25:png n26:png n28:png

sioc:content

%META:TOPICPARENT{name="VirtRdb2RDFViewsGeneration"}% ---+ Virtuoso Linked Data Views for the MySQL sample Database This document details the steps required for building RDF-based Linked Data views of schema objects in MySQL 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 [[VirtMySQLLinkingObjects][Link the MySQL tables into OpenLink Virtuoso]]. 1 Select the <b>Database</b> -> <b>Linked Data Views</b> tab of the Conductor. %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 RDF 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>Linked Data 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>Linked Data 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%

sioc:id

9c07e46fa580c3e313e7af71a0099c43

sioc:link

n2:VirtMysRDFViewUI

sioc:has_container

n5:VOS

n8:has_services

n9:item

atom:title

VirtMysRDFViewUI

sioc:links_to

n2:VirtMySQLLinkingObjects n15: n29:ini_URIQA n33:MySQL

atom:source

n5:VOS

atom:author

n7:this

atom:published

2017-06-13T05:42:39Z

atom:updated

2017-06-13T05:42:39Z

sioc:topic

n5:VOS