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
rd...@pitt.edu
Office: 412-648-9219
Twitter: @bhaapgh