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

Re: [Virtuoso-users] Mac re-install error

2010-07-14 Thread Patrick van Kleef
Hi Nico, I installed virtuoso already once on another server. But this time I have some problems while compiling. This files are not there, and they are not in the files I downloaded. The source archive does not have this file either, but sometimes external tools like editors etc create su

Re: [Virtuoso-users] DB.DBA.RDF_GEO_FILL exits with error

2010-07-14 Thread Patrick van Kleef
Hi Claus, The first time the after a DB start DB.DBA.RDF_GEO_FILL () is called, the error occurs after less than a half a minute. On consecutive attempts it then only takes a few seconds. The error occurs independent of whether resources carry the virtuoso specific geo-literals. However, as

Re: [Virtuoso-users] DB.DBA.RDF_GEO_FILL exits with error

2010-07-14 Thread Claus Stadler
Hi, The first time the after a DB start DB.DBA.RDF_GEO_FILL () is called, the error occurs after less than a half a minute. On consecutive attempts it then only takes a few seconds. The error occurs independent of whether resources carry the virtuoso specific geo-literals. However, as already