Hi Hugh,
I inserted the tripled through *Virtuoso Jena* and I can see triples like
``ex:xxxx base:name test_sensor0``
when I query just with ?s ?p ?o. However, I don't get any result with ``?s
base:name "test_sensor0"``.
As you showed, it works with command line insertions. Let me verify the
source of the problem once again and come back.
Thank you!
With regards,
Jason Koh
cseweb.ucsd.edu/~jbkoh
On Tue, Jan 23, 2018 at 3:17 AM, Hugh Williams <hwilli...@openlinksw.com>
wrote:
> 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
