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

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

Subject Item

n16:this

foaf:made

n2:VOSSQL2RDF

Subject Item

n4:this

sioc:creator_of

n2:VOSSQL2RDF

Subject Item

n21:item

n20:services_of

n2:VOSSQL2RDF

Subject Item

n5:this

sioc:creator_of

n2:VOSSQL2RDF

Subject Item

n8:VOS

sioc:container_of

n2:VOSSQL2RDF

atom:entry

n2:VOSSQL2RDF

atom:contains

n2:VOSSQL2RDF

Subject Item

n2:VirtRDFOWLGeneration

sioc:links_to

n2:VOSSQL2RDF

Subject Item

n2:VOSIndex

sioc:links_to

n2:VOSSQL2RDF

Subject Item

n2:VirtRdb2RDFViewsGeneration

sioc:links_to

n2:VOSSQL2RDF

Subject Item

n2:VirtMSSQLLinkingObjects

sioc:links_to

n2:VOSSQL2RDF

Subject Item

n2:VOSSQL2RDF

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:41:13.292807

dcterms:modified

2017-06-29T07:35:28.018123

rdfs:label

VOSSQL2RDF

foaf:maker

n13:this n16:this

dc:title

VOSSQL2RDF

opl:isDescribedUsing

n18:rdf

sioc:has_creator

n5:this n4:this

sioc:content

%META:TOPICPARENT{name="VOSIndex"}% ---+Mapping SQL Data to Linked Data Views %TOC% ---++ Introduction Virtuoso uses a SPARQL-based Meta Schema Language to provide RDBMS-to-RDF mapping functionality (also described as, Linked Data Views of SQL data). The language is an extension of the SPARQL query language, meshed with Virtuoso's SPASQL (SPARQL-inside-SQL) functionality. The language enables you to declaratively map relational database schema tables, columns, rows, and foreign key relationships to Classes, Attributes, Relationships, and Instances (Objects/Entities/Individuals) defined by RDF Schemas or OWL Ontologies. The mapping process uses a special built-in Virtuoso function to generate IRIs / URIs in "Subject" or "Object" position of a SPARQL graph pattern, /en route/ to building a set of SQL compiler rules and optimizations for translating SPARQL queries into SQL on the fly. While the full power of the Meta Schema Language is always available to the advanced user, many users (both beginners and experts) will find that the more recently enabled [[VirtRdb2RDFViewsGeneration][Automated Generation of Linked Data Views]] is more than sufficient. ---++ Generating Linked Data Views from SQL data ---+++ Automated Generation of Linked Data Views over Relational Data Sources * [[VirtRdb2RDFViewsGeneration][Automated Generation of Linked Data Views]] ---+++ Manual Mapping Process The basic steps are as follows: 1 Identify the tables, views, and procedure views to be mapped. 1 Decide if you are performing a 1:1 mapping or a more customized mapping to a specific RDF Schema or Ontology. 1 Declare Virtuoso-URI-Generator functions for each Class in the target RDF Schema or Ontology. 1 Use the Virtuoso-URI-Generator functions in SPARQL graph patterns within the <code>ALTER QUAD STORAGE</code> part of a SPASQL-based mapping statement. 1 Check to ensure the <code>cartridges</code> VAD package is installed using the <code>System Admin -> Packages</code> tab of the Virtuoso Conductor, and if not select the <code>install</code> button to the right of the package to install for use. 1 Use Virtuoso's built-in URL-Rewrite Rules APIs (or Conductor UI) to publish the Linked Data URIs which result from the mapping above. ---++++ Manual Mapping Example * View [[VOSSQL2RDFMappingExample][an example of mapping]] the phpBB3 SQL schema to the classes defined by the SIOC and FOAF ontologies. ---++++ More Examples, Linking Remote Tables into Virtuoso (Commercial Edition only) * View [[VirtLinkRemoteTables][how to perform linking]] across several supported targets, including Oracle, SQL Server, DB2, Sybase, Informix, Ingres, <nop>MySQL, <nop>PostgreSQL, and other ODBC and JDBC data sources. ---+++ Sample Mapping Scripts for Various Purposes ---++++ Enterprise Data Access & Integration * [[VirtRDFViewTutorialNorthwind][RDF-based Linked Data View atop Virtuoso using Tutorial Northwind SQL Schema]] / [[VirtRDFViewTutorialNorthwindDemo][Live Demo]] * [[VirtRDFViewNorthwind][RDF-based Linked Data View atop Microsoft SQL Server using the Northwind Demo Database]] / [[VirtRDFViewNorthwindDemo][Live Demo]] * [[VirtRDFViewsOracleHrDb][RDF-based Linked Data View atop Oracle using the demonstration 'Human Resources' database]] / [[VirtRDFViewsOracleHrDbDemo][Live Demo]] * [[VirtRDFViewsDB2SampleDb][RDF-based Linked Data View atop DB2 using the demonstration 'Sample' database]] / [[VirtRDFViewsDB2SampleDbDemo][Live Demo]] * [[VirtRDFViewsInformixStoresDemo][RDF-based Linked Data View atop Informix using the demonstration 'Stores' database]] / [[VirtRDFViewsInformixStoresDemoLinks][Live Demo]] * [[VirtRDFViewsIngresTutDb][RDF-based Linked Data View atop Ingres using the demonstration 'Tutorial' database]] / [[VirtRDFViewsIngresTutDbDemo][Live Demo]] * [[VirtRDFViewsSybasePubs2Db][RDF-based Linked Data View atop Sybase using the demonstration 'pubs2' database]] / [[VirtRDFViewsSybasePubs2DbDemo][Live Demo]] * [[VirtRDFViewsProgressSQ89ISports][RDF-based Linked Data View atop Progress (SQL-89) using the demonstration 'iSports' database]] / [[VirtRDFViewsProgressSQ89ISportsDemo][Live Demo]] * [[VirtRDFViewsProgressSQ92ISports][RDF-based Linked Data View atop Progress (SQL-92) using the demonstration 'iSports' database]] / [[VirtRDFViewsProgressSQ92ISportsDemo][Live Demo]] ---++++ Linked Data Views of ODS Application Data * [[VOSODSViews][RDF-based Linked Data Views atop Enterprise Collaboration (ODS) SQL Schema]] / [[VOSODSViewsDemo][Live Demo]] * [[VOSeCRMViews][RDF-based Linked Data Views atop Socially enhanced CRM (ODS-eCRM) SQL Schema]] / [[VOSeCRMViewsDemo][Live Demo]] ---++++ Business Intelligence * [[VirtRDFViewTPCH][RDF-based Linked Data Views atop TPCH Benchmark SQL Schema]] / [[VirtRDFViewTPCHDemo][Live Demo]] * [[VirtRDFViewTPCD][RDF-based Linked Data Views atop TPCD Benchmark SQL Schema]] / [[VirtRDFViewTPCDDemo][Live Demo]] * [[VirtRDFViewsThalia][RDF-based Linked Data Views atop Thalia Benchmark SQL Schema]] / [[VirtRDFViewsThaliaDemo][Live Demo]] * [[VirtRDFViewMusicbrainz][RDF-based Linked Data Views atop MusicBrainz SQL Schema]] ---++++ Semi-Structured Content Examples * [[VirtRDFViewDocs][Virtuoso Product Documentation (DocBook) to RDF]] / [[VirtRDFViewDocsDemo][Live Demo]] * [[VirtRDFViewTutorial][Virtuoso Online Tutorials to RDF]] / [[VirtRDFViewTutorialDemo][Live Demo]] ---++++ Web 2.0 Platforms * [[VirtRDFViewPHPBB3][RDF-based Linked Data Views atop phpBB3 SQL Schema]] / [[VirtRDFViewPHPBB3Demo][Live Demo]] * [[VirtRDFViewWordpress][RDF-based Linked Data Views atop WordPress SQL Schema]] / [[VirtRDFViewWordpressDemo][Live Demo]] * [[VirtRDFViewMediaWiki][RDF-based Linked Data Views atop MediaWiki SQL Schema]] / [[VirtRDFViewMediaWikiDemo][Live Demo]] * [[VirtRDFViewDrupal][RDF-based Linked Data Views atop Drupal SQL Schema]] / [[VirtRDFViewDrupalDemo][Live Demo]] * [[VirtRDFViewBugzilla][RDF-based Linked Data Views atop Bugzilla SQL Schema]] ---++ How Do I ...? * [[NorthWindREF][...Use SPARQL to query RDF Linked Data View of Virtuoso's SQL based Demo Database (Northwind Schema)]] * [[SIOCRefTutorial][...Use SPARQL to query RDF Linked Data View of Virtuoso Online Tutorials SQL Schema]] * [[SIOCRefDocs][...Use SPARQL to query RDF Linked Data View of Virtuoso online Documentation SQL Schema]] * [[WordPressSIOCRef][...Use SPARQL to query RDF Linked Data View of WordPress SQL Schema]] * [[MediaWikiSIOCRef][...Use SPARQL to query RDF Linked Data View of MediaWiki SQL Schema]] * [[PHPBB3SIOCRef][...Use SPARQL to query RDF Linked Data View of phpBB SQL Schema]] * [[ECRMRef][...Use SPARQL to query RDF Linked Data View of Socially enhanced CRM (ODS eCRM SQL Schema)]] * [[http://ods.openlinksw.com/dataspace/dav/wiki/ODS/VOSODSSparqlSamples][...Use SPARQL to query RDF Linked Data Views of Enterprise Collaboration (ODS SQL Schema)]] ---++ Technical White Papers & Advanced Tutorials * [[VOSSQLRDF][Declarative Meta Schema Language for SQL Schema to RDF Ontology Mapping - White Paper]] * [[http://virtuoso.openlinksw.com/Whitepapers/html/rdf_views/virtuoso_rdf_views_example.html][Declarative Meta Schema Language for SQL Schema to RDF Ontology Mapping - Tutorial]] ---++ Screencast Demos * [[http://www.youtube.com/watch?v=bj7AbJ0ZYCk&feature=channel][Virtuoso Linked Data Views over RDBMS Data Sources - Part 1]] * [[http://www.youtube.com/watch?v=yXNlcISS0aY&feature=channel][Virtuoso Linked Data Views over RDBMS Data Sources - Part 2]]

sioc:id

0a3a92c552313b94d928c7fcb50cb2d5

sioc:link

n2:VOSSQL2RDF

sioc:has_container

n8:VOS

n20:has_services

n21:item

atom:title

VOSSQL2RDF

sioc:links_to

n2:VirtRDFViewPHPBB3 n2:VirtRDFViewDocs n2:VirtRDFViewDocsDemo n2:VirtRDFViewsDB2SampleDbDemo n2:VirtLinkRemoteTables n7:html n2:VirtRDFViewMediaWikiDemo n2:VirtRDFViewTPCD n2:VirtRDFViewsOracleHrDbDemo n2:MediaWikiSIOCRef n2:SIOCRefDocs n2:VirtRDFViewsOracleHrDb n2:VirtRDFViewNorthwind n2:VOSeCRMViews n2:VirtRDFViewsThaliaDemo n2:VirtRDFViewMusicbrainz n10:VOSODSSparqlSamples n2:VirtRDFViewTutorialDemo n2:VirtRDFViewTutorial n2:ECRMRef n2:VirtRDFViewsIngresTutDbDemo n14:channel n2:VirtRDFViewsDB2SampleDb n15:channel n2:WordPressSIOCRef n2:VirtRDFViewsInformixStoresDemoLinks n2:VirtRDFViewTutorialNorthwind n2:VirtRDFViewDrupal n2:VirtRDFViewsProgressSQ89ISportsDemo n2:VirtRDFViewBugzilla n2:VirtRDFViewsIngresTutDb n2:VOSODSViewsDemo n2:VirtRDFViewDrupalDemo n2:VirtRDFViewsProgressSQ92ISportsDemo n2:VirtRDFViewsSybasePubs2Db n2:VirtRDFViewsProgressSQ89ISports n2:VirtRDFViewTPCH n2:VOSODSViews n2:VirtRDFViewsProgressSQ92ISports n2:NorthWindREF n2:VirtRDFViewMediaWiki n2:VirtRDFViewsThalia n2:PHPBB3SIOCRef n2:VirtRDFViewsSybasePubs2DbDemo n2:VirtRDFViewsInformixStoresDemo n2:SIOCRefTutorial n2:VirtRDFViewWordpressDemo n2:VirtRDFViewTutorialNorthwindDemo n2:VirtRDFViewWordpress n2:VOSSQL2RDFMappingExample

atom:source

n8:VOS

atom:author

n16:this

atom:published

2017-06-13T05:41:13Z

atom:updated

2017-06-29T07:35:28Z

sioc:topic

n8:VOS

Subject Item

n2:VirtOracleLinkingObjects

sioc:links_to

n2:VOSSQL2RDF