How can I use SPARUL to add missing triples to a Named Graph? What? Use of SPARUL to add missing triples to a Named Graph. For example, an ontology/vocabulary extension.Why? A lot of ontologies and vocabularies started life prior to emergence of the Linked Data meme. As a result, many do not include rdfs:isDefinedBy relations (via triples) that associate Classes and Properties in an ontology with the ontology itself, using de-referencable URIs. The downside of this pattern is that Linked Data's follow-your-nose pattern isn't exploitable when viewing these ontologies e.g., when using contemporary Linked Data aware browsers, like the OpenLink Data Explorer, OpenLink iSPARQL Query Builder, Microsoft Pivot Viewer and others.How? If SPARUL privileges are assigned to SPARQL or other accounts associated with SPARQL Endpoint. Or via WebID protected SPARQL endpoint with SPARUL is granted to SPARQL or specific accounts or WebIDs in a group. SPARQL INSERT INTO <LocalNamedGraphIRI> { ?s rdfs:DefinedBy <LocalOntologyEntityURI>. ?o rdfs:isDefinedBy <http://www.w3.org/ns/auth/acl>. } FROM <ExtSourceNamedGraphIRI> WHERE { ?s a ?o } Example Load Quad Named Graph via Sponger based query: DEFINE get:soft "replace" SELECT DISTINCT * FROM <http://www.w3.org/ns/auth/acl#> WHERE { ?s ?p ?o }

Added Triples via SPARUL to Ontology Named Graph: SPARQL INSERT INTO <http://www.w3.org/ns/auth/acl#> { ?s rdfs:DefinedBy <http://www.w3.org/ns/auth/acl>. ?o rdfs:DefinedBy <http://www.w3.org/ns/auth/acl>. } FROM <http://www.w3.org/ns/auth/acl#> WHERE { ?s a ?o } Query result: callret-0 VARCHAR Insert into <http://www.w3.org/ns/auth/acl#>, 110 (or less) triples -- done No. of rows in result: 1 Via Conductor or Command-line iSQL courtesy of SPASQL execute the following statements: Remove an existing graph: SPARQL CLEAR GRAPH <http://www.w3.org/ns/auth/acl/> ; SPARQL CLEAR GRAPH <http://www.w3.org/ns/auth/acl> ; SPARQL CLEAR GRAPH <http://www.w3.org/ns/auth/acl#> ; Query result: callret-0 ANY Clear <http://www.w3.org/ns/auth/acl/> -- done No. of rows in result: 1 Query result: callret-0 ANY Clear <http://www.w3.org/ns/auth/acl> -- done No. of rows in result: 1 Query result: callret-0 ANY Clear <http://www.w3.org/ns/auth/acl#> -- done No. of rows in result: 1 Load a new graph: SPARQL LOAD <http://www.w3.org/ns/auth/acl> ; Query result: callret-0 VARCHAR Load <http://www.w3.org/ns/auth/acl> into graph <http://www.w3.org/ns/auth/acl> -- done No. of rows in result: 1 Add missing rdfs:isDefinedBy triples via SPARUL: SPARQL INSERT INTO <http://www.w3.org/ns/auth/acl> { ?s rdfs:DefinedBy <http://www.w3.org/ns/auth/acl>. ?o rdfs:DefinedBy <http://www.w3.org/ns/auth/acl>. } FROM <http://www.w3.org/ns/auth/acl> WHERE { ?s a ?o } ; Query result: callret-0 ANY Insert into <http://www.w3.org/ns/auth/acl>, 26 (or less) triples -- done No. of rows in result: 1 Verification: Access the following url: http://<cname>/describe/?uri=http://www.w3.org/ns/auth/acl

Related Virtuoso Tips and Tricks Collection SPARUL -- an Update Language For RDF Graphs Virtuoso Sponger OpenLink Data Explorer OpenLink iSPARQL Query Builder Microsoft Pivot Viewer