Dear Hugh and the community,
I have created a regenerator repository:
https://github.com/jbkoh/virtjena_regenerator
If available, please review the problem. I think it's the problem of Virt
Jena, your feedback would be much useful for me to write the right code.
Thanks!
With regards,
Jason Koh
cseweb.ucsd.edu/~jbkoh
On Tue, Jan 23, 2018 at 12:50 PM, Jason Koh <jb...@eng.ucsd.edu> wrote:
> Forgot to clarify the configuration:
>
> Ubuntu 16.04 (64bit)
> Virtuoso 7.2.4.2
> Virtuoso Jean: virt_jena3
> Virtuodo JDBC: virtjdbc4
> Java: openjdk version "1.8.0_151"
>
> Thank you.
>
>
> With regards,
> Jason Koh
> cseweb.ucsd.edu/~jbkoh
>
> On Tue, Jan 23, 2018 at 12:46 PM, Jason Koh <jb...@eng.ucsd.edu> wrote:
>
>> Here's the Java code snippet not working:
>> ```java
>> String nameStr = "test_sensor1";
>> String BASE = "http://base.org#";;
>> String uuid = "xxxxx";
>> Node name = NodeFactory.createLiteralByValue(nameStr, XSDstring);
>> Node point = NodeFactory.createURI(BASE + uuid);
>> Node hasName = NodeFactory.createURI(BASE + "name");
>> graph.add(new Triple(point, hasName, name));
>> String qStr =
>> "PREFIX base: <http://base.org#>\n" +
>> "SELECT ?s WHERE {\n" +
>> "?s base:name \"test_sensor1\" . \n" +
>> "}";
>> Query sparql = QueryFactory.create(qStr);
>> VirtuosoQueryExecution vqd = VirtuosoQueryExecutionFactory.create(sparql,
>> graph);
>> ResultSet results = vqd.execSelect();
>> while (results.hasNext()) {
>> QuerySolution result = results.nextSolution();
>> System.out.println(result.get("s").toString());
>> }
>> System.out.println("Done");
>> }
>> ```
>>
>> The value ``results`` is empty and this code does not print anything. I
>> can make a regenerator. Let me know if that helps.
>>
>>
>> With regards,
>> Jason Koh
>> cseweb.ucsd.edu/~jbkoh
>>
>> On Tue, Jan 23, 2018 at 12:16 PM, Jason Koh <jb...@eng.ucsd.edu> wrote:
>>
>>> 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/k
>>>> ingsley.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
