%META:TOPICPARENT{name="VirtTipsAndTricksSPARQL11FeaturesExamplesCollection"}%

---+Virtuoso SPARQL 1.1. ADD Usage Examples 

%TOC%

---++What?
This guide contains Virtuoso SPARQL 1.1. ADD Usage examples queries which you can run against any SPARQL endpoint that supports SPARQL 1.1 and the ability to allow a verified user perform INSERT operations. 

---++Why?
Use as shortcut for inserting all data from an input graph into a destination graph. <b>Note</b> that the original content in the destination graph if any, is kept intact.

---++How?

Here are some examples showcasing Virtuoso's support for this functionality:


---+++ADD Example

This example adds all triples from a named graph identified by the IRI &lt;urn:sparql:tests:add:data&gt; to a named graph identified by the IRI &lt;urn:sparql:tests:add2:data&gt;

   1 Assume the following Raw Data Representation in Turtle:
<verbatim>
<http://example/william> a <http://xmlns.com/foaf/0.1/Person> ;
                         <http://xmlns.com/foaf/0.1/givenName> "William" ; 
                         <http://xmlns.com/foaf/0.1/mbox>      <mailto:bill@example> . 
</verbatim>
   1 Load the sample data into &lt;urn:sparql:tests:add:data&gt;:
<verbatim>
INSERT DATA
  { 
    GRAPH <urn:sparql:tests:add:data> 
      { 
        <http://example/william> a <http://xmlns.com/foaf/0.1/Person> ;
                                 <http://xmlns.com/foaf/0.1/givenName> "William" ; 
                                 <http://xmlns.com/foaf/0.1/mbox> <mailto:bill@example> . 
      } 
  }
</verbatim>
   1 Query graph &lt;urn:sparql:tests:add:data&gt; data: 
<verbatim>
SELECT * 
FROM <urn:sparql:tests:add:data> 
WHERE 
  {
    ?s ?p ?o
  }
</verbatim>
      * [[http://bit.ly/13LBF5y][View the SPARQL Query Definition via SPARQL Protocol URL]];
      * [[http://bit.ly/XmhkRB][View the SPARQL Query Results via SPARQL Protocol URL]]
   1 Assume the following Raw Data Representation in Turtle:
<verbatim>
<http://example/fred> a <http://xmlns.com/foaf/0.1/Person> .
</verbatim>
   1 Load the sample data into &lt;urn:sparql:tests:add2:data&gt;:
<verbatim>
INSERT DATA
  { 
    GRAPH <urn:sparql:tests:add2:data> 
      { 
        <http://example/fred> a <http://xmlns.com/foaf/0.1/Person> .
      } 
  }
</verbatim>
   1 Query graph &lt;urn:sparql:tests:add2:data&gt; data: 
<verbatim>
SELECT * 
FROM <urn:sparql:tests:add2:data> 
WHERE 
  {
    ?s ?p ?o
  }
</verbatim>
      * [[http://bit.ly/14IFvfr][View the SPARQL Query Definition via SPARQL Protocol URL]];
      * [[http://bit.ly/14AahH9][View the SPARQL Query Results via SPARQL Protocol URL]]
   1 Add all triples from &lt;urn:sparql:tests:add:data&gt; to &lt;urn:sparql:tests:add2:data&gt;
<verbatim>
ADD GRAPH <urn:sparql:tests:add:data> TO <urn:sparql:tests:add2:data>;
</verbatim>
   1 Equivalent variant is:
<verbatim>
INSERT 
  { 
    GRAPH <urn:sparql:tests:add2:data> { ?s ?p ?o } 
  } 
WHERE 
  { 
    GRAPH <urn:sparql:tests:add:data> { ?s ?p ?o } 
}
</verbatim>
   1 Query graph &lt;urn:sparql:tests:add2:data&gt; data: <b>Note</b> that the original content in &lt;urn:sparql:tests:add2:data&gt; is kept intact by the <code>ADD</code> operation:
<verbatim>
SELECT * 
FROM <urn:sparql:tests:add2:data> 
WHERE 
  {
    ?s ?p ?o
  }
</verbatim>
      * [[http://bit.ly/14IFvfr][View the SPARQL Query Definition via SPARQL Protocol URL]];
      * [[http://bit.ly/14AahH9][View the SPARQL Query Results via SPARQL Protocol URL]]


---++Related

   * [[http://www.w3.org/TR/2012/PR-sparql11-update-20121108/#add][SPARQL 1.1 ADD]]
   * [[VirtTipsAndTricksGuideRenameGraph][Rename RDF Graph Example]]
   * [[http://www.w3.org/TR/rdf-sparql-protocol/][SPARQL Protocol (HTTP based Query Service)]]  
   * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]
   * [[VirtTipsAndTricksSPARQL11FeaturesExamplesCollection][Virtuoso SPARQL 1.1 Usage Examples Collection]]
   * [[http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_9/SPARQL_Tutorials_Part_9.html][Virtuoso SPARQL 1.1 Syntax Tutorial]]
   * [[http://docs.openlinksw.com/virtuoso/rdfsparql.html][Virtuoso Documentation]]