Re: [Virtuoso-users] SQL subquery embedded in a SPARQL query

2010-07-14 Thread Ivan Mikhailov
Hello Sören, First of all, placing the SQL query into SPARQL is required less frequently than it seems to be. Virtuoso's optimizer does not treat subquery as an instruction to preserve the order. As a result, PREFIX : SELECT ?y ?name ?age WHERE { :alice :knows ?y .

Re: [Virtuoso-users] SQL subquery embedded in a SPARQL query

2010-07-14 Thread Sören Auer
On 14.07.2010 4:38, Ted Thibodeau Jr wrote: While not exactly what you're asking for, this may be sufficient for what you want to achieve -- Yes, we have seen this, but this will be very inefficient for large datasets.

Re: [Virtuoso-users] SQL subquery embedded in a SPARQL query

2010-07-14 Thread Ted Thibodeau Jr
Hi, Sören -- On Jul 14, 2010, at 07:55 AM, Sören Auer wrote: > For some experiments we plan to run it would be very useful to > embed an SQL query as a subquery inside a SPARQL query. We want > to combine relational with RDF data for example in the following > way: While not exactly what you're

Re: [Virtuoso-users] SQL subquery embedded in a SPARQL query

2010-07-14 Thread Mike Bergman
+1 Mike On 7/14/2010 6:55 AM, Sören Auer wrote: Hi, For some experiments we plan to run it would be very useful to embed an SQL query as a subquery inside a SPARQL query. We want to combine relational with RDF data for example in the following way: Lets assume we have foaf profiles in the tr

[Virtuoso-users] SQL subquery embedded in a SPARQL query

2010-07-14 Thread Sören Auer
Hi, For some experiments we plan to run it would be very useful to embed an SQL query as a subquery inside a SPARQL query. We want to combine relational with RDF data for example in the following way: Lets assume we have foaf profiles in the triple store and a relational table with informati