Re: [Virtuoso-users] Request for optimize virtuoso.ini configuration files

2010-02-03 Thread Patrick van Kleef
Hi Marc-Alexandre, I've a huge amount a triples in N3 format and some triples can have very large literals (Complete Genbank in N3 and some literals are complete sequences). The total amount of triples is above 6 billions and uncompressed data is around 700 gigabytes. I just can't find a way to

[Virtuoso-users] Request for optimize virtuoso.ini configuration files

2010-02-03 Thread Marc-Alexandre Nolin
Hello, I've a huge amount a triples in N3 format and some triples can have very large literals (Complete Genbank in N3 and some literals are complete sequences). The total amount of triples is above 6 billions and uncompressed data is around 700 gigabytes. I just can't find a way to completely loa

Re: [Virtuoso-users] Randomness in a SPARQL results

2010-02-03 Thread Marc-Alexandre Nolin
Hello, is there a fundamental difference between these 2 queries? The first one take 10 seconds to get an answer, the second one take almost 6 hours to answer. My repository have the following indexes in it: Index Name Unique TypeColumns New Index RDF_QUAD_GOPS No

Re: [Virtuoso-users] [Dbpedia-discussion] DBpedia on local Virtuoso server

2010-02-03 Thread Hugh Williams
Hi Piero, Good to hear of your success using the Virtuoso RDF bulk loader scripts for loading the DBpedia datasets. Their is a know issue with the Conductor RDF -> Graphs tab failing to displays graphs when their are many to display which is scheduled to be fixed ... Posting reply to DBpedi

Re: [Virtuoso-users] Get all paths between two URIs with transitivity.

2010-02-03 Thread Nathan
give this one a go :) SELECT ?x ?predicate ?y ?via ?dist ?path WHERE { { SELECT * WHERE { ?x rdf:type . ?x ?predicate ?y . filter( isURI(?y) ) . ?y rdf:type } } OPTION ( TRANSITIVE, T_DISTINCT, T_NO_CYCLES, t_in(?x), t_out(?y), t_mi

Re: [Virtuoso-users] Get all paths between two URIs with transitivity.

2010-02-03 Thread Nathan
sorry; seem to have lost some of that email somehow :s correction: then changed the transitivity options to T_DISTINCT, and removed T_DIRECTION , removing it lets the optimizer pick what's best. also here are some docs: inference rules and reasoning in virtuoso: http://docs.openlinksw.com/virtuo

Re: [Virtuoso-users] Get all paths between two URIs with transitivity.

2010-02-03 Thread Peter Ansell
Thanks for that example. It looks to be very useful. I did a similar test on one of the Bio2RDF databases ( http://obo.bio2rdf.org/sparql ) and I am just wondering what it means to have the predicate is unbound in one of the result sets, as I don't necessarily just want to find paths using a pa

Re: [Virtuoso-users] Get all paths between two URIs with transitivity.

2010-02-03 Thread Peter Ansell
How do I find arbitrary paths out from one URI to all other URI's it is linked to without specifying the predicate? I can make the following query work, but if I don't specify the predicate the query fails The following works, which is very nice, but I would like to have both the predicate and