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 should be bif:isnotnull() instead of BOUND() there.
> I'm new to Virtuoso and SQL / SPARQL environment and try to compare
> small buch of triples with a dc:title property with the rdfs:label property
> from the whole dbpedia dataset stored locally. How do i can increase
> search performance?
> It takes lot of time (about 5-10 minutes each) at the moment altough it
> runs on a quad core, 4gb, ssd system.
> The dbpedia dataset is loaded into one graph.
> In the meantime I already run the RDF_OBJ ADD rule with (null, null,
> 'ALL') to enable free text seach index.
>
> I consider there is a way to index the rdfs label property only (no need
> to search each dbpedia property or concept) in any way but dunno how.
There's no need in indexing labels only or titles only.
If you have something like "select all pairs of titles and labels such
that the title contains the label", and it's
?s dc:title ?title ; rdfs:label ?label
FILTER (bif:strcontains (?title, ?label))
then indexes on O will not help, strcontains can not use indexes. The
only minor acceleration you can provide is to specify graph if possible
(as FROM <const> or GRAPH <const> {...} or at least GRAPH ?g { ... } ).
If it's something else then please provide the whole query.
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
