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

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

Subject Item

n5:this

foaf:made

n2:VirtTipsAndTricksSPARQL11Update

Subject Item

n8:this

sioc:creator_of

n2:VirtTipsAndTricksSPARQL11Update

Subject Item

n20:item

n19:services_of

n2:VirtTipsAndTricksSPARQL11Update

Subject Item

n6:this

sioc:creator_of

n2:VirtTipsAndTricksSPARQL11Update

Subject Item

n7:VOS

sioc:container_of

n2:VirtTipsAndTricksSPARQL11Update

atom:entry

n2:VirtTipsAndTricksSPARQL11Update

atom:contains

n2:VirtTipsAndTricksSPARQL11Update

Subject Item

n2:VirtTipsAndTricksSPARQL11Update

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:49:02.828486

dcterms:modified

2017-06-29T07:41:44.025922

rdfs:label

VirtTipsAndTricksSPARQL11Update

foaf:maker

n5:this n13:this

dc:title

VirtTipsAndTricksSPARQL11Update

opl:isDescribedUsing

n24:rdf

sioc:has_creator

n6:this n8:this

sioc:content

%META:TOPICPARENT{name="VirtTipsAndTricksSPARQL11FeaturesExamplesCollection"}% ---+Virtuoso SPARQL 1.1. Update Examples %TOC% ---++What? This guide contains Virtuoso SPARQL 1.1. Update Usage example 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? Change existing graphs in the Quad Store. ---++How? SPARQL 1.1 Update provides these graph update operations ( [[http://www.w3.org/TR/2012/PR-sparql11-update-20121108/#graphUpdate][See more from the specification]] ): * [[VirtTipsAndTricksSPARQL11Insert][INSERT DATA]] -- adds some triples, given inline in the request, into a graph. This SHOULD create the destination graph if it does not exist. If the graph does not exist and it can not be created for any reason, then a failure MUST be returned. * [[VirtTipsAndTricksSPARQL11Delete][DELETE DATA]] -- removes some triples, given inline in the request, if the respective graph contains those. * The fundamental pattern-based actions for graph updates are INSERT and DELETE. These actions consist of groups of triples to be deleted and groups of triples to be added based on query patterns. The difference between INSERT / DELETE and INSERT DATA / DELETE DATA is that INSERT DATA and DELETE DATA do not substitute bindings into a template from a pattern. * [[VirtTipsAndTricksSPARQL11Load][LOAD]] -- reads the contents of a document representing a graph into a graph in the Graph Store. * [[VirtTipsAndTricksSPARQL11Clear][CLEAR]] -- removes all the triples in (one or more) graphs. Here are some examples showcasing Virtuoso's support for this functionality: ---+++Delete and Add a Triple to a Graph Example This example demonstrates two operations -- delete a triple and add a triple in the named graph identified by the IRI &lt;urn:sparql:tests:update&gt; : 1 Assume the following Raw Data Representation in Turtle: <verbatim> <#book1> <http://purl.org/dc/elements/1.1/title> "Fundamentals of Compiler Desing" . </verbatim> 1 Load the sample data: <verbatim> INSERT DATA { GRAPH <urn:sparql:tests:update> { <#book1> <http://purl.org/dc/elements/1.1/title> "Fundamentals of Compiler Design" . } } </verbatim> 1 Delete the triple from the graph: <verbatim> DELETE DATA { GRAPH <urn:sparql:tests:update> { <#book1> <http://purl.org/dc/elements/1.1/title> "Fundamentals of Compiler Design" } } </verbatim> 1 Insert a new triple to the graph: <verbatim> INSERT DATA { GRAPH <urn:sparql:tests:update> { <#book2> <http://purl.org/dc/elements/1.1/title> "Fundamentals of Compiler Design" } } </verbatim> 1 Query the graph data: <verbatim> SELECT * FROM <urn:sparql:tests:update> WHERE { ?s ?p ?o } </verbatim> 1 [[http://bit.ly/Ua3MHI][View the SPARQL Query Definition via SPARQL Protocol URL]] 1 [[http://bit.ly/UKCANo][View the SPARQL Query Results via SPARQL Protocol URL]] ---+++DELETE/Insert WITH Clause Usage Example This example demonstrates how to rename all people with the given name "Bill" to "William": 1 Assume the following Raw Data Representation in Turtle: <verbatim> <#president25> <http://xmlns.com/foaf/0.1/givenName> "Bill" . <#president25> <http://xmlns.com/foaf/0.1/foaf:familyName> "McKinley" . <#president27> <http://xmlns.com/foaf/0.1/foaf:givenName> "Bill" . <#president27> <http://xmlns.com/foaf/0.1/foaf:familyName> "Taft" . <#president42> <http://xmlns.com/foaf/0.1/foaf:givenName> "Bill" . <#president42> <http://xmlns.com/foaf/0.1/foaf:familyName> "Clinton" . </verbatim> 1 Load the sample data: <verbatim> INSERT DATA { GRAPH <urn:sparql:tests:update:insert:delete:with> { <#president25> <http://xmlns.com/foaf/0.1/givenName> "Bill" . <#president25> <http://xmlns.com/foaf/0.1/foaf:familyName> "McKinley" . <#president27> <http://xmlns.com/foaf/0.1/foaf:givenName> "Bill" . <#president27> <http://xmlns.com/foaf/0.1/foaf:familyName> "Taft" . <#president42> <http://xmlns.com/foaf/0.1/foaf:givenName> "Bill" . <#president42> <http://xmlns.com/foaf/0.1/foaf:familyName> "Clinton" . } } </verbatim> 1 Rename all people with the given name "Bill" to "William": <verbatim> WITH <urn:sparql:tests:update:insert:delete:with> DELETE { ?person <http://xmlns.com/foaf/0.1/givenName> 'Bill' } INSERT { ?person <http://xmlns.com/foaf/0.1/givenName> 'William' } WHERE { ?person <http://xmlns.com/foaf/0.1/givenName> 'Bill' } </verbatim> 1 Query the graph data: <verbatim> SELECT * FROM <urn:sparql:tests:update:insert:delete:with> WHERE { ?s ?p ?o } </verbatim> 1 [[http://bit.ly/WZVZbV][View the SPARQL Query Definition via SPARQL Protocol URL]] 1 [[http://bit.ly/11uJAgW][View the SPARQL Query Results via SPARQL Protocol URL]] ---+++DELETE/Insert WITH MODIFY Usage Example This example demonstrates use of MODIFY to alter the objects of a <code>schema:WebPage</code> relation using objects of a <code>foaf:homePage</code> relation. In this example, we have a constant relation subject identified the HTTP URI &lt;http://example.com/product/Sample1#this&gt; . 1 Assume the following Raw Data Representation in Turtle: <verbatim> <http://example.com/product/Sample1#this> <http://schema.org/WebPage> <http://sample1.com/index1> . <http://example.com/product/Sample2#this> <http://schema.org/WebPage> <http://sample2.com/index2> . <http://example.com/product/Sample3#this> <http://schema.org/WebPage> <http://sample3.com/index3> . <http://example.com/product/Sample4#this> <http://schema.org/WebPage> <http://sample4.com/index4> . <http://example.com/product/Sample5#this> <http://schema.org/WebPage> <http://sample5.com/index5> . </verbatim> 1 Load the sample data: <verbatim> INSERT DATA { GRAPH <urn:sparql:tests:update:insert:delete:modify:graph1> { <http://example.com/product/Sample1#this> <http://schema.org/WebPage> <http://sample1.com/index1> . <http://example.com/product/Sample2#this> <http://schema.org/WebPage> <http://sample2.com/index2> . <http://example.com/product/Sample3#this> <http://schema.org/WebPage> <http://sample3.com/index3> . <http://example.com/product/Sample4#this> <http://schema.org/WebPage> <http://sample4.com/index4> . <http://example.com/product/Sample5#this> <http://schema.org/WebPage> <http://sample5.com/index5> . } } </verbatim> 1 Assume the following Raw Data Representation in Turtle: <verbatim> <http://sample1.com/index1> <http://xmlns.com/foaf/0.1/homepage> <http://sample1.com/> . <http://sample2.com/index2> <http://xmlns.com/foaf/0.1/homepage> <http://sample2.com/> . <http://sample3.com/index3> <http://xmlns.com/foaf/0.1/homepage> <http://sample3.com/> . <http://sample4.com/index4> <http://xmlns.com/foaf/0.1/homepage> <http://sample4.com/> . <http://sample5.com/index5> <http://xmlns.com/foaf/0.1/homepage> <http://sample5.com/> . </verbatim> 1 Load the sample data: <verbatim> INSERT DATA { GRAPH <urn:sparql:tests:update:insert:delete:modify:graph2> { <http://sample1.com/index1> <http://xmlns.com/foaf/0.1/homepage> <http://sample1.com/> . <http://sample2.com/index2> <http://xmlns.com/foaf/0.1/homepage> <http://sample2.com/> . <http://sample3.com/index3> <http://xmlns.com/foaf/0.1/homepage> <http://sample3.com/> . <http://sample4.com/index4> <http://xmlns.com/foaf/0.1/homepage> <http://sample4.com/> . <http://sample5.com/index5> <http://xmlns.com/foaf/0.1/homepage> <http://sample5.com/> . } } </verbatim> 1 Replace schema:WebPage objects with foaf:home objects values: <verbatim> PREFIX schema: <http://schema.org/> PREFIX foaf: <http://xmlns.com/foaf/0.1/> MODIFY <urn:sparql:tests:update:insert:delete:modify:graph1> DELETE { <http://example.com/product/Sample1#this> schema:WebPage ?s . } INSERT { <http://example.com/product/Sample1#this> schema:WebPage ?ns . } WHERE { GRAPH <urn:sparql:tests:update:insert:delete:modify:graph1> { <http://example.com/product/Sample1#this> schema:WebPage ?s . } GRAPH <urn:sparql:tests:update:insert:delete:modify:graph2> { ?s foaf:homepage ?ns . } } </verbatim> 1 Query the graph data: <verbatim> SELECT * FROM <urn:sparql:tests:update:insert:delete:modify:graph1> WHERE { ?s ?p ?o . FILTER (?s = <http://example.com/product/Sample1#this>) . } </verbatim> 1 [[http://bit.ly/1EuDfaP][View the SPARQL Query Definition via SPARQL Protocol URL]] 1 [[http://bit.ly/1srjQyX][View the SPARQL Query Results via SPARQL Protocol URL]] ---++Related * [[http://www.w3.org/TR/2012/PR-sparql11-update-20121108/#graphUpdate][SPARQL 1.1 Update]] * [[http://www.w3.org/TR/2012/PR-sparql11-update-20121108/#deleteInsert][SPARQL 1.1. DELETE/INSERT + WITH clause]] * [[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]]

sioc:id

3ec550276ce4f9839894324d164b2ef7

sioc:link

n2:VirtTipsAndTricksSPARQL11Update

sioc:has_container

n7:VOS

n19:has_services

n20:item

atom:title

VirtTipsAndTricksSPARQL11Update

sioc:links_to

n2:VirtTipsAndTricksSPARQL11Clear n10:html n14:1srjQyX n15:deleteInsert n16: n14:1EuDfaP n14:WZVZbV n2:VirtTipsAndTricksSPARQL11Insert n14:11uJAgW n14:Ua3MHI n14:UKCANo n17:WebPage n15:graphUpdate n2:VirtTipsAndTricksSPARQL11Load n2:VirtTipsAndTricksSPARQL11FeaturesExamplesCollection n22:html n2:VirtTipsAndTricksSPARQL11Delete

atom:source

n7:VOS

atom:author

n5:this

atom:published

2017-06-13T05:49:02Z

atom:updated

2017-06-29T07:41:44Z

sioc:topic

n7:VOS