Clojurians Log v2

TIL rdfs:member for doing searches in e.g. Bags

SELECT ?al ?ql ?member
     WHERE {
       ?q dns:orthogonalHypernym ?a .
       ?q <> "zoo"@da .
       ?q dns:ontologicalType ?qo .
       ?qo rdfs:member dnc:Animal .
       ?qo rdfs:member dnc:Object .
       FILTER NOT EXISTS {
         ?qo rdfs:member dnc:Comestible .
       }
       ?a rdfs:label ?al .
       ?q rdfs:label ?ql .
     }

i.e. I don’t want to define a huge list of FILTER NOT EXISTS triples.

SELECT ?al ?ql ?member
     WHERE {
       ?q dns:orthogonalHypernym ?a .
       ?q <> "zoo"@da .
       ?q dns:ontologicalType ?qo .
       ?qo rdfs:member dnc:Animal .
       ?qo rdfs:member dnc:Object .
       MINUS {
         ?qo rdfs:member ?member . FILTER (?member != dnc:Animal && ?member != dnc:Object)
       }
       ?a rdfs:label ?al .
       ?q rdfs:label ?ql .
     }

i.e. Select all the ones with dnc:Animal and dnc:Object, and then remove any which have members that are not dnc:Animal or dnc:Object

Thank you @quoll! I’m so fortunate to have someone like you here.

Incidentally, I have asked GPT-4 to answer tougher questions than this, and it’s distressingly good at writing SPARQL

I had one SPARQL query that was really tough to figure out. I was proud of it, and I was convinced ChatGPT wouldn’t get it… only for it get it on the first try.

Right, I should probably reach for ChatGPT more often. Incidentally, these queries are actually for extracting data to test ChatGPT with 😛

lol

It seems that graphs and LLMs are what everyone in the RDF space is interested in at the moment

yup

Hm… it appears that the added MINUS clause makes the query take ages to finish, though… investigating

Sigh… yes, that can happen 😕 I knew this was possible, but didn’t know how big your dataset was

also, some DBs are better at these queries than others

Can also try:

SELECT ?al ?ql ?member
     WHERE {
       ?q dns:orthogonalHypernym ?a .
       ?q <> "zoo"@da .
       ?q dns:ontologicalType ?qo .
       ?qo rdfs:member dnc:Animal .
       ?qo rdfs:member dnc:Object .
       MINUS { ?qo rdfs:member ?member . FILTER (?member NOT IN(dnc:Animal, dnc:Object)) }
       ?a rdfs:label ?al .
       ?q rdfs:label ?ql .
     }

SELECT ?al ?ql ?member
     WHERE {
       ?q dns:orthogonalHypernym ?a .
       ?q <> "zoo"@da .
       ?q dns:ontologicalType ?qo .
       ?qo rdfs:member dnc:Animal .
       ?qo rdfs:member dnc:Object .
       FILTER (NOT EXISTS { ?qo rdfs:member ?member . FILTER (?member NOT IN(dnc:Animal, dnc:Object)) })
       ?a rdfs:label ?al .
       ?q rdfs:label ?ql .
     }

Sorry… getting offline now. I’m going to the airport for Strangeloop

OH! Have a good time!

I’m jealous

Ask chatgpt to optimize it? :)

What’s the vocabulary for dns / dnc in your examples? Your own ontology? Looks interesting :)