Re: [Virtuoso-users] Find out which SQL query is generated from my SPARQL

2015-12-14 Thread Kingsley Idehen
On 12/14/15 11:34 AM, Efimov, Alexander wrote: > > Hi Kingsley, > > > > The idea is that our concept model I map to with R2RML is not the same > as source tables. > > So just using output from Generate RDF Views would not work. > > I write custom R2RML code which maps from flat DB model to graph

Re: [Virtuoso-users] Find out which SQL query is generated from my SPARQL

2015-12-14 Thread Efimov, Alexander
Hi Kingsley, The idea is that our concept model I map to with R2RML is not the same as source tables. So just using output from Generate RDF Views would not work. I write custom R2RML code which maps from flat DB model to graph concept model For example: Let it be the following tables: 1.

Re: [Virtuoso-users] Find out which SQL query is generated from my SPARQL

2015-12-14 Thread Kingsley Idehen
On 12/14/15 9:21 AM, Efimov, Alexander wrote: > > Hi, > > > > I’ve built R2RML mappings, but my SPARQL Query (I expect that to be > joining across about 10 views in DB) runs for hours. > > Is there a way to get a SQL query which Virtuoso generates and runs > over the database views? > > I have tr

[Virtuoso-users] Find out which SQL query is generated from my SPARQL

2015-12-14 Thread Efimov, Alexander
Hi, I've built R2RML mappings, but my SPARQL Query (I expect that to be joining across about 10 views in DB) runs for hours. Is there a way to get a SQL query which Virtuoso generates and runs over the database views? I have tried to use trace_on(); command but have nothing human readable in te