[Virtuoso-users] Statistics

Hello, is there a way to get statistics of how much queries an endpoint is receiving? Thanks, Marc-Alexandre

Re: [Virtuoso-users] loading big file in virtuoso

Hi, To push the loading capacity of the open source Virtuoso I use 2 things at Bio2RDF. 1) Good size server (24 cores, 128 GB ram). I can't do much for you here. The more ram the better and the more core, the more parrallel loading... "up to a certain point with the free version" 2) Exploit the

[Virtuoso-users] Case INsensitivity for URI

%3Fo+.%0D%0A}&format=text/html&debug=on&timeout= I will retrieve nothing. In some situation this is what is expected, but in situation where the users doesn't know the identifier case scheme AND the case is not important for that specific dataset, I would like to turn off the case sensitivity. Is it possible? Thanks, Marc-Alexandre Nolin

[Virtuoso-users] Lost dba password

Hello, I've change my dba password and I've lost it. Is there a way to retrieve it or to reset it when I restart my server. I've try starting my server using this to reset the dba password: virtuoso-t -f +pwddba dba & But no success. When I try to connect using isql I receive a Bad login. [root

[Virtuoso-users] ISQL query to completely empty a Virtuoso server

Hi, Is there a Virtuoso query to remove all triples from a Virtuoso Server? Those triples are in multiple graphs. I know I can delete a graph with the sparql query "delete from graph ..." but when faced with thousand of graph, its not an interesting query. Thanks, Marc-Alexandre

[Virtuoso-users] Problem to restart a large virtuoso server - disk.c

is out of range Segmentation fault Also, the first message I've receive, but it is not giving it to me anymore was GPF: disk.c:1867 cannot write buffer to 0 page. What does this mean? Is it because of the size of the virtuoso.db which is 1.1 TB? Thanks for the help, Marc-Alexandre Nolin

[Virtuoso-users] graph question

Hello, I would like clarification about multiple graph usage if I use quad of TriX for the files I'm loading. In the release note about Virtuoso 6.1.0 here http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSNews#Announcing Virtuoso Open-Source Edition v6.1.0 There is this point :

Re: [Virtuoso-users] compression

t; > Ivan Mikhailov > OpenLink Software > http://openlinksw.com > > On Wed, 2010-03-10 at 10:09 -0500, Marc-Alexandre Nolin wrote: >> I've a N3 dump I'm currently loading into a Virtuoso Server (a >> complete NCBI Genbank). One literal have always huge size.

Re: [Virtuoso-users] compression

Ceriel Jacobs > > Op 11 mrt 2010, om 21:41 heeft virtuoso-users-requ...@lists.sourceforge.net > het volgende geschreven: > >> Message: 1 >> Date: Wed, 10 Mar 2010 10:09:08 -0500 >> From: Marc-Alexandre Nolin >> Subject: [Virtuoso-users] compression >> To:

[Virtuoso-users] compression

virtuoso.db file already weight around 250 GB. I'm not sure if the full text index is in there with this size. Thanks, Marc-Alexandre Nolin

[Virtuoso-users] Improve Free text indexing speed

Hello, I've created a new triplestore and created the free text index before starting to load the triples. I've load approximatively 4 billions triples in less than 2 days using TTLP. However, the free text index wasn't there. So the problem might be related to this situation (http://docs.openlink

Re: [Virtuoso-users] Full text index there... but not there

27;ve launch the creation process at least 10 times with my version and the version Nathan provided me. Thanks, Marc-Alexandre 2010/2/23 Nathan : > Marc-Alexandre Nolin wrote: >> Hello, >> >> I've installed the version 6.1 and I've create a new triplestore and >&g

[Virtuoso-users] Full text index there... but not there

;t give any without errors, but still no full text index. Thanks, Marc-Alexandre Nolin

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

and what correction need to be done for loading it (There was some errors with the RDFizer that generate the Genbank dump, but they are easily corrected with a regexp before the load). So do you have an optimize virtuoso.ini you can suggest me to help? Thanks, Marc-Alexandre Nolin P.S.: We have

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

?b . ?c ncbi:P2 ?b . ?d ?predicate ?c . ?d rdf:type ncbi:Record . ?e ?predicate1 ?d . ?e rdf:type hhpid:P3> . ?e hhpid:P4 ?f . ?e hhpid:P5 ?g . { ?f bio2rdf:P6 ?a . } UNION { ?g bio2rdf:P6 ?a . } ?a rdfs:label ?aLabel . } order by desc (count(?a)) ; Thanks for your help, Marc-Alexandre Nolin 20

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

Thanks everybody, I've managed to accomplish exactly what I wanted using the query you provided me and including it into another select ?go count(?go) where { {select distinct ?protein where { ?protein rdf:type . } order by order by asc (bif:rnd(200

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

different. Thanks, Marc-Alexandre 2010/1/21 Nathan : > Marc-Alexandre Nolin wrote: >> Hello, >> >> When I do the following query: >> >> select distinct >> ?s >> where >> { >> ?s rdf:type <http://biology.com/Protein> . >> } >> limi

[Virtuoso-users] Randomness in a SPARQL results

bif:random(?s, 100) . ?s <http://biology.com/chromosomeNumber> ?cn . filter(?cn == 10) . } Thanks, Marc-Alexandre Nolin

Re: [Virtuoso-users] Large N3 files

Thanks, If you implement something with compression, tell me, I would be happy to test it because it is a problem for me :) Idea: - It could be a rule to compress every literal (but indexation would need to be done before its compress) - Il could be a compression based on a selection of predicate

Re: [Virtuoso-users] Large N3 files

hysical hard drive, but a single logical disk. So I don't think I will have gain from stripping. From Virtuoso web site ("Striping only has a potential performance benefit when striped across multiple devices"). Do you think I should try to strip anyway? Thanks, Marc-Alexandre Nolin

[Virtuoso-users] Large N3 files

compressed) Be aware that my script correct some errors in triples that have been create by my first version of my rdfizer. So if you try to load it in the current state, some triple will miss the closing ">", but since creating the N3 take more than a week, I'm not redoing it now :) Thanks, Marc-Alexandre Nolin

[Virtuoso-users] Error while loading N3 files

Hello, I'm receiving an error while trying to load an N3 version of PubMed. Error SR175: Uniqueness violation : Violating unique index RDF_QUAD_POGS on table DB.DBA.RDF_QUAD. Transaction killed. What does it really mean? What I think it mean is that the hash function space isn't big enough and i

Re: [Virtuoso-users] /conductor not found ?

Thanks for the answers, I've re-installed in the previous directory and also specified the DirsAllowed and now Conductor work again. Bye, Marc-Alexandre 2009/2/12 Tim Haynes : > Tim Haynes wrote: >> Marc-Alexandre Nolin wrote: > [...] > >>> Error HTTP/1.1 4

[Virtuoso-users] /conductor not found ?

02-06 15:52 virtuoso -> virtuoso-5.0.9/ drwxr-xr-x 6 rootroot4096 2008-03-18 17:03 virtuoso-5.0.5 drwxr-xr-x 6 rootroot4096 2009-02-06 15:52 virtuoso-5.0.9 What Am I doing wrong? I need conductor to change Sparql users properties to add update to it. Thanks, Marc-Alexandre Nolin

[Virtuoso-users] Multiple core

Hello, How can I compile or fine tune a Virtuoso installation to take advantage of all the core I have in the server. I currently have a 4 core server and when I query it, in the top utility on Linux, only 1 core is having a load on him. I'm about to try Virtuoso on a 16 core and a 32 core in the