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

Re: SQL to RDF access ?

From: Mikel Egaña Aranguren <mikel.egana.aranguren@gmail.com>
Date: Fri, 2 Oct 2015 15:04:30 +0200
Message-ID: <CABf_9zKbHP_OJu=CkQYYxD2rSx11zxAXtcrtfyR+3N9HHZ_hcA@mail.gmail.com>
To: Richard Boyce <rdb20@pitt.edu>
Cc: HCLS <public-semweb-lifesci@w3.org>
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/#_virtual_graphs.

Mikel

2015-10-02 14:34 GMT+02:00 Richard Boyce <rdb20@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 Pittsburghrdb20@pitt.edu
> Office: 412-648-9219
> Twitter: @bhaapgh
>
>


-- 
Mikel Egaña Aranguren, Ph.D.

http://mikeleganaaranguren.com
Received on Friday, 2 October 2015 13:04:59 UTC

This archive was generated by hypermail 2.3.1 : Friday, 2 October 2015 13:04:59 UTC