Re: [Virtuoso-users] bif:contains w/ option score returns the same values

Hi Hugh, Thank you for your suggestion -- yes, I was able to replicate the problem on one of your servers. Actually, I've been experimenting a bit more with my problem and observed that if I used a triple using the "a" keyword (or rdf:type) with a specific object resource in my query, the hit sco

Re: [Virtuoso-users] bif:contains w/ option score returns the same values

HI Krys, Note that I am aware of. Are you able to provide a demonstration of the problem being accounted against one of our live server like http://lod.openlinksw.com/sparql or http://demo.openlinksw.com/sparql , which run

[Virtuoso-users] bif:contains w/ option score returns the same values

Hello, I just upgraded from open source Virtuoso 7.1 to 7.2.0_p1 (from sourceforge). All is fine except that I have a problem with the full text search using bif:contains and the score option. What happens is that it returns the same score values to all hits. For example, a query including the f

Re: [Virtuoso-users] bif:contains behavior

Hi Bart, On 20-Jun-14 2:24 PM, Bart Vandewoestyne wrote: Hello list, According to the example at http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparqlrulefulltext using things like ?name bif:contains "'rich*'" would match if ?name STARTS with Rich. The example here refer

[Virtuoso-users] bif:contains behavior

Hello list, According to the example at http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparqlrulefulltext using things like ?name bif:contains "'rich*'" would match if ?name STARTS with Rich. However, I have a query that has ?searchterm bif:contains "'homo*'" . and it also

[Virtuoso-users] bif:contains and option ?textscore

Dear Virtuoso users, I've a question about using bif:contains and the option ?textscore. My sparql-query looks like: select ?fName, ?lName, ?orgLabel, ?psignLabel, ?textScore where { ?person rdf:type foaf:Person . ?person foaf:lastName ?lName . ?person foaf:firstName ?fName .

Re: [Virtuoso-users] [bif:contains] all options

Hello Michael, Supported bif:contains free-text options are OFFBAND, SCORE and SCORE_LIMIT. OFFBAND is described in http://docs.openlinksw.com/virtuoso/creatingtxtidxs.html#offbanddata but it is useful only if data comers via an RDF View and the source relational table uses this trick. SCORE is

Re: [Virtuoso-users] [bif:contains] all options

Hello Michael, Supported bif:contains free-text options are OFFBAND, SCORE and SCORE_LIMIT. OFFBAND is described in http://docs.openlinksw.com/virtuoso/creatingtxtidxs.html#offbanddata but it is useful only if data comers via an RDF View and the source relational table uses this trick. SCORE is

[Virtuoso-users] [bif:contains] all options

Hi, does anybody know about a reference or detailed documentation for bif:contains? I just found out that there are at least one option score: ?person ?p ?o . ?o bif:contains '"Rito*" or "Pütskül*"' option (score ?textScore) But I can't find more about bif:contains options? Anybody knows kind

Re: [Virtuoso-users] bif:contains - using a string variable as search term

Hi Robert, We are working on a new open source snapshot build we can provide to you which may improve performance somewhat although no guarantees as the order by will always result in a full table scan first to order it then limit the results. What datasets do you have loaded in your store, is

Re: [Virtuoso-users] bif:contains - using a string variable as search term

Hi Hugh, thank you! There seems to be no noticeable decrease of execution time when i use this ORDER BY clause. In the meantime I did some further tests. It seems to me like the ORDER BY clause causes this massive performance slowdowns. When i use the following query without the ORDER BY cla

Re: [Virtuoso-users] bif:contains - using a string variable as search term

Hi Robert, Development suggest the query: sparql PREFIX dc: select distinct ?title ?u from WHERE { ?prog dc:title ?title . ?u rdfs:label ?label . FILTER (bif:isnotnull (bif:strstr (?label, ?title))) } ORDER BY DESC ((select ?created where {

Re: [Virtuoso-users] bif:contains - using a string variable as search term

Hi Ivan, i'll try this. My whole query would be like: /Select ?title ?label v Where {?s dc:title ?title; dc:created ?created./ // /?dbpedia rdfs:label ?label FILTER (bif:strcontains (?title, ?label))/ /?dbpedia foaf:name ?name }

Re: [Virtuoso-users] bif:contains - using a string variable as search term

On Fri, 2011-06-10 at 02:10 +0200, Robbet wrote: > Hi Ivan, > > thank you! Looks gut ... > > First one seems to work as a Sparql query. > > "syntax error at bif:strstr before ( " > > FILTER ( BOUND(bif:strstr (?label, ?title) ) > > But it works without the BOUND keyword. I'm sorry, there sho

Re: [Virtuoso-users] bif:contains - using a string variable as search term

Hi, yes, i confirm both values. Best regards, Robert On 10.06.2011 04:02, Hugh Williams wrote: Hi Robbet, What are your actual NumberOfBuffers and MaXDirtyBuffer settings for your 4GB memory system, I presume those recommended in the Virtuoso Performance Tuning guide at: http://v

Re: [Virtuoso-users] bif:contains - using a string variable as search term

Hi Robbet, What are your actual NumberOfBuffers and MaXDirtyBuffer settings for your 4GB memory system, I presume those recommended in the Virtuoso Performance Tuning guide at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFPerformanceTuning Which are: NumberOf

Re: [Virtuoso-users] bif:contains - using a string variable as search term

On 6/10/11 1:28 AM, Robbet wrote: Hi Kingsley, changed NumberofBuffers and MaxDirtyBuffer to 4GB recommendation. Did i miss something? Dunno if it's only rely in the given hardware or if my query causes the slowdowns. If after doing that you don't have improvements. We are down to DBMS size a

Re: [Virtuoso-users] bif:contains - using a string variable as search term

Hi Kingsley, changed NumberofBuffers and MaxDirtyBuffer to 4GB recommendation. Did i miss something? Dunno if it's only rely in the given hardware or if my query causes the slowdowns. Best regards, Robert On 10.06.2011 02:20, Kingsley Idehen wrote: On 6/10/11 1:10 AM, Robbet wrote: Hi Iv

Re: [Virtuoso-users] bif:contains - using a string variable as search term

On 6/10/11 1:10 AM, Robbet wrote: Hi Ivan, thank you! Looks gut ... First one seems to work as a Sparql query. "syntax error at bif:strstr before (" FILTER ( BOUND(bif:strstr (?label, ?title) ) But it works without the BOUND keyword. I'm new to Virtuoso and SQL / SPARQL environment and t

Re: [Virtuoso-users] bif:contains - using a string variable as search term

Hi Ivan, thank you! Looks gut ... First one seems to work as a Sparql query. "syntax error at bif:strstr before ( " FILTER ( BOUND(bif:strstr (?label, ?title) ) But it works without the BOUND keyword. I'm new to Virtuoso and SQL / SPARQL environment and try to compare small buch of trip

Re: [Virtuoso-users] bif:contains - using a string variable as search term

Robert, bif:strstr (?haystack, ?needle) will return an zero-based position of of ?needle in ?haystack, or NULL if not found [1]. Thus FILTER (BOUND (bif:strstr (?haystack, ?needle))) is what you need. For similar future needs, note FILTER (BOUND (bif:strcasestr (?haystack, ?needle))) Recent v

[Virtuoso-users] bif:contains - using a string variable as search term

Hello, actually i'm trying to find a solution to compare two string variables (exact match of the string and if one variable contains the other). Is it possible (in any way) to use the bif:contains function in this case? Like /variable1 bif:contains variable2/ (or the other way round) ? Alr

Re: [Virtuoso-users] bif:contains for predicate values

Hello Percy, Wed, 2011-05-25 at 13:47 -0300, Percy Enrique Rivera Salas wrote: > Hello everyone > > I would like to know if virtuoso have a function similar to > bif:contains, for predicate values. > > Your request is the first one, so there was no need before and hence no such feature. It is t

[Virtuoso-users] bif:contains for predicate values

Hello everyone I would like to know if virtuoso have a function similar to bif:contains, for predicate values. For example: I want to get all the properties from DBpedia which predicates start with "http://dbpedia.org";. I'm currently using the following SPARQL query that use expensive regular e

Re: [Virtuoso-users] bif:contains function not working

HI Dimitris, Sorry, it was easy after all :) now, something extra, we have about 3-4M triples that we update occasionally by clearing the gragh and inserting the new triples. 1) does the index affect the clear/update procedure? and if it does, are there any commands to call before / after to

Re: [Virtuoso-users] bif:contains function not working

Hi Dimitris, Sorry, it was easy after all :) now, something extra, we have about 3-4M triples that we update occasionally by clearing the gragh and inserting the new triples. 1) does the index affect the clear/update procedure? and if it does, are there any commands to call before / after

Re: [Virtuoso-users] bif:contains function not working

Hi Patrick, Sorry, it was easy after all :) now, something extra, we have about 3-4M triples that we update occasionally by clearing the gragh and inserting the new triples. 1) does the index affect the clear/update procedure? and if it does, are there any commands to call before / after to spee

Re: [Virtuoso-users] bif:contains function not working

Hi Dimitris, i have a problem with the bif:contains function. It does not work and i could find if there is any configuration options to enable it. Server/Virtuoso: version 06.01.3127, on Linux (x86_64-pc-linux-gnu), Single Edition SPARQL Endpoint: http://el.dbpedia.org/sparql For the sa

[Virtuoso-users] bif:contains function not working

Hi, i have a problem with the bif:contains function. It does not work and i could find if there is any configuration options to enable it. *Server/Virtuoso: version 06.01.3127, on Linux (x86_64-pc-linux-gnu), Single Edition* *SPARQL Endpoint: http://el.dbpedia.org/sparql* For the same query, the

[Virtuoso-users] bif:contains and Film

Hi all ! I have tried to get the resource http://dbpedia.org/resource/Film when asking for "film" in the indexes in http://dbpedia.org/sparql, in several ways: SELECT DISTINCT ?s ?o FROM WHERE {{?s rdfs:label ?o.[] a ?s .FILTER( bif:contains(?o, "film" ) )}}LIMIT 36 SE

Re: [Virtuoso-users] bif:contains minimum number of characters?

Hello Lourens, > Is it possible/easy to change the minimum number of characters (now 4) > bif:contains requires to do full text search. Yes, you can find function wp_wildcard_range in file text.c , some about line 2268 depending on version you're using, and tweak the value in the condition

[Virtuoso-users] bif:contains minimum number of characters?

Is it possible/easy to change the minimum number of characters (now 4) bif:contains requires to do full text search. Thanks, Lourens

[Virtuoso-users] bif:contains with UTF-8?

Hello again! I've been aware that bif:contains supports only ASCII and ISO Latin letters for a while and since all our current letters are in that range, it has caused a bit of confusion, but has been OK. We do have some requirements to support UTF-8, though, so this might become a problem. Al

[Virtuoso-users] bif:contains

Hi, How can I use bif:contains predicate for a string value with multiple words. For example when I run the following query it works fine, select * from where {?s foaf:Name ?name . ?name bif:contains "jack" .} But trying to run the query below doesn't work. select * from where {?s f