Q: Can INSERT { GRAPH <> { }} be used in EDG?

[Tim Smith]

Hi,

I am refactoring an ontology and I intended to use INSERT/DELETE queries to make it easier.  However, when I execute the following query, I receive the error below:

Is the error valid in that I cannot insert into a designated graph from the SPARQL query window?  Does this same restriction hold for the SPARQL endpoint?  How do I move things between graphs in EDG?

Thanks,

Tim

PS:  Being able to use Crtl-<Enter> to execute a query is so much better! Thanks for adding that in 6.4.

{"message":"Exception while fetching data (/sparql) : INSERT can only modify the default graph 

 INSERT {

  GRAPH <urn:x-evn-master:schema_equipment> {
    ?s rdfs:subClassOf edg:Sensor .
  }
}
WHERE {
   ?s rdfs:subClassOf pgont:Sensor .
}

Error(s):

• {"message":"Exception while fetching data (/sparql) : INSERT can only modify the default graph","locations":[{"line":2,"column":21}],"path":["sparql"]}

Query: mutation sparqlUpdate($sparql: String!) { sparql(query: $sparql) report { diff results { message severity focusNode { label uri } path pathLabel value { label uri } constraintComponentName suggestions { message confidence applyData } } } commit(message:"Update from SPARQL Query panel", strict: false)}

Variables: {"sparql":"PREFIX afn: <http://jena.hpl.hp.com/ARQ/function#>\nPREFIX arg: <http://spinrdf.org/arg#>\nPREFIX bbase: <http://ontologies.pg.com/businessbase#>\nPREFIX crosswalkprojects: <http://teamwork.topbraidlive.org/crosswalkprojects#>\nPREFIX dash: <http://datashapes.org/dash#>\nPREFIX data: <http://data.pg.com/data/>\nPREFIX datatype: <http://qudt.org/vocab/datatype/>\nPREFIX dc: <http://purl.org/dc/elements/1.1/>\nPREFIX dcam: <http://purl.org/dc/dcam/>\nPREFIX dct: <http://purl.org/dc/terms/>\nPREFIX dimprop: <http://ontologies.pg.com/dimensionandproperties#>\nPREFIX dtype: <http://www.linkedmodel.org/schema/dtype#>\nPREFIX edg.c: <http://edg.topbraid.solutions/controller/>\nPREFIX edg.glossary: <http://edg.topbraid.solutions/glossary/>\nPREFIX edg.sqoop: <http://edg.topbraid.solutions/model/sqoop/>\nPREFIX edg.v: <http://edg.topbraid.solutions/view/>\nPREFIX edg: <http://edg.topbraid.solutions/model/>\nPREFIX fn: <http://www.w3.org/2005/xpath-functions#>\nPREFIX foaf: <http://xmlns.com/foaf/0.1/>\nPREFIX gen: <http://ontologies.pg.com/general#>\nPREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>\nPREFIX gr: <http://purl.org/goodrelations/v1#>\nPREFIX graphql: <http://datashapes.org/graphql#>\nPREFIX html: <http://uispin.org/html#>\nPREFIX metadata: <http://topbraid.org/metadata#>\nPREFIX ontologyprojects: <http://teamwork.topbraidlive.org/ontologyprojects#>\nPREFIX org: <http://www.w3.org/ns/org#>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\nPREFIX owlTime: <http://www.w3.org/2006/time#>\nPREFIX p1: <http://example.org/file1#>\nPREFIX pgont: <http://ontologies.pg.com/pgontology/>\nPREFIX prov: <http://www.w3.org/ns/prov#>\nPREFIX quantity: <http://qudt.org/vocab/quantity/>\nPREFIX quantitykind: <http://qudt.org/vocab/quantitykind/>\nPREFIX qudt-refdata: <http://qudt.org/vocab/refdata/>\nPREFIX qudt.type: <http://qudt.org/vocab/type/>\nPREFIX qudt: <http://qudt.org/schema/qudt/>\nPREFIX raci: <http://topbraid.org/raci#>\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nPREFIX rdm: <http://rdm.topbraidlive.org/rdm/>\nPREFIX rdmfact: <http://topbraid.org/rdmfact#>\nPREFIX rdmprojects: <http://rdm.topbraidlive.org/rdmprojects#>\nPREFIX refdata: <http://ontologies.pg.com/refdata#>\nPREFIX s3: <http://topbraid.org/s3#>\nPREFIX search: <http://topbraid.org/search#>\nPREFIX sh: <http://www.w3.org/ns/shacl#>\nPREFIX sioc: <http://rdfs.org/sioc/ns#>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>\nPREFIX smf: <http://topbraid.org/sparqlmotionfunctions#>\nPREFIX softwareprojects: <http://teamwork.topbraidlive.org/software/softwareprojects#>\nPREFIX sp: <http://spinrdf.org/sp#>\nPREFIX sparql: <http://datashapes.org/sparql#>\nPREFIX spif: <http://spinrdf.org/spif#>\nPREFIX spin: <http://spinrdf.org/spin#>\nPREFIX spl: <http://spinrdf.org/spl#>\nPREFIX spr: <http://spinrdf.org/spr#>\nPREFIX swa: <http://topbraid.org/swa#>\nPREFIX swash: <http://topbraid.org/swash#>\nPREFIX taggerprojects: <http://evn.topbraidlive.org/taggerprojects#>\nPREFIX taxonomies: <http://evn.topbraidlive.org/evnprojects#>\nPREFIX teamwork: <http://topbraid.org/teamwork#>\nPREFIX teamworkconstraints: <http://topbraid.org/teamworkconstraints#>\nPREFIX tops: <http://www.topbraid.org/tops#>\nPREFIX tosh: <http://topbraid.org/tosh#>\nPREFIX ui: <http://uispin.org/ui#>\nPREFIX unit: <http://qudt.org/vocab/unit/>\nPREFIX vaem: <http://www.linkedmodel.org/schema/vaem#>\nPREFIX vcard: <http://www.w3.org/2006/vcard/>\nPREFIX voag: <http://voag.linkedmodel.org/voag/>\nPREFIX vs: <http://www.w3.org/2003/06/sw-vocab-status/ns#>\nPREFIX wot: <http://xmlns.com/wot/0.1/>\nPREFIX wp: <http://ontologies.pg.com/v1.0/workprocess#>\nPREFIX xml: <http://www.w3.org/XML/1998/namespace>\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\n\nINSERT {\n GRAPH <urn:x-evn-master:schema_equipment> {\n ?s rdfs:subClassOf edg:Sensor .\n }\n}\nWHERE {\n ?s rdfs:subClassOf pgont:Sensor . \n}\n"}

Service URL: graphql/schema_equipment/generic?message=Update_from_SPARQL_Query_panel

   Ok   

[Holger Knublauch]

On 1/07/2020 06:29, Tim Smith wrote:

Hi,

I am refactoring an ontology and I intended to use INSERT/DELETE queries to make it easier.  However, when I execute the following query, I receive the error below:

Is the error valid in that I cannot insert into a designated graph from the SPARQL query window? 

Yes, that panel is only meant for the currently active graph. That is the one that the user has access to and where the change history would be recorded. Manipulating some other graph would not go into the change history.

Does this same restriction hold for the SPARQL endpoint?

No. You can modify any graph there.

  How do I move things between graphs in EDG?

We have some partial solutions, but only a combination of them may do what you need:

- Transform tab > Copy or Move Instances from Other Asset Collection

- Source code panel (cut/paste between two browser tabs, then save both)

- SPARQL updates

I am sure there is a lot of room for improvements here. Could you elaborate a bit on what type of data you are trying to move?

Holger

--
You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/CAF0WbnKb4CXbGasM1Q2j_p4tfJJuNnPZb%3Dpyn0EEO01i0MTKYw%40mail.gmail.com.

[Tim Smith]

Hi Holger,

In this case, I was aligning some of my ontologies with EDG ontologies, e.g. changing the inheritance hierarchies, converting some of the property shapes, etc...  I was able to accomplish what I needed by making the target graph the current graph and importing the necessary graphs for the purpose of the insert.

Overall, I've made good use of the batch operation capabilities in TBC or direct insert/delete operations to move things between graphs or change namespaces.  Ontologies are always evolving and eventually need to be refactored so moving a class and it's property shapes, etc... to another graph is a common use case.  Another common use case is to create a "mapping graph" in which I create a number of helper classes and instances to assist in mapping data sources (typically XLSX or CSV) into an ontology.  I run an insert query to create the instances (or new schema) and insert the results into a target graph.  I think I can do the same in EDG by making the target graph the current graph and import everything there,removing the imports when the insert is complete.

TIm

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/1cfdc63f-d7b4-57ca-2965-56084ca9b0af%40topquadrant.com.

[Holger Knublauch]

On 1/07/2020 11:23, Tim Smith wrote:

Hi Holger,

In this case, I was aligning some of my ontologies with EDG ontologies, e.g. changing the inheritance hierarchies, converting some of the property shapes, etc...  I was able to accomplish what I needed by making the target graph the current graph and importing the necessary graphs for the purpose of the insert.

Overall, I've made good use of the batch operation capabilities in TBC or direct insert/delete operations to move things between graphs or change namespaces.  Ontologies are always evolving and eventually need to be refactored so moving a class and it's property shapes, etc... to another graph is a common use case.

Are you using multiple namespaces, and one namespace per graph? I am asking because that's a pattern that I have used for refactorings in the past: If a class and its shapes should have been in another graph, I first changed their namespace (prefix) and then had them written out to Sorted Turtle where it would then be easier to cut and past snippets into the target graph. Of course it would be better to skip that manual step and we could offer a "clean up by namespace" feature that moves all triples into the correct home graphs of their namespace. Would that have worked for your refactoring?

  Another common use case is to create a "mapping graph" in which I create a number of helper classes and instances to assist in mapping data sources (typically XLSX or CSV) into an ontology.  I run an insert query to create the instances (or new schema) and insert the results into a target graph.  I think I can do the same in EDG by making the target graph the current graph and import everything there,removing the imports when the insert is complete.

Yes, I guess working in the right active graph will put the triples to where they belong.

FWIW here is a new alternative approach for importing Excel and CSV (and JSON, XML etc) that may not require intermediate RDF representations: http://datashapes.org/active/import.html

Holger

To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/CAF0WbnJ1cAKcp93N%3D%2B50DEOEByyPGnh8AXC2FvGjm3OQhe2j0Q%40mail.gmail.com.