Re: [Virtuoso-users] Query optimization, possible indexing?

[Kingsley Idehen]

On 1/22/18 5:11 PM, Jason Koh wrote:
> Hi there,
>
> I am trying to use Virtuoso for metadata of city-scale sensor
> database. (metroinsight.io ).
>
> I wonder if there is a way to optimize certain SPARQL query pattern. I
> often query this:
> ```sparql
> select ?s where {
>   ?s base:name ex:mySensor1 .
> }
> ```
>
> I could optimize it by caching those with Redis or else, but I wonder
> if I can force indexing "name" properties in Virtuoso. 
>
> Thank you!
>
>
> With regards,
> Jason Koh
> cseweb.ucsd.edu/~jbkoh 


Have you looked at text indexing in Virtuoso with regards to SPARQL?

[1] http://docs.openlinksw.com/virtuoso/rdfsparqlrulefulltext/ .

-- 
Regards,

Kingsley Idehen   
Founder & CEO 
OpenLink Software   (Home Page: http://www.openlinksw.com)

Weblogs (Blogs):
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-Idehen
Twitter: https://twitter.com/kidehen
Google+: https://plus.google.com/+KingsleyIdehen/about
LinkedIn: http://www.linkedin.com/in/kidehen

Web Identities (WebID):
Personal: http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i
: 
http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this



smime.p7s
Description: S/MIME Cryptographic Signature
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Query optimization, possible indexing?

[Jason Koh]

Hi there,

I am trying to use Virtuoso for metadata of city-scale sensor database. (
metroinsight.io).

I wonder if there is a way to optimize certain SPARQL query pattern. I
often query this:
```sparql
select ?s where {
  ?s base:name ex:mySensor1 .
}
```

I could optimize it by caching those with Redis or else, but I wonder if I
can force indexing "name" properties in Virtuoso.

Thank you!


With regards,
Jason Koh
cseweb.ucsd.edu/~jbkoh
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users