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.

Prerequisites

Steps

Preparation

  1. Load the Virtuoso Conductor (http://<cname>:<port>/conductor, e.g., http://demo.openlinksw.com:8890/conductor) in your web browser.
  2. Log in as any user with DBA privileges, such as the default dba.
  3. Drill down to the Linked Data -> Views tab of the Conductor. (In previous versions, this path was Database -> Linked Data Views.)



  4. Select the Database Name Qualifier (e.g., "HR") that exposes the TABLEs and VIEWs for this exercise.
  5. Enter the Base URL beneath which the tables and their data will be found, after Linked Data View generation and publication (e.g., http://demo.openlinksw.com:8890/HR).



  6. Select the specific TABLEs and VIEWs containing the data you want to publish as Linked Data.

Option A - One-Click Generation and Publication

  1. Click Generate & Publish to automatically generate the Linked Data Views.



  2. Click Execute and Virtuoso will:



    1. Apply the generated declarations (instance data and ontology) to your Virtuoso instance.
    2. Publish / Deploy declarations that expose the Wizard-generated Rewrite Rules and associated endpoints.

Option B - Customized Generation and Publication

  1. Click Generate via Wizard to customize the automatically generated Linked Data Views before publication.



  2. At this point, you are presented with the option to edit your column selection. For example, select the "Edit" link for table HR..COUNTRIES.



  3. 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 varbinary types to the appropriate MIME types like image/gif. To do so, select the Edit link for Binding/MIME Type of the relevant table columns.



    You can:
    • Leave the Binding/MIME Type literal; or
    • Set to skip, such that the column will not be used in RDF generation; or
    • Select the binary object value in order for the column to be referenced as binary.
  4. After finishing with your changes click the Save button, or cancel the changes and go back by clicking the Cancel button.
  5. Make sure you click the "Next" button.
  6. At this point, the Linked Data View Definition form will let you Select Generation Targets options:



    • Data Source Ontology Mappings
    • Instance Data View Mappings
    • VoID statistic
  7. Make sure you click the "Next" button.
  8. Based on your selections in the prior form, the Linked Data View Definition Deployment Options form will be offered:



    • Data Source Ontology Rules
    • Instance Data Rules
  9. Select the desired option(s) and click the "Prepare to Execute" button which unveils a generated Instance Data and/or Ontology form.
  10. Click the Execute button and Virtuoso will:



    1. Apply the generated declarations (instance data and ontology) to your Virtuoso instance.
    2. Publish / Deploy declarations that expose the Wizard-generated Rewrite Rules and associated endpoints.

Results

The Conductor will display a page like this --





You can now --

Related