W3C home > Mailing lists > Public > public-semweb-lifesci@w3.org > October 2015

Re: SQL to RDF access ?

From: Andrea Splendiani <sergentpepper@gmail.com>
Date: Fri, 2 Oct 2015 14:51:53 +0200
Cc: public-semweb-lifesci@w3.org
Message-Id: <1C21D733-C62D-4D0F-B2BC-2789379514D3@gmail.com>
To: Richard Boyce <rdb20@pitt.edu>
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 <rdb20@pitt.edu> wrote:
> 
> Hi Andrea, I think that D2R Server is very helpful here: http://d2rq.org/d2r-server <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/02/2015 07:37 AM, Andrea Splendiani wrote:
>> 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 Fkeys.
>> Is there something implementing this translation available, that some of you know ? One current option (I think) is via Oracle, but I am wondering if there is something like-weight.
>> 
>> As of why I am interested in it... it's curious: I may have an RDF graph representing a unified set of sources (some of which native in RDF, some of which virtualized from SQL). 
>> Still people like to query the sql sources in sql, just because they know it better. But like this, they miss the whole integration (and a more flexible data model).
>> 
>> best,
>> Andrea 
> 
> 
> -- 
> Richard D Boyce, PhD
> Assistant Professor of Biomedical Informatics
> Faculty, Center for Pharmaceutical Policy and Prescribing 
> Faculty, Geriatric Pharmaceutical Outcomes and Gero-Informatics Research and Training Program
> University of Pittsburgh
> rdb20@pitt.edu <mailto:rdb20@pitt.edu>
> Office: 412-648-9219
> Twitter: @bhaapgh
Received on Sunday, 4 October 2015 16:44:23 UTC

This archive was generated by hypermail 2.3.1 : Sunday, 4 October 2015 16:44:23 UTC