Re: [Virtuoso-users] compression

Hi Marc, Will it make a difference if you only make text indexing active on predicates that are not related to the long DNA sequences? You don't have to enable full text indexing on every predicate, it is just the most common way. The size of the GSPO indexes may be affected by differences in

Re: [Virtuoso-users] Error reports

Hi Nathan, - Original Message > From: Nathan > To: Virtuoso Users List > Sent: Mon, 1 March, 2010 11:30:58 AM > Subject: [Virtuoso-users] Error reports > > Hi All, > > Just a quick update on some "new to me" errors; > > 40001 Error SR172: Transaction deadlocked I used to get this r

Re: [Virtuoso-users] Announcing Virtuoso Open-Source Edition v 5.0.13

I downloaded the source for 5.0.13 and installed it, but there seems to be some ambiguity in the logs about what version is being used... In the virtuoso.log file it says: Fri Feb 05 2010 10:23:18 OpenLink Virtuoso Universal Server 10:23:18 Version 05.12.3041-pthreads for Linux as of Feb

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

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.

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

Re: [Virtuoso-users] Announcing Virtuoso Open-Source Edition v5.0.12

How do we utilise the new "Concise Bound Description" feature in SPARQL? Are there optional statements that you can pass to DESCRIBE to make it work? Cheers, Peter - Original Message > From: Tim Haynes > To: bio2...@googlegroups.com > Sent: Tue, 20 October, 2009 1:19:51 AM > Subject

Re: [Virtuoso-users] Installing DBpedia datasets

=select+distinct+%3FConcept+where+{[]+a+%3FConcept}+LIMIT+1&format=text%2Fhtml&debug=on&timeout= It appears to be a simple query parameter like the other ones. Cheers, Peter ----- Original Message > From: Alex > To: Peter Ansell > Cc: Hugh Williams ; > virtuoso

Re: [Virtuoso-users] Installing DBpedia datasets

about maxrows was that it could be used to ask for more results than the hardcoded 1000 limit internally used by the DBpedia endpoint but I guess that is not the case. Cheers, Peter - Original Message > From: Alex > To: Hugh Williams > Cc: Peter Ansell ; virtu

Re: [Virtuoso-users] Installing DBpedia datasets

Hi Hugh, I have the Bio2RDF software setup to attempt to retrieve 2000 rows by default for all servers including dbpedia.org/sparql . What happens if a query has 'LIMIT 2000 OFFSET 0' or 'LIMIT 2000 OFFSET 2000' in it with the 1000 row restriction? I might have to get around to implementing per

Re: [Virtuoso-users] virtuoso and bio2rdf

Hi Pierre, If you have Virtuoso-specific queries this list is the place to go, otherwise you can try using the Bio2RDF list, which is CC'd in this reply. Just a heads up, we should delete bio2rdf.sourceforge.net/* as it is not maintained and I find it very hard to maintain things on the Source

Re: [Virtuoso-users] Log enable/disable failure apparently causing conductor to not display

openlinksw..com/dataspace/owiki/wiki/VirtuosoWikiWeb/VirtuosoErrorSR471_42000 > >From: Hugh Williams >To: Peter Ansell >Cc: Virtuoso Users List >Sent: Tuesday, 11 August, 2009 8:50:56 AM >Subject: Re: [Virtuoso-users] Log enable/disable failure apparently causing >co

Re: [Virtuoso-users] Log enable/disable failure apparently causing conductor to not display

server the inserts will start again within seconds. I will just restart for now and see what happens to the conductor. Thanks, Peter > >From: Hugh Williams >To: Peter Ansell >Cc: Virtuoso Users List >Sent: Monday, 10 August, 2009 9:57:52 AM >Subject: Re: [Virtuoso-users]

Re: [Virtuoso-users] Log enable/disable failure apparently causing conductor to not display

just incase it happens again in future. Cheers, Peter > >From: Hugh Williams >To: Peter Ansell >Cc: Virtuoso Users List >Sent: Monday, 10 August, 2009 9:57:52 AM >Subject: Re: [Virtuoso-users] Log enable/disable failure apparently causing >conductor to not display &g

[Virtuoso-users] Valid XMLSchema Int's in SPARQL cause some debugging messages in trace mode

Hi all, In order to debug my last issue I decided to log into the isql console and turn trace_on There were no messages at all that seemed to be relevant to the last error but there was a strange message related to something else. The following message is the bug 08:57:27 COMP_2 SPARQL 127.0.

[Virtuoso-users] Log enable/disable failure apparently causing conductor to not display

Hi all, I am using a particular server for a large number of constant and concurrent SPARUL INSERT's and it seems that it has broken itself somehow because the conductor doesn't show anymore. The SPARQL interface and INSERTS and CONSTRUCT's are still actually working but it is still worrying th

Re: [Virtuoso-users] SPARQL INSERT and typed literals

Hi Leo, Try surrounding the 1 with quotes to make it a valid NTriples statement... eg.. "1"^^ I doubt that the compiler error could be more informative as witho

Re: [Virtuoso-users] Date time inconsistency bug

Updating to 5.0.11 from 5.0.10 seems to have fixed the issue as everything now comes out with Z on the end with both SELECT and CONSTRUCT on both the isql and /sparql interfaces. Cheers, Peter - Original Message > From: Peter Ansell > To: Ivan Mikhailov > Cc: Virtuoso U

Re: [Virtuoso-users] Date time inconsistency bug

Add list to CC... - Original Message > From: Peter Ansell > To: Ivan Mikhailov > Sent: Thursday, 9 July, 2009 7:46:13 AM > Subject: Re: [Virtuoso-users] Date time inconsistency bug > > Hi Ivan, > > I am using a slightly old version of virtuoso open source,

[Virtuoso-users] Date time inconsistency bug

Hi all, I am trying to figure out why when I insert xsd:dateTime typed literals in the form "2009-07-08T00:50:36Z", they come out of SELECT sparql queries as "2009-07-08T00:50:36.000" and they come out in CONSTRUCT sparql queries as "2009-07-08T00:50:36.000+10:00". I think for select queries e

[Virtuoso-users] incorrect results from go.bio2rdf.org/sparql

Hi all, Not sure if this is a configuration or software issue, but I am getting invalid RDF/XML (and possibly N3 although I am not so sure about that one) from the following query: CONSTRUCT { ?p ?o . } WHERE { GRAPH {

Re: [Virtuoso-users] constructing URI's from literals

code(?o)))` I also want a version where spaces are %20 encoded, and not + encoded as in some URL encoding schemes. Cheers, Peter - Original Message > From: Ivan Mikhailov > To: Peter Ansell > Cc: Virtuoso Users List > Sent: Monday, 16 February, 2009 10:04:08 P

Re: [Virtuoso-users] constructing URI's from literals

- Original Message > From: Kingsley Idehen > To: Peter Ansell > Cc: virtuoso-users@lists.sourceforge.net > Sent: Tuesday, 17 February, 2009 12:25:17 AM > Subject: Re: [Virtuoso-users] constructing URI's from literals > > Peter Ansell wrote: >

Re: [Virtuoso-users] constructing URI's from literals

- Original Message > From: Kjetil Kjernsmo > To: virtuoso-users@lists.sourceforge.net > Sent: Monday, 16 February, 2009 6:01:17 PM > Subject: Re: [Virtuoso-users] constructing URI's from literals > > On Monday 16 February 2009 06:23:59 Peter Ansell wrote: &

[Virtuoso-users] constructing URI's from literals

Hi, Is there anyway with SPARQL and Virtuoso to create a URI in a result when it is stored as a literal in the triplestore? An example query of the relevant data is: SELECT * WHERE { GRAPH { ?s ?p "http://purl.org/obo/owl/COG#COG_C"^^xsd:anyURI . } }

Re: [Virtuoso-users] DESCRIBEing a URI white implicitly naming the graph

- Original Message > From: Kjetil Kjernsmo > To: virtuoso-users@lists.sourceforge.net > Cc: Kingsley Idehen > Sent: Monday, 5 January, 2009 10:26:51 PM > Subject: Re: [Virtuoso-users] DESCRIBEing a URI white implicitly naming the > graph > > Hi Kingsley and thanks for the response! >

Re: [Virtuoso-users] Virtuoso Server Still Hangs Sleeping on Futex_Wait /P.S.

Have you tried count(?o1) instead of count(*)? Do you really want labels for subjects which also have at least one other predicate associated with them? In graph matching terms you are currently trying a very broad query and possibly shouldn't expect it to be returning results very quickly. W

Re: [Virtuoso-users] query about sparql optional semantics

Thanks! Peter - Original Message > From: Ivan Mikhailov > To: Peter Ansell > Cc: Virtuoso Users List > Sent: Tuesday, 25 November, 2008 2:36:55 AM > Subject: Re: [Virtuoso-users] query about sparql optional semantics > > Hello Peter, > > Yes this is

[Virtuoso-users] query about sparql optional semantics

Hi all, I am not an expert of the semantics of how OPTIONAL works in SPARQL but I am a little surprised at some results I am getting. I am executing the following queries on a copy of the database which is normally at http://go.bio2rdf.org/sparql although it is down at the moment. No results q

Re: [Virtuoso-users] [Dbpedia-discussion] DBPedia 3.2 Load in Virtuoso 5.0.9 - Reporting on results, and some questions

2008/11/23 Kingsley Idehen > Marvin Lugair wrote: > > Hello, > > > > I would like to report back on my loading of dbpedia 3.2 into Open-Source > Virtuoso 5.0.9. > > The good news is that I was successful and have a local DBPedia to play > with now. Thanks to everyone for their input and suggestio

[Virtuoso-users] full text index creation broken

Hi guys, I am wondering what the following two error messages mean, and am wondering what I have to do to fix the issue. SQL> DB.DBA.RDF_OBJ_FT_RULE_ADD ('http://bio2rdf.org/ns/terms#', null, 'http://bio2rdf.org/ns/terms#'); Connected to OpenLink Virtuoso Driver: 05.08.3034 OpenLink Virtuoso OD

Re: [Virtuoso-users] simple select query doesn't work

Thanks, Will have to look at it. I was a little surprised that other queries were working but it must be some low level issue as you say. Cheers, Peter - Original Message - From: "Ivan Mikhailov" To: "Peter Ansell" Cc: "Virtuoso Users List" , "Bio2

[Virtuoso-users] simple select query doesn't work

Hi all, I am trying to run a query on one of the bio2rdf endpoints, the hgnc.bio2rdf.org one [1], and it is failing to return the correct results. The main trouble is that it is such a simple query [2] that I don't know where to start in questioning it. SELECT * WHERE { ?s

Re: [Virtuoso-users] Aggregate queries using CONSTRUCT

- "Ivan Mikhailov" wrote: > From: "Ivan Mikhailov" > To: "Peter Ansell" > Cc: "Virtuoso Users List" > Sent: Tuesday, 21 October, 2008 3:26:07 PM GMT +10:00 Brisbane > Subject: Re: [Virtuoso-users] Aggregate queries using CONSTRU

[Virtuoso-users] Aggregate queries using CONSTRUCT

Hi all, The documentation for the aggregation queries doesn't specifically say that it is only supported for SELECT queries [1] [2], but I have had no success in getting COUNT(?variable) to work inside of CONSTRUCT, where it works for a similar SELECT query. Any ideas about whether this is or w

Re: [Virtuoso-users] Announcing OpenLink Virtuoso, Open-Source Edition, v5.0.7

Have you tried FILTER( bif:contains(?name, '"blood*"')) It my actually result in a different compilation strategy although it does the same thing as far as I know. I also wasn't aware that GRAPH operated outside of UNION. I would tend to put the two GRAPH's into the UNION parts myself as follo

Re: [Virtuoso-users] Formatting of RDF/XML sparql results

http://virtuoso.openlinksw.com - Original Message > From: Peter Ansell > To: virtuoso-users@lists.sourceforge.net > Sent: Wednesday, 16 July, 2008 1:11:48 PM > Subject: [Virtuoso-users] Formatting of RDF/XML sparql results > > Hi, > > I can kind of understand wh

[Virtuoso-users] Formatting of RDF/XML sparql results

Hi, I can kind of understand why Virtuoso does a simple line by line dump from SQL row results to RDF/XML files for CONSTRUCT queries. I don't however understand why it would be less efficient for the same algorithm that currently generates N3 Turtle results can't be ported almost directly over