[Virtuoso-users] get all URIs in a owl:sameAs equivalence class

[Jörn Hees]

Hi,

i have a large list of URIs. For each i would like to get all URIs being in one 
owl:sameAs equivalence class with it.
I want to restrict this to the data which is already on the endpoint, so no 
sponging / federated queries.

What i tried:

Try:
```
select distinct * where {
  ?i (owl:sameAs|^owl:sameAs)* ?j .
  VALUES (?i) {(dbpedia:Germany)}
}
```
http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&qtxt=select+distinct+*+where+{%0D%0A++%3Fi+%28owl%3AsameAs|^owl%3AsameAs%29*+%3Fj+.%0D%0A++VALUES+%28%3Fi%29+{%28dbpedia%3AGermany%29}%0D%0A}&format=text%2Fhtml&timeout=30000&debug=on

Result:
```
Virtuoso 37000 Error TR...: transitive start not given

SPARQL query:
define sql:big-data-const 0 
#output-format:text/html
define sql:signal-void-variables 1 define input:default-graph-uri 
<http://dbpedia.org> select distinct * where {
  ?i (owl:sameAs|^owl:sameAs)* ?j .
  VALUES (?i) {(dbpedia:Germany)}
}
```



Try:
```
select distinct * where {
  ?i (owl:sameAs|^owl:sameAs)* ?j .
  FILTER( ?i=dbpedia:Germany )
}
```
http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&qtxt=select+distinct+*+where+{%0D%0A++%3Fi+%28owl%3AsameAs|^owl%3AsameAs%29*+%3Fj+.%0D%0A++FILTER%28+%3Fi%3Ddbpedia%3AGermany+%29%0D%0A}&format=text%2Fhtml&timeout=30000&debug=on

Result:
```
Virtuoso 42000 Error TN...: Exceeded 1000000000 bytes in transitive temp 
memory.  use t_distinct, t_max or more T_MAX_memory options to limit the search 
or increase the pool

SPARQL query:
define sql:big-data-const 0 
#output-format:text/html
define sql:signal-void-variables 1 define input:default-graph-uri 
<http://dbpedia.org> select distinct * where {
  ?i (owl:sameAs|^owl:sameAs)* ?j .
  FILTER( ?i=dbpedia:Germany )
}
```



Try:
```
DEFINE input:same-as "yes"
select distinct * where {
  ?i owl:sameAs ?j .
  VALUES (?i) {(dbpedia:Germany)}
}
```
http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&qtxt=DEFINE+input%3Asame-as+%22yes%22%0D%0Aselect+distinct+*+where+{%0D%0A++%3Fi+owl%3AsameAs+%3Fj+.%0D%0A++VALUES+%28%3Fi%29+{%28dbpedia%3AGermany%29}%0D%0A}&format=text%2Fhtml&timeout=30000&debug=on

Result:
```
i       j
http://dbpedia.org/resource/Germany     
http://www4.wiwiss.fu-berlin.de/eurostat/resource/countries/Deutschland
http://dbpedia.org/resource/Germany     
http://www4.wiwiss.fu-berlin.de/eurostat/resource/regions/Deutschland
http://dbpedia.org/resource/Germany     
http://www4.wiwiss.fu-berlin.de/factbook/resource/Germany
http://dbpedia.org/resource/Germany     http://rdf.freebase.com/ns/m.0345h
...

http://dbpedia.org/resource/Germany     http://dbpedia.org/resource/Germany
http://dbpedia.org/resource/Germany     http://dbpedia.org/resource/Montenegro 
// already reported on DBpedia mailing list
...
```

Problem: if i run this on our local endpoint (Virtuoso version 07.10.3207) i 
only get (even though if i manually query for `dbpedia:Germany owl:sameAs ?j` i 
get loads...):
```
i       j
http://dbpedia.org/resource/Germany     http://rdf.freebase.com/ns/m.0345h
```

Was this maybe updated recently?



Any other ideas or something obvious i'm missing?

Cheers,
Jörn


------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users