Hi Jason,
What exactly is not working for you ? As the following works for me:
SQL> SPARQL PREFIX base: <base> INSERT DATA { GRAPH <koh> { <1> base:name
"sensor1" . } };
Done. -- 1 msec.
SQL> SPARQL SELECT * FROM <koh> WHERE {?s ?p ?o};
s
p
o
LONG VARCHAR
LONG VARCHAR
LONG VARCHAR
_______________________________________________________________________________
1
basename
sensor1
1 Rows. -- 2 msec.
SQL> SPARQL PREFIX base: <base> SELECT ?s {?s base:name "sensor1"};
s
LONG VARCHAR
_______________________________________________________________________________
1
1 Rows. -- 1 msec.
SQL> SPARQL PREFIX base: <base> SELECT ?g ?s {GRAPH ?g {?s base:name
"sensor1"}};
g
s
LONG VARCHAR
LONG VARCHAR
_______________________________________________________________________________
koh
1
1 Rows. -- 1 msec.
SQL>
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 23 Jan 2018, at 09:58, Jason Koh <jb...@eng.ucsd.edu> wrote:
>
> Hi Kingsley,
>
> Thanks for the prompt response. I just tried it and it works well. I haven't
> compared the performance yet but wish the string match is faster.
>
> However, I am having trouble querying with the String Literal with SPARQL.
> The following query does not work for Virtuoso.
> ```sparql
> select ?s {
> ?s base:name "sensor1". # also tried "sensor1"^^xsd:string but the same
> result.
> }
> ```
> This query returns empty result.
>
> If I query with no pattern (?s ?p ?o), I can see the following triple:
> :xxxx base:name "sensor1",
>
> Can't sort out the problem. Do you have any ideas on this?
>
> Thank you!
>
>
>
>
>
> With regards,
> Jason Koh
> cseweb.ucsd.edu/~jbkoh
>
> On Mon, Jan 22, 2018 at 2:52 PM, Kingsley Idehen <kide...@openlinksw.com>
> wrote:
> 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
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>
> ------------------------------------------------------------------------------
> 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
------------------------------------------------------------------------------
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
