<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="14. RDF Data Access and Data Management" />
<meta name="dc.subject" content="14. RDF Data Access and Data Management" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="rdfandsparql.html" title="Chapter Contents" />
<link rel="prev" href="rdfviewsenterpr.html" title="Examples of Linked Data Views" />
<link rel="next" href="virtuososponger.html" title="RDFizer Middleware (Sponger)" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>14. RDF Data Access and Data Management</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="rdfinsertmethods" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>14. RDF Data Access and Data Management</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="rdfandsparql.html">Chapter Contents</a> | <a class="link" href="rdfviewsenterpr.html" title="Examples of Linked Data Views">Prev</a> | <a class="link" href="virtuososponger.html" title="RDFizer Middleware (Sponger)">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div class="selected">
<a href="rdfandsparql.html">RDF Data Access and Data Management</a>
</div>
<br />
<div>
<a href="rdfdatarepresentation.html">Data Representation</a>
</div>
<div>
<a href="rdfsparql.html">SPARQL</a>
</div>
<div>
<a href="sparqlextensions.html">Extensions</a>
</div>
<div>
<a href="rdfgraphsecurity.html">RDF Graphs Security</a>
</div>
<div>
<a href="rdfviews.html">Linked Data Views over RDBMS Data Source</a>
</div>
<div>
<a href="rdfrdfviewgnr.html">Automated Generation of RDF Views over Relational Data Sources</a>
</div>
<div>
<a href="rdfviewsenterpr.html">Examples of Linked Data Views</a>
</div>
<div class="selected">
<a href="rdfinsertmethods.html">RDF Insert Methods in Virtuoso</a>
<div>
<a href="#rdfinsertmethodsapifunct" title="Using API functions">Using API functions</a>
<a href="#rdfinsertmethodshttppost" title="SPARQL endpoint REST API">SPARQL endpoint REST API</a>
<a href="#rdfinsertmethodshttpput" title="HTTP PUT using Content-Type: application/rdf+xml">HTTP PUT using Content-Type: application/rdf+xml</a>
<a href="#rdfinsertmethodsload" title="SPARQL Insert using LOAD">SPARQL Insert using LOAD</a>
<a href="#rdfindertmethodsparqlendpoint" title="SPARQL Insert via /sparql endpoint">SPARQL Insert via /sparql endpoint</a>
<a href="#rdfinsertmethodsparqlqueryandodswiki" title="SPARQL Insert via SPARQL endpoint REST API and ODS wiki">SPARQL Insert via SPARQL endpoint REST API and ODS wiki</a>
<a href="#rdfinsertmethodwebdav" title="Using WebDAV">Using WebDAV</a>
<a href="#rdfinsertmethodvirtuosocrawler" title="Using Virtuoso Crawler">Using Virtuoso Crawler</a>
<a href="#rdfinsertmethodsparqlqueryandsponger" title="Using SPARQL Query and Sponger (i.e. we Sponge the Resources in the FROM Clause or values for the graph-uri parameter in SPARQL protocol URLs)">Using SPARQL Query and Sponger (i.e. we Sponge the Resources in the FROM Clause or values for the graph-uri parameter in SPARQL protocol URLs)</a>
<a href="#rdfinsertmethodplapis" title="Using Virtuoso PL APIs">Using Virtuoso PL APIs</a>
<a href="#rdfinsertmethodsimilerdfbankapi" title="Using SIMILE RDF Bank API">Using SIMILE RDF Bank API</a>
<a href="#rdfinsertmethodrdfnet" title="Using RDF NET">Using RDF NET</a>
<a href="#rdfinsertmethodproxy" title="Using the RDF Proxy (Sponger) Service">Using the RDF Proxy (Sponger) Service</a>
</div>
</div>
<div>
<a href="virtuososponger.html">RDFizer Middleware (Sponger)</a>
</div>
<div>
<a href="virtuosospongerfacetinstall.html">Virtuoso Faceted Browser Installation and configuration</a>
</div>
<div>
<a href="virtuosospongerfacent.html">Virtuoso Faceted Web Service</a>
</div>
<div>
<a href="rdfiridereferencing.html">Linked Data</a>
</div>
<div>
<a href="rdfsparqlrule.html">Inference Rules & Reasoning</a>
</div>
<div>
<a href="rdfsparqlgeospat.html">RDF and Geometry</a>
</div>
<div>
<a href="rdfperformancetuning.html">RDF Performance Tuning</a>
</div>
<div>
<a href="rdfnativestorageproviders.html">RDF Data Access Providers (Drivers)</a>
</div>
<div>
<a href="rdfgraphreplication.html">RDF Graph Replication</a>
</div>
<br />
</div>
<div id="text">
<a name="rdfinsertmethods" />
<h2>14.8. RDF Insert Methods in Virtuoso</h2>
<a name="rdfinsertmethodsapifunct" />
<h3>14.8.1. Using API functions</h3>
<ul>
<li>
<a href="rdfsparql.html#rdfapidataimportttlp">Using the DB.DBA.TTLP() function</a>
<ul>
<li>Note: use this function for loading Turtle</li>
</ul>
</li>
<li>
<a href="rdfsparql.html#rdfapidataimportttlpmt">Using the DB.DBA.TTLP_MT() function</a>
<ul>
<li>Note: use this function for loading triples from file on multiple threads</li>
</ul>
</li>
<li>
<a href="rdfsparql.html#rdfapidataimportxmlttlpmt">Using the DB.DBA.RDF_LOAD_RDFXML_MT() function</a>
<ul>
<li>Note: Use this function for loading large resources when transactional integrity is not important (loading of a single resource may take more than one transaction)</li>
</ul>
</li>
<li>
<a href="rdfsparql.html#rdfapidataimportttlphash">Using the DB.DBA.RDF_TTL2HASH() function</a>
<ul>
<li>Note: use this function to get dictionary of triples in 'long valmode'.</li>
</ul>
</li>
<li>
<a href="rdfsparql.html#rdfapidataimportloadrdfxml">Using the DB.DBA.RDF_LOAD_RDFXML() function</a>
<ul>
<li>For loading RDF/XML, the best way is to split the data to be loaded into
multiple streams and load these in parallel using this function.</li>
</ul>
</li>
</ul>
<p>See <a href="rdfperformancetuning.html#rdfperfloading">more details</a> for loading Performance Tuning specifics.</p>
<br />
<a name="rdfinsertmethodshttppost" />
<h3>14.8.2. SPARQL endpoint REST API</h3>
<p>With POST can be accomplished SPARQL Insert/Update etc.</p>
<p>The result is in the rdf_quad.</p>
<p>With GET Methods you can get the triples which are saved.</p>
<p>
<strong>Examples:</strong>
</p>
<p>
<strong>Example 1:</strong>
</p>
<p>Create a DAV collection xx for user demo with password demo.</p>
<p>Execute the following command:</p>
<div>
<pre class="programlisting">
curl -i -d "INSERT {<http://demo.openlinksw.com/DAV/home/demo_about.rdf>
<http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://rdfs.org/sioc/ns#User>}" -u "demo:demo"
-H "Content-Type: application/sparql-query" http://localhost:8890/DAV/xx/yy
</pre>
</div>
<p>The response should be:</p>
<div>
<pre class="programlisting">
HTTP/1.1 201 Created
Server: Virtuoso/05.00.3023 (Win32) i686-generic-win-32 VDB
Connection: Keep-Alive
Content-Type: text/html; charset=ISO-8859-1
Date: Fri, 28 Dec 2007 12:50:12 GMT
Accept-Ranges: bytes
MS-Author-Via: SPARQL
Content-Length: 0
</pre>
</div>
<p>The result in the DAV/xx location will be a new WebDAV resource with name "yy" containing the inserted RDF:</p>
<div>
<pre class="programlisting">
<?xml version="1.0" encoding="utf-8" ?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#">
<rdf:Description
rdf:about="http://demo.openlinksw.com/DAV/home/demo_about.rdf">
<ns0pred:type xmlns:ns0pred="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
rdf:resource="http://rdfs.org/sioc/ns#User"/>
</rdf:Description>
</rdf:RDF>
</pre>
</div>
<p>
<strong>Example 2:</strong>
</p>
<p>Create a DAV collection, for ex. with name "test" for user ( for ex. demo).</p>
<p>Execute the following command:</p>
<div>
<pre class="programlisting">
curl -i -d "INSERT IN GRAPH <http://mygraph.com>
{ <http://www.openlinksw.com/dataspace/kidehen@openlinksw.com#this>
<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
<http://rdfs.org/sioc/ns#User> .
<http://www.openlinksw.com/dataspace/kidehen@openlinksw.com#this>
<http://www.w3.org/2000/01/rdf-schema#label>
<Kingsley Uyi Idehen> .
<http://www.openlinksw.com/dataspace/kidehen@openlinksw.com#this>
<http://rdfs.org/sioc/ns#creator_of>
<http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1300>
} " -u "demo:demo" -H "Content-Type: application/sparql-query" http://localhost:8890/DAV/home/demo/test/myrq
</pre>
</div>
<p>As result the response will be:</p>
<div>
<pre class="programlisting">
HTTP/1.1 201 Created
Server: Virtuoso/05.00.3023 (Win32) i686-generic-win-32 VDB
Connection: Keep-Alive
Content-Type: text/html; charset=ISO-8859-1
Date: Thu, 20 Dec 2007 16:25:25 GMT
Accept-Ranges: bytes
MS-Author-Via: SPARQL
Content-Length: 0
</pre>
</div>
<p>Now let's check the inserted triples. Go to the sparql endpoint, i.e. http://localhost:8890/sparql and:</p>
<ul>
<li>Enter for Default Graph URI:
<div>
<pre class="programlisting">
http://mygraph.com
</pre>
</div>
</li>
<li>Enter in the Query area:
<div>
<pre class="programlisting">
SELECT * WHERE {?s ?p ?o}
</pre>
</div>
</li>
<li>Click the button "Run Query"</li>
<li>As result will be shown the inserted triples:
<div>
<pre class="programlisting">
s p o
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com#this http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://rdfs.org/sioc/ns#User
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com#this http://www.w3.org/2000/01/rdf-schema#label Kingsley
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com#this http://rdfs.org/sioc/ns#creator_of http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1300
</pre>
</div>
</li>
</ul>
<br />
<a name="rdfinsertmethodshttpput" />
<h3>14.8.3. HTTP PUT using Content-Type: application/rdf+xml</h3>
<p>The URI in a PUT request identifies the entity enclosed with the request. Therefore using HTTP PUT is a more useful and meaningful command than using POST (which is more about submitting data to a script).</p>
<p>
<strong>Example:</strong>
</p>
<p>Suppose there is myfoaf.rdf file with the following content:</p>
<div>
<pre class="programlisting">
<rdf:RDF xmlns="http://www.example/jose/foaf.rdf#"
xmlns:foaf="http://xmlns.com/foaf/0.1/"
xmlns:log="http://www.w3.org/2000/10/swap/log#"
xmlns:myfoaf="http://www.example/jose/foaf.rdf#"
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
<foaf:Person rdf:about="http://www.example/jose/foaf.rdf#jose">
<foaf:homepage rdf:resource="http://www.example/jose/"/>
<foaf:knows rdf:resource="http://www.example/jose/foaf.rdf#juan"/>
<foaf:name>Jose Jimen~ez</foaf:name>
<foaf:nick>Jo</foaf:nick>
<foaf:workplaceHomepage rdf:resource="http://www.corp.example/"/>
</foaf:Person>
<foaf:Person rdf:about="http://www.example/jose/foaf.rdf#juan">
<foaf:mbox rdf:resource="mailto:juan@mail.example"/>
</foaf:Person>
<foaf:Person rdf:about="http://www.example/jose/foaf.rdf#julia">
<foaf:mbox rdf:resource="mailto:julia@mail.example"/>
</foaf:Person>
<rdf:Description rdf:about="http://www.example/jose/foaf.rdf#kendall">
<foaf:knows rdf:resource="http://www.example/jose/foaf.rdf#edd"/>
</rdf:Description>
</rdf:RDF>
</pre>
</div>
<p>Now let's upload the myfoaf.rdf file to destination server demo.openlinksw.com for user demo:</p>
<div>
<pre class="programlisting">
curl -T myfoaf.rdf http://demo.openlinksw.com/DAV/home/demo/rdf_sink/myfoaf.rdf -u demo:demo
</pre>
</div>
<p>As result the response should be:</p>
<div>
<pre class="programlisting">
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<HTML>
<HEAD>
<TITLE>201 Created</TITLE>
</HEAD>
<BODY>
<H1>Created</H1>
Resource /DAV/home/demo/rdf_sink/ myfoaf.rdf has been created.
</BODY>
</HTML>
</pre>
</div>
<p>Then you can execute:</p>
<div>
<pre class="programlisting">
curl -F "query=SELECT DISTINCT ?p FROM <http://demo.openlinksw.com/DAV/home/demo/rdf_sink/> WHERE {?s ?p ?o}" http://demo.openlinksw.com/sparql
</pre>
</div>
<p>The result should be:</p>
<div>
<pre class="programlisting">
<?xml version="1.0" ?>
<sparql xmlns="http://www.w3.org/2005/sparql-results#" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.w3.org/2001/sw/DataAccess/rf1/result2.xsd">
<head>
<variable name="p"/>
</head>
<results distinct="false" ordered="true">
<result>
<binding name="p"><uri>http://www.w3.org/1999/02/22-rdf-syntax-ns#type</uri></binding>
</result>
<result>
<binding name="p"><uri>http://xmlns.com/foaf/0.1/nick</uri></binding>
</result>
<result>
<binding name="p"><uri>http://xmlns.com/foaf/0.1/name</uri></binding>
</result>
<result>
<binding name="p"><uri>http://xmlns.com/foaf/0.1/homepage</uri></binding>
</result>
<result>
<binding name="p"><uri>http://xmlns.com/foaf/0.1/knows</uri></binding>
</result>
<result>
<binding name="p"><uri>http://xmlns.com/foaf/0.1/workplaceHomepage</uri></binding>
</result>
<result>
<binding name="p"><uri>http://xmlns.com/foaf/0.1/mbox</uri></binding>
</result>
</results>
</sparql>
</pre>
</div>
<p>Other examples with curl:</p>
<div>
<pre class="programlisting">
curl -F "query=SELECT distinct ?Concept FROM <http://dbpedia.org> WHERE {?s a ?Concept} limit 10" http://dbpedia.org/sparql
</pre>
</div>
<div>
<pre class="programlisting">
curl -F "query=SELECT distinct ?Concept FROM <http://myopenlink.net/dataspace/person/kidehen> WHERE {?s a ?Concept} limit 10" http://demo.openlinksw.com/sparql
</pre>
</div>
<div>
<pre class="programlisting">
curl -F "query=SELECT distinct ?Concept FROM <http://data.openlinksw.com/oplweb/product_family/virtuoso> WHERE {?s a ?Concept} limit 10" http://demo.openlinksw.com/sparql
</pre>
</div>
<div>
<pre class="programlisting">
curl -F "query=SELECT distinct ?Concept FROM <http://openlinksw.com/dataspace/organization/openlink> WHERE {?s a ?Concept} limit 10" http://demo.openlinksw.com/sparql
</pre>
</div>
<br />
<a name="rdfinsertmethodsload" />
<h3>14.8.4. SPARQL Insert using LOAD</h3>
<p>SPARQL INSERT operation can be done using the LOAD features:</p>
<div>
<pre class="programlisting">
SPARQL INSERT INTO <..> { .... } [[FROM ...] { ... }]
SPARQL LOAD <x> [INTO <y>]
-- <ResourceURL> will be the Graph IRI of the loaded data:
SPARQL LOAD <ResourceURL>
</pre>
</div>
<p>Examples:</p>
<ol>
<li>Load from ISQL:
<div>
<pre class="programlisting">
SPARQL insert in graph <http://mygraph.com>
{
<http://myopenlink.net/dataspace/Kingsley#this>
<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
<http://rdfs.org/sioc/ns#User> .
<http://myopenlink.net/dataspace/Kingsley#this>
<http://rdfs.org/sioc/ns#id>
<Kingsley> .
<http://myopenlink.net/dataspace/Caroline#this>
<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
<http://rdfs.org/sioc/ns#User> .
<http://myopenlink.net/dataspace/Caroline#this>
<http://rdfs.org/sioc/ns#id>
<Caroline> .
<http://myopenlink.net/dataspace/Matt#this>
<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
<http://rdfs.org/sioc/ns#User> .
<http://myopenlink.net/dataspace/Matt#this>
<http://rdfs.org/sioc/ns#id>
<Matt> .
<http://myopenlink.net/dataspace/demo#this>
<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
<http://rdfs.org/sioc/ns#User> .
<http://myopenlink.net/dataspace/demo#this>
<http://rdfs.org/sioc/ns#id>
<demo> .};
</pre>
</div>
</li>
<li>Load from .rq file:
<ul>
<li>Create DAV collection which is visible to public, for ex: http://localhost:8890/DAV/tmp</li>
<li>Upload to the DAV collection the following file for ex. with name listall.rq and with the following content:
<div>
<pre class="programlisting">
SPARQL
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sioc: <http://rdfs.org/sioc/ns#>
SELECT ?x ?p ?o
FROM <http://mygraph.com>
WHERE
{
?x rdf:type sioc:User .
?x ?p ?o.
?x sioc:id ?id .
FILTER REGEX(str(?id), "^King")
}
ORDER BY ?x
</pre>
</div>
</li>
<li>Execute from ISQL the following command:
<div>
<pre class="programlisting">
SQL>SPARQL
load bif:concat ("http://", bif:registry_get("URIQADefaultHost"), "/DAV/tmp/listall.rq") into graph <http://myNewGraph.com>;
</pre>
</div>
<p>As result should be shown:</p>
<div>
<pre class="programlisting">
callret-0
VARCHAR
_______________________________________________________________________________
Load <http://localhost:8890/DAV/tmp/listall.rq> into graph <http://myNewGraph.com> -- done
1 Rows. -- 321 msec.
</pre>
</div>
</li>
</ul>
</li>
<li>Load from Resource URL:
<div>
<pre class="programlisting">
SQL> SPARQL LOAD <http://www.w3.org/People/Berners-Lee/card#i>;
callret-0
VARCHAR
_______________________________________________________________________________
Load <http://www.w3.org/People/Berners-Lee/card#i> into graph <http://www.w3.org/People/Berners-Lee/card#i> -- done
1 Rows. -- 703 msec.
SQL>
</pre>
</div>
</li>
</ol>
<br />
<a name="rdfindertmethodsparqlendpoint" />
<h3>14.8.5. SPARQL Insert via /sparql endpoint</h3>
<p>SPARQL INSERT operation can be sent to a web service endpoint as a single statement and executed in sequence.</p>
<p>
<strong>Example:</strong>
</p>
<p>Using the Virtuoso ISQL tool or using the /sparql UI at http://host:port/sparql, execute the following:</p>
<ul>
<li>Insert into graph http://BookStore.com 3 triples:
<div>
<pre class="programlisting">
SQL>SPARQL insert in graph <http://BookStore.com>
{ <http://www.dajobe.org/foaf.rdf#i> <http://purl.org/dc/elements/1.1/date> <1999-04-01T00:00:00> .
<http://www.w3.org/People/Berners-Lee/card#i> <http://purl.org/dc/elements/1.1/date> <1998-05-03T00:00:00> .
<http://www.w3.org/People/Connolly/#me> <http://purl.org/dc/elements/1.1/date> <2001-02-08T00:00:00> };
</pre>
</div>
</li>
<li>As result will be shown the message:
<div>
<pre class="programlisting">
SQL>Insert into <http://BookStore.com>
3 triples -- done
</pre>
</div>
</li>
<li>Next we will select all triples from the graph http://BookStore.com:
<div>
<pre class="programlisting">
SQL>SPARQL SELECT * FROM <http://BookStore.com> WHERE {?s ?p ?o};
</pre>
</div>
</li>
<li>As result will be shown:
<div>
<pre class="programlisting">
s p o
VARCHAR VARCHAR VARCHAR
_______________________________________________________________________________
http://www.w3.org/People/Berners-Lee/card#i http://purl.org/dc/elements/1.1/date 1998-05-03T00:00:00
http://www.w3.org/People/Connolly/#me http://purl.org/dc/elements/1.1/date 2001-02-08T00:00:00
http://www.dajobe.org/foaf.rdf#i http://purl.org/dc/elements/1.1/date 1999-04-01T00:00:00
3 Rows. -- 0 msec.
</pre>
</div>
</li>
<li>Now let's insert into graph another http://NewBookStore.com graph's values:
<div>
<pre class="programlisting">
SQL>SPARQL
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
INSERT INTO GRAPH <http://NewBookStore.com> { ?book ?p ?v }
WHERE
{ GRAPH <http://BookStore.com>
{ ?book dc:date ?date
FILTER ( xsd:dateTime(?date) < xsd:dateTime("2000-01-01T00:00:00")).
?book ?p ?v.
}
};
</pre>
</div>
</li>
<li>As result will be shown:
<div>
<pre class="programlisting">
callret-0
VARCHAR
_______________________________________________________________________________
Insert into <http://NewBookStore.com>, 2 triples -- done
</pre>
</div>
</li>
<li>Finally we will check the triples from the graph NewBookStore.com:
<div>
<pre class="programlisting">
SQL> SPARQL
SELECT *
FROM <http://NewBookStore.com>
WHERE {?s ?p ?o};
</pre>
</div>
</li>
<li>As result will be shown:
<div>
<pre class="programlisting">
s p o
VARCHAR VARCHAR VARCHAR
_______________________________________________________________________________
http://www.w3.org/People/Berners-Lee/card#i http://purl.org/dc/elements/1.1/date 1998-05-03T00:00:00
http://www.dajobe.org/foaf.rdf#i http://purl.org/dc/elements/1.1/date 1999-04-01T00:00:00
2 Rows. -- 10 msec.
</pre>
</div>
</li>
</ul>
<br />
<a name="rdfinsertmethodsparqlqueryandodswiki" />
<h3>14.8.6. SPARQL Insert via SPARQL endpoint REST API and ODS wiki</h3>
<p>With HTTP Post and ODS wiki can be written an rdf document and respectively to be performed over it INSERT/UPDATE action.</p>
<p>You can write to a file using SIOC terms for ODS-Wiki</p>
<p>You can check with sparql the inserted / updated triples in the Quad Store.</p>
<p>
<strong>Example:</strong>
</p>
<p>Suppose there is ODS user test3 with ODS password 1, which has testWiki wiki instance.</p>
<p>Execute the following:</p>
<div>
<pre class="programlisting">
curl -i -d "INSERT {<http://localhost:8890/dataspace/test3/wiki/testWiki> <http://atomowl.org/ontologies/atomrdf#contains> <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> . <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> <http://rdfs.org/sioc/ns#has_container> <http://localhost:8890/dataspace/test3/wiki/testWiki> . <http://localhost:8890/dataspace/test3/wiki/testWiki> <http://atomowl.org/ontologies/atomrdf#entry> <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> . <http://localhost:8890/dataspace/test3/wiki/testWiki> <http://rdfs.org/sioc/ns#container_of> <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> . <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> <http://rdfs.org/sioc/ns#topic> <http://localhost:8890/dataspace/test3/wiki/testWiki> . <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> <http://atomowl.org/ontologies/atomrdf#source> <http://localhost:8890/dataspace/test3/wiki/testWiki> . <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://rdfs.org/sioc/types#Comment> . <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://atomowl.org/ontologies/atomrdf#Entry> . <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> <http://www.w3.org/2000/01/rdf-schema#label> 'MyTest' . <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://atomowl.org/ontologies/atomrdf#Link> . <http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> <http://rdfs.org/sioc/ns#content> <test>}" -u "test3:1" -H "Content-Type: application/sparql-query" http://localhost:8890/DAV/home/test3/wiki/testWiki/MyTest
</pre>
</div>
<p>As result we should have 2 files created:</p>
<ul>
<li>In the user DAV folder "DAV/home/test3/wiki/testWiki/" will be created a file "MyTest" with type "application/sparql-query". You can view the content of this file from the Conductor UI or from the user's Briefcase UI, path "DAV/home/test3/wiki/testWiki". Its content will be:
<div>
<pre class="programlisting">
<?xml version="1.0" encoding="utf-8" ?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#">
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki"><ns0pred:entry xmlns:ns0pred="http://atomowl.org/ontologies/atomrdf#" rdf:resource="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"/></rdf:Description>
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"><ns0pred:label xmlns:ns0pred="http://www.w3.org/2000/01/rdf-schema#">MyTest</ns0pred:label></rdf:Description>
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"><ns0pred:type xmlns:ns0pred="http://www.w3.org/1999/02/22-rdf-syntax-ns#" rdf:resource="http://atomowl.org/ontologies/atomrdf#Link"/></rdf:Description>
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"><ns0pred:type xmlns:ns0pred="http://www.w3.org/1999/02/22-rdf-syntax-ns#" rdf:resource="http://rdfs.org/sioc/types#Comment"/></rdf:Description>
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"><ns0pred:type xmlns:ns0pred="http://www.w3.org/1999/02/22-rdf-syntax-ns#" rdf:resource="http://atomowl.org/ontologies/atomrdf#Entry"/></rdf:Description>
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"><ns0pred:has_container xmlns:ns0pred="http://rdfs.org/sioc/ns#" rdf:resource="http://localhost:8890/dataspace/test3/wiki/testWiki"/></rdf:Description>
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki"><ns0pred:container_of xmlns:ns0pred="http://rdfs.org/sioc/ns#" rdf:resource="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"/></rdf:Description>
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki"><ns0pred:contains xmlns:ns0pred="http://atomowl.org/ontologies/atomrdf#" rdf:resource="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"/></rdf:Description>
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"><ns0pred:content xmlns:ns0pred="http://rdfs.org/sioc/ns#">test</ns0pred:content></rdf:Description>
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"><ns0pred:topic xmlns:ns0pred="http://rdfs.org/sioc/ns#" rdf:resource="http://localhost:8890/dataspace/test3/wiki/testWiki"/></rdf:Description>
<rdf:Description rdf:about="http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest"><ns0pred:source xmlns:ns0pred="http://atomowl.org/ontologies/atomrdf#" rdf:resource="http://localhost:8890/dataspace/test3/wiki/testWiki"/></rdf:Description>
</rdf:RDF>
</pre>
</div>
</li>
<li>To the user's wiki instance will be added a new WikiWord "MyTest" with content the value of the SIOC term attribute "content":
<div>
<pre class="programlisting">
<http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest> <http://rdfs.org/sioc/ns#content> <test>
i.e. the content will be "test".
</pre>
</div>
</li>
</ul>
<p>Now let's check what data was inserted in the Quad Store:</p>
<ul>
<li>Go to the sparql endpoint, i.e. for ex. to http://localhost:8890/sparql</li>
<li>Enter for Default Graph URI:
<div>
<pre class="programlisting">
http://localhost:8890/DAV/home/test3/wiki/testWiki/MyTest
</pre>
</div>
</li>
<li>Enter for Query text:
<div>
<pre class="programlisting">
SELECT * WHERE {?s ?p ?o}
</pre>
</div>
</li>
<li>Click the "Run Query" button.</li>
<li>As result will be shown the inserted triples:
<div>
<pre class="programlisting">
s p o
http://localhost:8890/dataspace/test3/wiki/testWiki http://rdfs.org/sioc/ns#container_of http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest
http://localhost:8890/dataspace/test3/wiki/testWiki http://atomowl.org/ontologies/atomrdf#entry http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest
http://localhost:8890/dataspace/test3/wiki/testWiki http://atomowl.org/ontologies/atomrdf#contains http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest
http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://rdfs.org/sioc/types#Comment
http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://atomowl.org/ontologies/atomrdf#Entry
http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://atomowl.org/ontologies/atomrdf#Link
http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest http://www.w3.org/2000/01/rdf-schema#label MyTest
http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest http://rdfs.org/sioc/ns#has_container http://localhost:8890/dataspace/test3/wiki/testWiki
http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest http://rdfs.org/sioc/ns#content test
http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest http://rdfs.org/sioc/ns#topic http://localhost:8890/dataspace/test3/wiki/testWiki
http://localhost:8890/dataspace/test3/wiki/testWiki/MyTest http://atomowl.org/ontologies/atomrdf#source http://localhost:8890/dataspace/test3/wiki/testWiki
</pre>
</div>
</li>
</ul>
<br />
<a name="rdfinsertmethodwebdav" />
<h3>14.8.7. Using WebDAV</h3>
<p> Example using WebDAV (mount folder to DAV and dump; if this is the rdf_sink
the Quad Store is updated automatically, or you can load from DAV manually to quad store)</p>
<p>
<strong>Example:</strong>
</p>
<p>
<strong>Example 1: Using ODS Briefcase</strong>
</p>
<ul>
<li>Go to your ods location, for ex. http://localhost:8890/ods</li>
<li>Register user, for ex. user test1</li>
<li>Login if not already in ods</li>
<li>Go to ODS -> Briefcase</li>
<li>Go to ODS -> Briefcase</li>
<li>Click the "New folder" icon from the Main Briefcase horizontal navigation</li>
<li>Enter for name for ex. "mytest" and click the "Create" button.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Using Briefcase UI" src="../images/ui/uc6.png" />
</td>
</tr>
<tr>
<td>Figure: 14.8.7.1. Using Briefcase UI</td>
</tr>
</table>
</li>
<li>Go to folder "mytest" and click the click the "Upload" icon from the Main Briefcase horizontal navigation</li>
<li>Enter for name for ex. "mytest" and click the "Create" button.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Using Briefcase UI" src="../images/ui/uc7.png" />
</td>
</tr>
<tr>
<td>Figure: 14.8.7.1. Using Briefcase UI</td>
</tr>
</table>
</li>
<li>In the shown form set:
<ul>
<li>Destination: RDF Store</li>
<li>RDF graph name for ex. with the value: http://localhost:8890/DAV/home/test2/mytest/</li>
<li>Select URL or File. For ex. you can select the following file with name jose.rdf:
<div>
<pre class="programlisting">
<rdf:RDF xmlns="http://www.example/jose/foaf.rdf#"
xmlns:foaf="http://xmlns.com/foaf/0.1/"
xmlns:log="http://www.w3.org/2000/10/swap/log#"
xmlns:myfoaf="http://www.example/jose/foaf.rdf#"
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
<foaf:Person rdf:about="http://www.example/jose/foaf.rdf#jose">
<foaf:homepage rdf:resource="http://www.example/jose/"/>
<foaf:knows rdf:resource="http://www.example/jose/foaf.rdf#juan"/>
<foaf:name>Jose Jimen~ez</foaf:name>
<foaf:nick>Jo</foaf:nick>
<foaf:workplaceHomepage rdf:resource="http://www.corp.example/"/>
</foaf:Person>
<foaf:Person rdf:about="http://www.example/jose/foaf.rdf#juan">
<foaf:mbox rdf:resource="mailto:juan@mail.example"/>
</foaf:Person>
<foaf:Person rdf:about="http://www.example/jose/foaf.rdf#julia">
<foaf:mbox rdf:resource="mailto:julia@mail.example"/>
</foaf:Person>
<rdf:Description rdf:about="http://www.example/jose/foaf.rdf#kendall">
<foaf:knows rdf:resource="http://www.example/jose/foaf.rdf#edd"/>
</rdf:Description>
</rdf:RDF>
</pre>
</div>
</li>
</ul>
</li>
<li>You can also perform the steps from above by uploading the file in the rdf_sink
folder i.e. in Briefcase it will be with this path: DAV/home/test2/rdf_sink and respectively the "RDF graph name"
will have this value: http://host:port/DAV/home/username/rdf_sink/</li>
</ul>
<p>Execute from ISQL or from the SPARQL endpoint the following query:</p>
<div>
<pre class="programlisting">
SELECT * FROM <http://localhost:8890/DAV/home/test2/mytest/>
WHERE {?s ?p ?o}
</pre>
</div>
<p>As result should be shown:</p>
<div>
<pre class="programlisting">
s p o
http://www.example/jose/foaf.rdf#jose http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://xmlns.com/foaf/0.1/Person
http://www.example/jose/foaf.rdf#jose http://xmlns.com/foaf/0.1/nick Jo
http://www.example/jose/foaf.rdf#jose http://xmlns.com/foaf/0.1/name Jose Jimen~ez
http://www.example/jose/foaf.rdf#jose http://xmlns.com/foaf/0.1/knows http://www.example/jose/foaf.rdf#juan
http://www.example/jose/foaf.rdf#jose http://xmlns.com/foaf/0.1/homepage http://www.example/jose/
http://www.example/jose/foaf.rdf#jose http://xmlns.com/foaf/0.1/workplaceHomepage http://www.corp.example/
http://www.example/jose/foaf.rdf#kendall http://xmlns.com/foaf/0.1/knows http://www.example/jose/foaf.rdf#edd
http://www.example/jose/foaf.rdf#julia http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://xmlns.com/foaf/0.1/Person
http://www.example/jose/foaf.rdf#julia http://xmlns.com/foaf/0.1/mbox mailto:julia@mail.example
http://www.example/jose/foaf.rdf#juan http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://xmlns.com/foaf/0.1/Person
http://www.example/jose/foaf.rdf#juan http://xmlns.com/foaf/0.1/mbox mailto:juan@mail.example
</pre>
</div>
<p>
<strong>Example 2: Using Conductor UI</strong>
</p>
<ul>
<li>Go to Conductor UI, for ex. at http://localhost:8890/conductor</li>
<li>Login as dba user</li>
<li>Go to Linked Data -> Quad Store Upload
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Quad Store Upload" src="../images/ui/uc1.png" />
</td>
</tr>
<tr>
<td>Figure: 14.8.7.1. Quad Store Upload</td>
</tr>
</table>
</li>
<li>In the shown form click the "Browse" button in order to select a file, for ex.
the file jose.rdf and set the "RDF IRI*"
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Quad Store Upload" src="../images/ui/uc2.png" />
</td>
</tr>
<tr>
<td>Figure: 14.8.7.1. Quad Store Upload</td>
</tr>
</table>
</li>
<li>Click the "Upload" button.
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Quad Store Upload" src="../images/ui/uc3.png" />
</td>
</tr>
<tr>
<td>Figure: 14.8.7.1. Quad Store Upload</td>
</tr>
</table>
</li>
</ul>
<br />
<a name="rdfinsertmethodvirtuosocrawler" />
<h3>14.8.8. Using Virtuoso Crawler</h3>
<p>Using Virtuoso Crawler (which includes the Sponger options so you crawl
non-RDF but get RDF and this can go to the Quad Store)</p>
<p>
<strong>Example:</strong>
</p>
<p>Go to Conductor UI. For ex. at http://localhost:8890/conductor</p>
<p>Login as dba user</p>
<p>Go to tab Web Application Server</p>
<p>Go to tab Content Imports</p>
<p>Click the "New Target" button</p>
<p>In the shown form:</p>
<ul>
<li>Enter for "Target description": Tim Berners-Lee's electronic Business Card</li>
<li>Enter for "Target URL": http://www.w3.org/People/Berners-Lee/</li>
<li>Enter for "Copy to local DAV collection" for ex.: /DAV/home/demo/rdf_sink/</li>
<li>Choose from the list "Local resources owner": demo</li>
<li>Check the check.box with label "Store metadata".</li>
<li>Check all the check-boxes shown below the check-box "Store metadata".</li>
<li>Note: when selected "Convert Link", then all HREFs in the local stored content will be relative.</li>
<li>Click the button "Create".
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Using Virtuoso Crawler" src="../images/ui/rdfinsert1.png" />
</td>
</tr>
<tr>
<td>Figure: 14.8.8.1. Using Virtuoso Crawler</td>
</tr>
</table>
</li>
</ul>
<p>Click the button "Import Queues".</p>
<p>For "Robot target" with label "Tim Berners-Lee's electronic Business Card"
click the start link.</p>
<p>As result should be shown the number of the pages retrieved.</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Using Virtuoso Crawler" src="../images/ui/rdfinsert2.png" />
</td>
</tr>
<tr>
<td>Figure: 14.8.8.1. Using Virtuoso Crawler</td>
</tr>
</table>
<p>Now using the sparql endpoint with sponger option "Use only local data"
enter for Default Graph URI: http://www.w3.org/People/Berners-Lee and execute the following query: </p>
<div>
<pre class="programlisting">
SELECT *
FROM <http://www.w3.org/People/Berners-Lee>
WHERE {?s ?p ?o}
</pre>
</div>
<p>As result should be shown the following triples:</p>
<div>
<pre class="programlisting">
s p o
http://www.w3.org/People/Berners-Lee http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://xmlns.com/foaf/0.1/Document
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Answers for young people - Tim Berners-Lee
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Berners-Lee: Weaving the Web
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Declaration by Tim BL 28 Feb 1996 w.r.t. CDA challenge
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Errata - Berners-Lee: Weaving the Web
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Frequently asked questions by the Press - Tim BL
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Glossary - Weaving the Web - Berners-Lee
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Longer Bio for Tim Berners-Lee
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Michael Dertouzos has left us
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title The Future of the Web and Europe
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title The World Wide Web: Past, Present and Future
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title The World Wide Web: A very short personal history
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Tim Berners-Lee
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Tim Berners-Lee - 3Com Founders chair
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Tim Berners-Lee: Disclosures
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Tim Berners-Lee: WWW and UU and I
http://www.w3.org/People/Berners-Lee http://purl.org/dc/elements/1.1/title Tim Berners-Lee: WorldWideWeb, the first Web client
</pre>
</div>
<p>
<strong>Example: Use of schedular to interface Virtuoso Quad Store with PTSW using the following program:</strong>
</p>
<div>
<pre class="programlisting">
create procedure PTSW_CRAWL ()
{
declare xt, xp any;
declare content, headers any;
content := http_get ('http://pingthesemanticweb.com/export/', headers);
xt := xtree_doc (content);
xp := xpath_eval ('//rdfdocument/@url', xt, 0);
foreach (any x in xp) do
{
x := cast (x as varchar);
dbg_obj_print (x);
{
declare exit handler for sqlstate '*' {
log_message (sprintf ('PTSW crawler can not load : %s', x));
};
sparql load ?:x into graph ?:x;
update DB.DBA.SYS_HTTP_SPONGE set HS_LOCAL_IRI = x, HS_EXPIRATION = null WHERE HS_LOCAL_IRI = 'destMD5=' || md5 (x) || '&graphMD5=' || md5 (x);
commit work;
}
}
}
;
insert soft SYS_SCHEDULED_EVENT (SE_SQL, SE_START, SE_INTERVAL, SE_NAME)
values ('DB.DBA.PTSW_CRAWL ()', cast (stringtime ('0:0') as DATETIME), 60, 'PTSW Crawling');
</pre>
</div>
<div class="tip">
<div class="tiptitle">See Also:</div>
<p>
<a href="htmlconductorbar.html#contentcrawlerrdf">Other Methods to Set Up the Content Crawler for RDF gathering.</a>
</p>
</div>
<br />
<a name="rdfinsertmethodsparqlqueryandsponger" />
<h3>14.8.9. Using SPARQL Query and Sponger (i.e. we Sponge the Resources in the FROM Clause or values for the graph-uri parameter in SPARQL protocol URLs)</h3>
<p>
<strong>Example:</strong>
</p>
<p>Execute the following query: </p>
<div>
<pre class="programlisting">
SQL>SPARQL
SELECT ?id
FROM NAMED <http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/sioc.ttl>
OPTION (get:soft "soft", get:method "GET")
WHERE { GRAPH ?g { ?id a ?o } }
limit 10;
</pre>
</div>
<p>As result will be shown the retrieved triples:</p>
<div>
<pre class="programlisting">
id
VARCHAR
_______________________________________________________________________________
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com#this
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D
http://www.openlinksw.com/dataspace/person/kidehen@openlinksw.com#this
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/612
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/612
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/610
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/610
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/856
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/856
10 Rows. -- 20 msec.
</pre>
</div>
<br />
<a name="rdfinsertmethodplapis" />
<h3>14.8.10. Using Virtuoso PL APIs</h3>
<a name="rdfinsertmethodplapissimpleexample" />
<h4>14.8.10.1. Basic Sponger Cartridge Example</h4>
<p>In the example script we implement a basic mapper which maps a text/plain mime type
to an imaginary ontology, which extends the class Document from FOAF with properties 'txt:UniqueWords'
and 'txt:Chars', where the prefix 'txt:' we specify as 'urn:txt:v0.0:'.</p>
<div>
<pre class="programlisting">
use DB;
create procedure DB.DBA.RDF_LOAD_TXT_META
(
in graph_iri varchar,
in new_origin_uri varchar,
in dest varchar,
inout ret_body any,
inout aq any,
inout ps any,
inout ser_key any
)
{
declare words, chars int;
declare vtb, arr, subj, ses, str any;
declare ses any;
-- if any error we just say nothing can be done
declare exit handler for sqlstate '*'
{
return 0;
};
subj := coalesce (dest, new_origin_uri);
vtb := vt_batch ();
chars := length (ret_body);
-- using the text index procedures we get a list of words
vt_batch_feed (vtb, ret_body, 1);
arr := vt_batch_strings_array (vtb);
-- the list has 'word' and positions array , so we must divide by 2
words := length (arr) / 2;
ses := string_output ();
-- we compose a N3 literal
http (sprintf ('<%s> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Document> .\n', subj), ses);
http (sprintf ('<%s> <urn:txt:v0.0:UniqueWords> "%d" .\n', subj, words), ses);
http (sprintf ('<%s> <urn:txt:v0.0:Chars> "%d" .\n', subj, chars), ses);
str := string_output_string (ses);
-- we push the N3 text into the local store
DB.DBA.TTLP (str, new_origin_uri, subj);
return 1;
}
;
--
DELETE FROM DB.DBA.SYS_RDF_MAPPERS WHERE RM_HOOK = 'DB.DBA.RDF_LOAD_TXT_META';
INSERT SOFT DB.DBA.SYS_RDF_MAPPERS (RM_PATTERN, RM_TYPE, RM_HOOK, RM_KEY, RM_DESCRIPTION)
VALUES ('(text/plain)', 'MIME', 'DB.DBA.RDF_LOAD_TXT_META', null, 'Text Files (demo)');
-- here we set order to some large number so don't break existing mappers
update DB.DBA.SYS_RDF_MAPPERS set RM_ID = 2000 WHERE RM_HOOK = 'DB.DBA.RDF_LOAD_TXT_META';
</pre>
</div>
<ol>
<li>Paste the whole of this code into Conductor's iSQL interface and execute it to
define and register the cartridge.</li>
<li>Create a simple text document with a .txt extension. For ex. with name: summary.txt</li>
<li>The .txt file must now be made Web accessible. A simple way to do this is to expose it as a WebDAV
resource using Virtuoso's built-in WebDAV support:
<ol>
<li>Log in to Virtuoso's ODS Briefcase application;</li>
<li>Navigate to your Public folder;</li>
<li>Upload your text document, ensuring that the file extension is .txt, the MIME type is set to text/plain and the file permissions are rw-r--r--.</li>
<li>As result the file would be Web accessible via the URL http://cname/DAV/home/username/Public/summary.txt .</li>
<li>Note: you can also check our <a href="http://demo.openlinksw.com:8890/tutorial/hosting/ho_s_30/WebCalendar/tools/summary.txt">live demo</a>.</li>
</ol>
</li>
<li>To test the mapper we just use /sparql endpoint with option 'Retrieve remote
RDF data for all missing source graphs' to execute (for ex.):
<div>
<pre class="programlisting">
SELECT *
FROM <http://cname/DAV/home/username/Public/summary.txt>
WHERE {?s ?p ?o}
</pre>
</div>
</li>
<li>Click the "Run Query" button.</li>
<li>As result should be shown the found triples, for ex.:
<div>
<pre class="programlisting">
s p o
http://cname/DAV/home/username/Public/summary.txt http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://xmlns.com/foaf/0.1/Document
http://cname/DAV/home/username/Public/summary.txt urn:txt:v0.0:UniqueWords 47
http://cname/DAV/home/username/Public/summary.txt urn:txt:v0.0:Chars 625
</pre>
</div>
</li>
</ol>
<p>
<strong>Important: Setting Sponger Permissions</strong>
</p>
<p>In order to allow the Sponger to update the local RDF quad store with triples
constituting the sponged structured data, the role "SPARQL_SPONGE" must be granted to the
account "SPARQL", i.e., to the owner account of /sparql web service endpoint.
This should normally be the case. If not, you must manually grant this
permission. As with most Virtuoso DBA tasks, the Conductor provides the simplest means of
doing this.</p>
<div class="tip">
<div class="tiptitle">See Also:</div>
<ul>
<li>The <a href="fn_rdf_load_rdfxml.html">DB.DBA.RDF_LOAD_RDFXML</a> function to
parse the content of RDF/XML text.</li>
<li>The <a href="fn_ttlp_mt.html">DB.DBA.TTLP_MT</a> function to
parse TTL (TURTLE or N3 resource).</li>
<li>The <a href="fn_gz_file_open.html">gz_file_open</a> function to
retrieve content of a gzipped file and example for loading gzipped N3 and Turtle files.</li>
</ul>
</div>
<br />
<br />
<a name="rdfinsertmethodsimilerdfbankapi" />
<h3>14.8.11. Using SIMILE RDF Bank API</h3>
<p>Virtuoso implements the HTTP-based Semantic Bank API that enables client
applications to post to its RDF Triple Store. This method offers an alternative to
using Virtuoso/PL functions or WebDAV uploads as the triples-insertion mechanism.</p>
<p>
<strong>Example:</strong>
</p>
<p>From your machine go to Firefox->Tools->PiggyBank->My Semantic Bank Accounts</p>
<p>Add in the shown form:</p>
<ul>
<li>For bank: address: http://demo.openlinksw.com/bank</li>
<li>For account id: demo</li>
<li>For password: demo</li>
</ul>
<p>Go to http://demo.openlinksw.com/ods</p>
<p>Log in as user demo, password: demo</p>
<p>Go to the Weblog tab from the main ODS Navigation</p>
<p>Click on weblog instance name, for ex. "demo's Weblog".</p>
<p>When the weblog home page is loaded, click Alt + P.</p>
<p>As result is shown the "My PiggyBank" page with all the collected information
presented in items.</p>
<p>For several of the items add Tags from the form "Tag" shown for each of them.</p>
<p>As result should be shown the message "Last updated: [here goes the date value].</p>
<p>You can also click "Save" and "Publish" for these items.</p>
<p>Go to http://demo.openlinksw.com/sparql</p>
<p>Enter for the "Default Graph URI" field: http://simile.org/piggybank/demo</p>
<p>Enter for the "Query text" text-area:</p>
<div>
<pre class="programlisting">
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix sioc: <http://rdfs.org/sioc/ns#>
SELECT *
FROM <http://simile.org/piggybank/demo>
WHERE {?s ?p ?o}
</pre>
</div>
<p>Click "Run Query".</p>
<p>As results are shown the found results.</p>
<br />
<a name="rdfinsertmethodrdfnet" />
<h3>14.8.12. Using RDF NET</h3>
<p>
<strong>Example:</strong>
</p>
<p>Execute the following query:</p>
<div>
<pre class="programlisting">
SQL> SELECT DB.DBA.HTTP_RDF_NET ('sparql load
"http://www.openlinksw.com/dataspace/person/kidehen@openlinksw.com"
into graph <http://www.openlinksw.com/>');
</pre>
</div>
<p>As result should be shown:</p>
<div>
<pre class="programlisting">
callret
VARCHAR
_______________________________________________________
<?xml version="1.0" ?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:vcard="http://www.w3.org/2001/vcard-rdf/3.0#"
xmlns="http://example.org/book/" xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:ns="http://example.org/ns#">
<rdf:Description>
<callret-0>Load <http://www.openlinksw.com/dataspace/person/kidehen@openlinksw.com>
into graph <http://www.openlinksw.com/> -- done</callret-0>
</rdf:Description>
</rdf:RDF>
1 Rows. -- 1982 msec.
</pre>
</div>
<br />
<a name="rdfinsertmethodproxy" />
<h3>14.8.13. Using the RDF Proxy (Sponger) Service</h3>
<p>Triples can be inserted also using the Sponger Proxy URI Service. For more information
and examples see <a href="rdfsparql.html#rdfproxyservice">here</a>.</p>
<br />
<table border="0" width="90%" id="navbarbottom">
<tr>
<td align="left" width="33%">
<a href="rdfviewsenterpr.html" title="Examples of Linked Data Views">Previous</a>
<br />Examples of Linked Data Views</td>
<td align="center" width="34%">
<a href="rdfandsparql.html">Chapter Contents</a>
</td>
<td align="right" width="33%">
<a href="virtuososponger.html" title="RDFizer Middleware (Sponger)">Next</a>
<br />RDFizer Middleware (Sponger)</td>
</tr>
</table>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
847
