Re: [Virtuoso-users] Substring implementation difference between jena, rdf4j and virtuoso

erson wrote: On 2019-03-24, at 15:34:55, Jerven Tjalling Bolleman wrote: Hi All, Cross posting as this seems to be a question of spec implementation and I am not sure what the correct answer is supposed to be. look at the examples in the document which you referenced. best regards, from berli

[Virtuoso-users] Substring implementation difference between jena, rdf4j and virtuoso

actually uses the given value in the calculation. e.g. SELECT * WHERE { BIND("ABCDEFGHIJK" AS ?s2) BIND(SUBSTR(?s2, 0, 2) AS ?sub) } Gives "A" in jena but "AB" in virtuoso Regards, Jerven -- Jerven Tjalling Bolleman SIB | Swiss Institute of Bioinformatics CMU - 1, ru

Re: [Virtuoso-users] Thousands of IER NO OWNER locks what could be the cause?

Dear Virtuoso devs, Of course it was _me_ not closing resources on the java side... Regards, Jerven On 2018-04-03 14:13, Jerven Tjalling Bolleman wrote: Dear Virtuoso devs, We are having an otherwise healthy (just a bit slow) instance of virtuoso with thousands of IER NO OWNER locks being

Re: [Virtuoso-users] Complete DB in RAM

Hi Henrik, I have thought about this as well. One way to be sure is roughly this recipe. First turn off swap! mkdir my_ram_disk#needs a directory mount -t tmpfs -o size=50G tmpfs my_ram_disk #50G in size cp existing virtuoso.db files etcc to my_ram_disk make a new

Re: [Virtuoso-users] Issue concatenating an array into one result cell

Hi, GROUP_CONCAT is the feature you are looking for. https://www.w3.org/TR/sparql11-query/#defn_aggGroupConcat It does mean you need to do a GROUP_BY Regards, Jerven On 04/12/2017 06:05 PM, Legault, Phillip [GTSUS] wrote: > I was wondering if anyone knows how to get an array of results from a

Re: [Virtuoso-users] {Disarmed} Re: {Disarmed} Re: SQ156: Internal Optimized compiler error : sqlo table has no index in

LE.COM". DO _NOT_ TRUST THIS WEBSITE: > http://plus.google.com/100570109519069333827/ [2] > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology > Providers > >> On 9 Feb 2017, at 13:35, Jerven Tjalling Boll

Re: [Virtuoso-users] {Disarmed} Re: SQ156: Internal Optimized compiler error : sqlo table has no index in

; Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology > Providers > >> On 6 Feb 2017, at 16:08, Jerven Tjalling Bolleman >> <jerven.bolleman@sib.swiss> wrote: >> >> Dear Virtuoso users, >

[Virtuoso-users] SQ156: Internal Optimized compiler error : sqlo table has no index in

iohackathon.org/resource/faldo#ExactPosition> . ?subject <http://purl.uniprot.org/core/author> ?target .}}] Exception:virtuoso.jdbc4.VirtuosoException: SQ156: Internal Optimized compiler error : sqlo table has no index in sqldf.c:3777. Please report the statement compiled. Regards, Jer

[Virtuoso-users] Parallel backup_online invocation

;" & isql ... exec="backup_online ('virt-inc_dump_#', 15000,'backup');" & Thank you for your precious time and great product. Regards, Jerven -- Jerven Tjalling Bolleman SIB | Swiss Institute of Bioinformatics CMU - 1, rue Michel Servet - 1211 Geneva 4 t: +41 22 379 58 8

[Virtuoso-users] Inference howto/if possible without materialization

, Jerven -- Jerven Tjalling Bolleman SIB | Swiss Institute of Bioinformatics CMU - 1, rue Michel Servet - 1211 Geneva 4 t: +41 22 379 58 85 - f: +41 22 379 58 58 Jerven.Bolleman@sib.swiss - http://www.sib.swiss -- Developer

Re: [Virtuoso-users] SPARQL Service Description

t; > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Jerven Tjalling Bolleman SIB | Swiss Institute of Bioinformatics CMU - 1, rue Michel S

Re: [Virtuoso-users] geometry data type in virtuoso

s): > Legacy Blog: http://www.openlinksw.com/blog/~kidehen/ > Blogspot Blog: http://kidehen.blogspot.com > Medium Blog: https://medium.com/@kidehen > > Profile Pages: > Pinterest: https://www.pinterest.com/kidehen/ > Quora: https://www.quora.com/profile/Kingsley-Uyi

Re: [Virtuoso-users] Complex SPARQL query - Performance hints?

Hi Pantelis, One thing that struck me as an other virtuoso user is the joins in the filters. e.g. FILTER (?variableE = ?variableH) I think if you remove all instances of ?variableH with ?variableE you should get better results. Hope that helps. Regards, Jerven On 28/09/16 14:44, Pantelis

Re: [Virtuoso-users] Subqueries in different graphs, performance problem

As another virtuoso user. Can't you make a simpler query without a subselect? SELECT ?a FROM NAMED { GRAPH { ?c d ?e . BIND(REPLACE(STR(?e), "f", "", "i") AS ?g) BIND(REPLACE(STR(?c), "f", "", "i") AS ?a) FILTER (?g = STR(?h)) . }

Re: [Virtuoso-users] sparql query which works in Virtuoso 6 but not in Virtuoso 7

t; > Adam > > -- > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Jerve

Re: [Virtuoso-users] Passing Java String Array to Virtuoso Stored Procedure

Hi all, Just to note. This is also the blocking issue for https://github.com/openlink/virtuoso-opensource/issues/155. Regards, Jerven On 02/06/14 10:43, s...@in.gr wrote: Hey guys, I' m doing a lot of SELECT queries in a loop and constant JDBC calls seem to ruin my performance. I wanna try

Re: [Virtuoso-users] SPARQL OPTIONAL performance

Hi Nicola, A slightly faster form is to make one OPTIONAL with an UNION instead of two OPTIONALs. e.g. CONSTRUCT {http://dbpedia.org/resource/Coen_brothers ?p ?o. ?sub ?p_sub ?o_sub. ?type ?p_type ?o_type. } where { http://dbpedia.org/resource/Coen_brothers ?p ?o OPTIONAL { {