A new technical white paper about our declarative language for
SQL Schema to RDF Ontology Mapping has just been published.
What is this?
A declarative language adapted from SPARQL's graph pattern
language (N3/Turtle) for mapping SQL Data to RDF Ontologies. We
currently refer to this as a Graph Pattern based RDF VIEW
Definition Language.
Why is it important?
It provides an effective mechanism for exposing existing SQL
Data as virtual RDF Data Sets (Graphs) negating the data
duplication associated with generating physical RDF Graphs from SQL
Data en route to persistence in a dedicated Triple Store.
Enterprise applications (traditional and web based) and most Web
Applications (Web 1.0 and Web 2.0) sit atop relational databases,
implying that SQL/RDF model and data integration is an essential
element of the burgeoning "Data Web" (Semantic Web - Layer 1)
comprehension and adoption process.
In a nutshell, this is a quick route for non disruptive exposure
of existing SQL Data to SPARQL supporting RDF Tools and Development
Environments.
How does it work?
RDF Side
- locate one or more Ontologies (e.g FOAF, SIOC, AtomOWL, SKOS
etc.) that effectively defines the Concepts (Classes) and Terms
(Predicates) to be exposed via your RDF Graph
- Using the Virtuoso's RDF View Definition Language declare a
International Resource Identifier (or URI) for your Graph. Example:
CREATE GRAPH IRI("http://myopenlink.net/dataspace")
- Then create Classes (Concepts), Class Properties/Predicates
(Memb), and Class Instances (Inst) for the new Graph. Example:
CREATE IRI CLASS odsWeblog:feed_iri "http://myopenlink.net/dataspace/kidehen/weblog/MyFeeds" (
in memb varchar not null, in inst varchar not null)
SQL Side
- If Virtuoso isn't your SQL Data Store, Identify the ODBC or
JDBC SQL data source(s) containing the SQL data to be mapped to RDF
and then link the relevant tables into Virtuoso's Virtual DBMS
Layer
- Then use the RDF View Definition Language's graph pattern
feature to generate SQL to RDF Mapping Template for your Graph. As
shown in this
ODS Weblog -> AtomOWL Mapping example.
About this entry:
Author: Kingsley Uyi Idehen
Published: 10/18/2006 18:18 GMT-0500
Modified: 11/17/2006 18:24 GMT-0500
Tags: webservices , web2.0 , web20 , rdf , jdbc , sql , odbc , web30 , semanticweb , foaf , sioc , skos , sparql , socialnetworking , virtuoso , DataSpace , .net , dataspace , atom
Categories: Virtual Database ,
Data Access ,
SQL , Semantic Web , Content Syndication
Comment Status: 0
Comments
Permalink:
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1064