<docbook><section><title>VirtTipsAndTricksGuideSPARQLSingleMultipleExecution</title><para> </para>
<title>SPARQL/SPARUL/SPARQL-BI Operations Guide for Executing Queries Combined in Single or Multiple Statements</title>SPARQL/SPARUL/SPARQL-BI Operations Guide for Executing Queries Combined in Single or Multiple Statements
<para>The following guide presents various operations lists depending on either is allowed multiple or single execution of the statements.</para>
<para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h2">Items that could be listed one after other with and without semicolon</bridgehead>
<itemizedlist mark="bullet" spacing="compact"><listitem>SPARQL 1.1: <itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="VirtTipsAndTricksSPARQL11Create">CREATE</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksSPARQL11Drop">DROP</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksSPARQL11Clear">CLEAR</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksSPARQL11Load">LOAD</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksSPARQL11RefDataINSTCONST">INSERT</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksSPARQL11Insert">INSERT DATA</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksSPARQL11Update">INSERT/DELETE DATA</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksSPARQL11Delete">DELETE DATA</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksSPARQL11Copy">COPY</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksSPARQL11Move">MOVE</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksSPARQL11Add">ADD</ulink> </listitem>
</itemizedlist></listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparul">SPARUL</ulink>: <itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulexamples2">CREATE</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulexamples2">DROP</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulexamples10">CLEAR</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulexamples8">LOAD</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulexamples4">INSERT</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulexamples3">DELETE</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulexamples13">MODIFY</ulink> </listitem>
</itemizedlist></listitem>
<listitem>SPARQL-BI: <itemizedlist mark="bullet" spacing="compact"><listitem>LOAD SERVICE DATA</listitem>
</itemizedlist></listitem>
</itemizedlist><para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">Example</bridgehead>
<programlisting>
DELETE from &lt;http://semantica.globo.com/tvg/&gt; { 
&lt;http://semantica.globo.com/tvg/programa/11&gt; ?p ?o . 
} 
WHERE { 
&lt;http://semantica.globo.com/tvg/programa/11&gt; ?p ?o . 
}  

INSERT DATA INTO &lt;http://semantica.globo.com/tvg/&gt; { 
&lt;http://semantica.globo.com/tvg/programa/11&gt;
&lt;http://semantica.globo.com/tvg/cor_hover_tvg&gt; &quot;#d39016&quot; . 
} 
</programlisting><para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h2">Items that could not be combined with others</bridgehead>
<itemizedlist mark="bullet" spacing="compact"><listitem>SPARQL <itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfdefaultgraph">SELECT</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/rdfsparql.html#anytimequeriessparqlex">CONSTRUCT</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsqlfromsparqldescribe">DESCRIBE</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparqlaggregateexamples6">ASK</ulink> </listitem>
</itemizedlist></listitem>
<listitem>SPARQL-BI <itemizedlist mark="bullet" spacing="compact"><listitem>DROP MACRO LIBRARY </listitem>
<listitem>QUAD MAP CONFIGURATION</listitem>
</itemizedlist></listitem>
</itemizedlist><para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h2">Single Quad Map Configuration Operator</bridgehead>
<para>A single quad map configuration operator can consist of many parts separated by dots:</para>
<itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="http://docs.openlinksw.com/virtuoso/rdfviewsrdbms.html#rdfviewiriclasses">CREATE IRI CLASS</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/rdfviewsrdbms.html#rdfviewbijandreturns">CREATE LITERAL CLASS</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/rdfviewsrdbms.html#rdfviewsubclasses">CREATE LITERAL SUBCLASS</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfviewsandfreetext">CREATE QUAD STORAGE</ulink> (with tree of dot-delimited declarations inside) </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/rdfviewsrdbms.html#splitrdfview">ALTER QUAD STORAGE</ulink> (with tree of dot-delimited declarations inside) </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/rdfviewsrdbms.html#rdfviewconfiguringrdfstorages">DROP QUAD STORAGE</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/r2rml.html#r2rmlgenlviewisql">DROP QUAD MAP</ulink></listitem>
</itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">Example</bridgehead>
<programlisting>CREATE IRI CLASS oplsioc:grantee_iri using
  function DB.DBA.GRANTEE_URI (in id integer)
    returns varchar,
  function DB.DBA.GRANTEE_URI_INVERSE (in id_iri varchar)
    returns integer .

CREATE IRI CLASS oplsioc:user_iri &quot;http://myhost/sys/user?id=%d&quot;
  (in uid integer not null) .
  
CREATE LITERAL CLASS example:isbn_ref &quot;%s&quot; (in isbn varchar not null)
  option ( bijection, returns &quot;%u-%u-%u-%u&quot; union &quot;%u-%u-%u-X&quot; )
  
MAKE oplsioc:user_iri SUBCLASS OF oplsioc:grantee_iri .    

ALTER QUAD STORAGE virtrdf:DefaultQuadStorage
  :
  FROM isports_rdf.prs10_isports_rdf.VRef_Call      as Ref_Call_tbl
  FROM isports_rdf.prs10_isports_rdf.VRef_Call      as Ref_Call_tbl_1
  :
{
  :
  refcall:ref-call_iri (Ref_Call_tbl.Call_Num) a refcall:Ref-Call as
virtrdf:ref-call_pk ;
  :
  refcall:has_parent  refcall:ref-call_iri (Ref_Call_tbl_1.Call_Num)
where  ( ^{Ref_Call_tbl.}^.Parent    = ^{Ref_Call_tbl_1.}^.Call_Num )   as
virtrdf:Ref-Call_has_parent .

</programlisting><para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h2">Related</bridgehead>
<para> </para>
<itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="VirtTipsAndTricksSPARQL11FeaturesExamplesCollection">SPARQL 1.1. Features Examples Collection</ulink> </listitem>
<listitem><ulink url="VOSArticleBISPARQL2">Business Intelligence Extensions for SPARQL</ulink> </listitem>
<listitem><ulink url="http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_11/SPARQL_Tutorials_Part_11.html">Virtuoso SPARQL-BI Examples Collection</ulink> </listitem>
<listitem><ulink url="VirtSPARQLReasoningTutorial">Tutorial Demonstrating Reasoning via SPARQL</ulink> </listitem>
<listitem><ulink url="http://www.w3.org/TR/2010/WD-sparql11-property-paths-20100126/">SPARQL 1.1. Property Paths</ulink> </listitem>
<listitem><ulink url="http://www.w3.org/TR/sparql11-query/#inline-data">SPARQL inline data via use of VALUES clause</ulink> </listitem>
<listitem><ulink url="http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_9/SPARQL_Tutorials_Part_9.html">Virtuoso SPARQL 1.1 Syntax Tutorial</ulink> </listitem>
<listitem><ulink url="http://www.w3.org/TR/2010/WD-sparql11-query-20100126/#subqueries">SPARQL 1.1 Subqueries</ulink> </listitem>
<listitem><ulink url="http://www.w3.org/TR/sparql11-query/">SPARQL 1.1 Specification</ulink> </listitem>
<listitem><ulink url="http://www.w3.org/TR/rdf-sparql-protocol/">SPARQL Protocol (HTTP based Query Service)</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/rdfsparql.html">Virtuoso Documentation</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksGuide">Virtuoso Tips and Tricks Collection</ulink> </listitem>
<listitem><ulink url="VirtTipsAndTricksGuideRenameGraph">Rename RDF Graph Example</ulink> </listitem>
</itemizedlist></section></docbook>