Re: SQL to RDF access ?

On 10/13/15 12:52 PM, Kingsley Idehen wrote: > On 10/2/15 10:47 AM, Jerven Bolleman wrote: >> Hi, >> >> In Oracle, I think you can create a view on a select on sem_match. e.g. >> >> CREATE VIEW proteinOrganism AS >> SELECT p AS PROTEIN, o AS ORGANISM FROM TABLE(SEM_MATCH( >> 'PREFIX c:

Re: SQL to RDF access ?

On 10/2/15 10:47 AM, Jerven Bolleman wrote: > Hi, > > In Oracle, I think you can create a view on a select on sem_match. e.g. > > CREATE VIEW proteinOrganism AS > SELECT p AS PROTEIN, o AS ORGANISM FROM TABLE(SEM_MATCH( > 'PREFIX c: SELECT ?p ?o WHERE {?p a > c:Protei

Re: SQL to RDF access ?

Hi, I know d2rq, but that maps relational to RDF. I am looking the other way around. As far as I have seen, that’s not something d2rq is designed for. Or am I wrong ? best, Andrea > On Oct 2, 2015, at 2:34 PM, Richard Boyce wrote: > > Hi Andrea, I think that D2R Server is very helpful here: >

Re: SQL to RDF access ?

Thanks, I'll have a look. best, Andrea On Fri, Oct 2, 2015 at 4:58 PM, Achille Zappa < achille.za...@insight-centre.org> wrote: > Hi, > > at the moment the only real related project I am aware of on this topic is > (was?): > > RETRO: A Framework for Semantics Preserving SQL-to-SPARQL Translation

Re: SQL to RDF access ?

Hi, thanks, I'll have a look at the paper. I know I can handle it via some DB, but I was looking into something more like D2RQ or even non-declarative in this case, as a default mapping would be pretty plain. Basically to have something portable across triple stores. best, Andrea On Fri, Oct 2, 2

Re: SQL to RDF access ?

Hi, at the moment the only real related project I am aware of on this topic is (was?): RETRO: A Framework for Semantics Preserving SQL-to-SPARQL Translation? take a look at the paper at http://ceur-ws.org/Vol-784/evodyn3.pdf But I am not sure if it is available/alive in some way.. Regards Achil

Re: SQL to RDF access ?

Hi, In Oracle, I think you can create a view on a select on sem_match. e.g. CREATE VIEW proteinOrganism AS SELECT p AS PROTEIN, o AS ORGANISM FROM TABLE(SEM_MATCH( 'PREFIX c: SELECT ?p ?o WHERE {?p a c:Protein . ?p c:organism ?o}', SEM_MODELS('UNIPROT_2015_08'), nul

Re: SQL to RDF access ?

Hi; My understanding is that Andrea wants the opposite: rewrite SQL queries to SPARQL queries, not access to SQL DBs with SPARQL. Anyway if the latter is the case, apart from D2R, the new Stardog release includes virtual graphs to access tabular (SQL, CSV files, ... ) data: http://docs.stardog.com

Re: SQL to RDF access ?

Hi Andrea, I think that D2R Server is very helpful here: http://d2rq.org/d2r-server All can be done with a mapping file that you configure. The server provides a SPARQL web query interface (SNORQL) but also can dump to an RDF file that you load in a separate store. hope it helps, -R On 10/

SQL to RDF access ?

Hi, I am wondering if some of you knows of some tool that can translate (a subset) of SQL to SPARQL (perhaps requiring some constraints on the RDF representation). In principle it should be simple: classes can appear as tables, URIs as IDs, datatype properties as columns and object properties as F