[Virtuoso-users] Calling SQL from SPARQL

2009-12-04 Thread Kingsley Idehen
Aldo Bucchi wrote: Hi, I am operating over the RDF_QUAD table directly and I find myself in the need to transform all values obtained from column O to the explicit SQL type in a programmatic way. Is there any stored procedure I can use for this matter? A quick glance at "sparql.sql" did not he

Re: [Virtuoso-users] Calling SQL from SPARQL

2008-02-07 Thread Ivan Mikhailov
Pierre, In order to access to SQL data via SPARQL you should create RDF Views first, then query mapped data as if they're usual RDF quads. There's no other way. Probably, we will never add an ability of calling SQL from SPARQL because that will cause problems similar to inlining of assembler fragm

Re: [Virtuoso-users] Calling SQL from SPARQL

2008-02-06 Thread Pierre De Wilde
OK, so it's possible to invoke SQL from SPARQL. Great. But how to get the result back to SPARQL? For example, I want to fetch the list of registered namespaces (SELECT * from RDF_PREFIX). How can I get this list back to a SPARQL endpoint? Thanks beforehand. Pierre 2008/2/6, Tim Haynes : > > Pie

Re: [Virtuoso-users] Calling SQL from SPARQL

2008-02-06 Thread Tim Haynes
Pierre De Wilde wrote: > Hi, > It seems possible to call SQL from SPARQL as referenced in doc 'Calling SQL > from SPARQL' (§15.2.5). > Have you some examples? Is it possible to call statements > like backup_online('backup_#', 1); from a SPARQL endpoint? > Well, I can give you a different exam

[Virtuoso-users] Calling SQL from SPARQL

2008-02-06 Thread Pierre De Wilde
Hi, It seems possible to call SQL from SPARQL as referenced in doc 'Calling SQL from SPARQL' (§15.2.5). Have you some examples? Is it possible to call statements like backup_online('backup_#', 1); from a SPARQL endpoint? Thanks beforehand. Your great support is really appreciated. Pierre