@prefix rdf: . @prefix ns1: . @prefix foaf: . ns1:this rdf:type foaf:Person . @prefix atom: . rdf:type atom:Feed . @prefix sioct: . rdf:type sioct:Weblog . @prefix rdfs: . rdfs:label "kidehen@openlinksw.com's BLOG [127] description" . rdf:type atom:Entry , sioct:BlogPost . @prefix dc: . dc:title "Virtuoso's SQL Schema to RDF Ontology Mapping Language (1.0)" ; foaf:maker ns1:this ; rdfs:label "Virtuoso's SQL Schema to RDF Ontology Mapping Language (1.0)" . @prefix dt: . @prefix dcterms: . dcterms:created "2006-10-18T18:18:00-04:00"^^dt:dateTime ; dcterms:modified "2006-11-17T18:24:25-05:00"^^dt:dateTime . @prefix sioc: . sioc:id "a946aa13935a788edf4ba185277dd30f" ; sioc:link ; sioc:content "A new technical white paper about our declarative language for SQL Schema to RDF Ontology Mapping has just been published.\n\nWhat is this?\nA 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.\n\nWhy is it important?\nIt 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. \n\nEnterprise 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.\n\nIn a nutshell, this is a quick route for non disruptive exposure of existing SQL Data to SPARQL supporting RDF Tools and Development Environments.\n\nHow does it work?\nRDF Side\n\nlocate 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\n\nUsing 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") \nThen 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" (\n in memb varchar not null, in inst varchar not null)\n\n\nSQL Side\n\nIf 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\n\nThen 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.\n\n" ; atom:title "Virtuoso's SQL Schema to RDF Ontology Mapping Language (1.0)" . @prefix ns10: . sioc:has_creator ns10:this ; sioc:has_container . @prefix ns11: . sioc:links_to ns11:MappingOdsBlogToAtomOwlExample ; atom:source ; atom:author ns1:this ; atom:published "2006-10-18T22:18:00Z" ; atom:updated "2006-11-17T23:24:25Z" . @prefix opl: . opl:isDescribedUsing . ns10:this rdf:type sioc:User . @prefix rdf: . @prefix ns1: . @prefix foaf: . ns1:this rdf:type foaf:Person ; foaf:made . @prefix atom: . rdf:type atom:Feed . @prefix sioct: . rdf:type sioct:Weblog . @prefix rdfs: . rdfs:label "kidehen@openlinksw.com's BLOG [127] description" . @prefix sioc: . sioc:container_of ; atom:entry ; atom:contains . @prefix ns7: . ns7:this rdf:type sioc:User ; sioc:creator_of .