Post

Author

Password

URI Delete Entry?

Title

Content

Bravo! A solution to the latest <a href="http://dannyayers.com/2011/04/11/Another-SPARQL-puzzle">SPARQL puzzle</a>.
<a href="http://twitter.com/#!/glenn_mcdonald">@glenn_mcdonald</a> found a way of getting the non-Roman-god solar system bodies:
<pre>PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wn: <http://www.w3.org/2006/03/wn/wn20/schema/>
PREFIX id: <http://wordnet.rkbexplorer.com/id/>

SELECT DISTINCT ?planet WHERE {
 ?s1 wn:memberMeronymOf id:synset-solar_system-noun-1 .
 ?s1 rdfs:label ?planet .
 OPTIONAL {
 ?s1 wn:containsWordSense ?ws1 .
 ?ws1 wn:word ?w .
 ?ws2 wn:word ?w .
 ?s2 wn:containsWordSense ?ws2 .
 ?s2 wn:hyponymOf id:synset-Roman_deity-noun-1 .
 }
 FILTER (!bound(?s2))
}
</pre>
Isolating just the planets looks to be out of reach using the <a href="http://wordnet.rkbexplorer.com/sparql/">WordNet endpoint</a> alone, but I guess that can be left as a challenge for federated query e.g. CONSTRUCTs from different datasets into a local store before SELECTing.
Update
From <a href="http://twitter.com/#!/RobVesse">RobVesse</a> -
Here's an even simpler query for yesterdays puzzle - still doesn't isolate real planets though
<pre>PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wn: <http://www.w3.org/2006/03/wn/wn20/schema/>

SELECT DISTINCT ?label WHERE 
{
 ?s1 wn:memberMeronymOf <http://wordnet.rkbexplorer.com/id/synset-solar_system-noun-1> .
 ?s1 rdfs:label ?label.
 OPTIONAL
 {
 ?s2 wn:hyponymOf <http://wordnet.rkbexplorer.com/id/synset-Roman_deity-noun-1> .
 ?s2 rdfs:label ?label.
 }
 FILTER (!BOUND(?s2))
}
</pre>
...plus...
Here's a soln using wordnet and dbpedia to show only planets not named after roman gods, requires a SPARQL 1.1 engine to run
<pre>PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wn: <http://www.w3.org/2006/03/wn/wn20/schema/>

SELECT DISTINCT ?label WHERE 
{
 SERVICE <http://wordnet.rkbexplorer.com/sparql/>
 {
 ?s1 wn:memberMeronymOf <http://wordnet.rkbexplorer.com/id/synset-solar_system-noun-1> .
 ?s1 rdfs:label ?label.
 }
 MINUS
 {
 SERVICE <http://wordnet.rkbexplorer.com/sparql/>
 {
 ?s2 wn:hyponymOf <http://wordnet.rkbexplorer.com/id/synset-Roman_deity-noun-1> .
 ?s2 rdfs:label ?label.
 }
 }
 BIND(URI(CONCAT("http://dbpedia.org/resource/", ?label)) AS ?dbpResource)
</pre>
Here's a suitable engine: <a href="http://www.dotnetrdf.org/demos/leviathan/">Leviathan</a> (a demo of the SPARQL Engine used in <a href="http://www.dotnetrdf.org/">dotNetRDF</a>).