as mentioned D2RQ maps data from SQL to RDF so that SPARQL statements can execute against the SQL data. It can also be used to extract the relational data as RDF. The newest versions are supposed to do updates of the SQL as well, but I have not played with those versions. In the cases I had SPARQL queries of the SQL working for a project and the performance was sufficient for our needs.
I have a project (https://github.com/Claudenw/jdbc4sparql) which essentially takes a SPARQL query and presents the results as a table in a JDBC driver. You can present multiple SPARQL statements as multiple tables. It is in early development and does not yet support functions and some other things that it should. Claude On Sun, Mar 30, 2014 at 9:10 PM, Kamalraj Jairam < [email protected]> wrote: > Hello All, > > This is what i’m trying to do. > > Loading data from a legacy database like DB2 or Oracle to Triple Store > takes a long time (Its an OLTP DB) > > I’m firing some federated quries which needs to hit the database directly > and retrieve the results. > > So, i need some process where sparql can be converted to SQL. > -- > Kjairam > Sent with Airmail > > > On 30 March 2014 at 10:22:14 pm, Martynas Jusevičius ( > [email protected]<mailto:[email protected]>) wrote: > > Hey, > > have you tried D2RQ? http://d2rq.org > > Martynas > > On Sun, Mar 30, 2014 at 11:37 AM, Kamalraj Jairam > <[email protected]> wrote: > > Hello All, > > > > Whats the best way to convert sparql to SQL using R2RML mappings > > > > and convert resultset from DB to RDF? > > > > Thanks > > > > > > > > > > -- > > Kjairam > > Sent with Airmail > -- I like: Like Like - The likeliest place on the web<http://like-like.xenei.com> LinkedIn: http://www.linkedin.com/in/claudewarren
