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

Re: SQL to RDF access ?

From: Richard Boyce <rdb20@pitt.edu>
Date: Fri, 2 Oct 2015 08:34:09 -0400
To: <public-semweb-lifesci@w3.org>
Message-ID: <560E79C1.1020400@pitt.edu>
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/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
Office: 412-648-9219
Twitter: @bhaapgh
Received on Friday, 2 October 2015 12:34:40 UTC

This archive was generated by hypermail 2.3.1 : Friday, 2 October 2015 12:34:42 UTC