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

2018-01-23 Thread Jason Koh
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 wrote: > Here's the Java code

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

2018-01-23 Thread Jason Koh
Here's the Java code snippet not working: ```java String nameStr = "test_sensor1"; String BASE = "http://base.org#";; String uuid = "x"; Node name = NodeFactory.createLiteralByValue(nameStr, XSDstring); Node point = NodeFactory.createURI(BASE + uuid); Node hasName = NodeFactory.createURI(BASE +

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

2018-01-23 Thread Jason Koh
Hi Hugh, I inserted the tripled through *Virtuoso Jena* and I can see triples like ``ex:base:nametest_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 th

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

2018-01-23 Thread Hugh Williams
Hi Jason, What exactly is not working for you ? As the following works for me: SQL> SPARQL PREFIX base: INSERT DATA { GRAPH { <1> base:name "sensor1" . } }; Done. -- 1 msec. SQL> SPARQL SELECT * FROM WHERE {?s ?p ?o}; s

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

2018-01-23 Thread Jason Koh
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 ?