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

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

Subject Item

n12:this

foaf:made

n2:VirtOraRDFViewUI

Subject Item

n13:this

sioc:creator_of

n2:VirtOraRDFViewUI

Subject Item

n5:this

sioc:creator_of

n2:VirtOraRDFViewUI

Subject Item

n6:VOS

sioc:container_of

n2:VirtOraRDFViewUI

atom:entry

n2:VirtOraRDFViewUI

atom:contains

n2:VirtOraRDFViewUI

Subject Item

n2:VirtOraRDFViewUI

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:45:18.238431

dcterms:modified

2018-12-26T09:50:41.460978

rdfs:label

VirtOraRDFViewUI

foaf:maker

n9:this n12:this

dc:title

VirtOraRDFViewUI

opl:isDescribedUsing

n16:rdf

sioc:has_creator

n5:this n13:this

sioc:content

%META:TOPICPARENT{name="VirtRdb2RDFViewsGeneration"}% ---+ Virtuoso Linked Data Views for the Oracle Human Resources Sample Database This document details the steps required for building RDF-based Linked Data views of schema objects in Oracle data sources, using the sample Human Resources database. %TOC% ---++ Prerequisites * An instance of [[http://virtuoso.openlinksw.com/download/][Virtuoso Commercial Edition]]. (Open Source Edition does not support Linked Data Views of remote data.) * <i><b>Note:</b> The <code>[[http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ini_URIQA][URIQA:DefaultHost]]</code> Virtuoso configuration parameter must be set to the appropriate fully-qualified hostname (<code>CNAME</code>) and port number before creating any Linked Data Views, to enable URI dereference.</i> * [[VirtOracleLinkingObjects][Oracle tables linked into the Virtuoso instance]]. * An ODBC Driver for Oracle, with the client components installed on the same host as the Virtuoso instance. ---++ Steps ---+++ Preparation 1 Load the Virtuoso Conductor (<code>http://&lt;cname&gt;:&lt;port&gt;/conductor</code>, e.g., <code>[[http://demo.openlinksw.com:8890/conductor][http://demo.openlinksw.com:8890/conductor]]</code>) in your web browser. 1 Log in as any user with DBA privileges, such as the default <b><code>dba</code></b>. 1 Drill down to 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>HR</code>") that exposes the <code>TABLEs</code> and <code>VIEWs</code> for this exercise. 1 Enter the <b>Base URL</b> beneath which the tables and their data will be found, after Linked Data View generation and publication (e.g., <code>[[http://demo.openlinksw.com:8890/HR][http://demo.openlinksw.com:8890/HR]]</code>). %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_02.png" style="wikiautogen"/>%BR%%BR% 1 Select the specific <code>TABLEs</code> and <code>VIEWs</code> containing the data you want to publish as Linked Data. ---+++ Option A - One-Click Generation and Publication 1 Click <b>Generate & Publish</b> to automatically generate the Linked Data Views. %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_03.png" style="wikiautogen"/>%BR%%BR% 1 Click <b>Execute</b> and Virtuoso will: %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_08.png" style="wikiautogen"/>%BR%%BR% 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. ---+++ Option B - Customized Generation and Publication 1 Click <b>Generate via Wizard</b> to customize the automatically generated Linked Data Views before publication. %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. For example, select the "Edit" link for table <code>HR..COUNTRIES</code>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_04.png" style="wikiautogen"/>%BR%%BR% 1 If you want images or other binary data in MIME formats to be revealed as anything other than generic "binary objects", you must map these 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. %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_05.png" style="wikiautogen"/>%BR%%BR% 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. 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: %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_07.png" style="wikiautogen"/>%BR%%BR% * Data Source Ontology Rules * Instance Data Rules 1 Select the desired option(s) and click the "Prepare to Execute" button which unveils a generated Instance Data and/or Ontology form. 1 Click the <b>Execute</b> button and Virtuoso will: %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_08.png" style="wikiautogen"/>%BR%%BR% 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. ---++ Results The Conductor will display a page like this -- %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_09.png" style="wikiautogen"/>%BR%%BR% You can now -- * 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% * 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% * Click on the <b>Ontology</b> link to view the ontology information. %BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_12.png" style="wikiautogen"/>%BR%%BR% ---++ Related * [[VirtRDFViewsOracleHrDb][RDF-based Linked Data View atop Oracle using the demonstration 'Human Resources' database]] * [[VirtRDFViewsOracleHrDbDemo][Live Demo]]

sioc:id

e1fb0987f69bd104eca926513da5cc90

sioc:link

n2:VirtOraRDFViewUI

sioc:has_container

n6:VOS

atom:title

VirtOraRDFViewUI

atom:source

n6:VOS

atom:author

n12:this

atom:published

2017-06-13T05:45:18Z

atom:updated

2018-12-26T09:50:41Z