Sparql To SQL

2014-03-30 Thread Kamalraj Jairam
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

Re: Sparql To SQL

2014-03-30 Thread Martynas Jusevičius
Hey, have you tried D2RQ? http://d2rq.org Martynas On Sun, Mar 30, 2014 at 11:37 AM, Kamalraj Jairam kjai...@semanticsoftware.com.au 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

Re: Sparql To SQL

2014-03-30 Thread Andy Seaborne
On 30/03/14 12:21, Martynas Jusevičius wrote: Hey, have you tried D2RQ? http://d2rq.org +1 The development version has support for R2RML, I gather. Martynas On Sun, Mar 30, 2014 at 11:37 AM, Kamalraj Jairam kjai...@semanticsoftware.com.au wrote: Hello All, Whats the best way to convert

Re: Sparql To SQL

2014-03-30 Thread Erik Antelman
My experience with d2rq was that expecting efficient execution was not always likely since sparql and SQL have likely impedance mismatch. (Analogous to object relational mapping difficulties) I found it very useful for schema and type discovery for importing. On Mar 30, 2014 12:53 PM, Andy

Re: Sparql To SQL

2014-03-30 Thread Paul Tyson
On Sun, 2014-03-30 at 09:37 +, Kamalraj Jairam wrote: Hello All, Whats the best way to convert sparql to SQL using R2RML mappings and convert resultset from DB to RDF? What are the givens? Do you have existing SPARQL text written against some RDF produced by some existing R2RML

Re: Sparql To SQL

2014-03-30 Thread Kamalraj Jairam
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

Re: Sparql To SQL

2014-03-30 Thread Kamalraj Jairam
Hello Paul, These are the informtion i have 1) R2RML mapping for existing DB 2) I have some fedreated queries which hit the triple store containg the data which has been loaded from the DB The Loading data from DB (100 tables, millions of rows) to TS takes a long time. I need a framework to

Re: Sparql To SQL

2014-03-30 Thread Claude Warren
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

Re: Sparql To SQL

2014-03-30 Thread Martynas Jusevičius
There are also commercial options, e.g. this: http://www.revelytix.com/content/spyder On Sun, Mar 30, 2014 at 10:15 PM, Kamalraj Jairam kjai...@semanticsoftware.com.au wrote: Hello Paul, These are the informtion i have 1) R2RML mapping for existing DB 2) I have some fedreated queries which

named model

2014-03-30 Thread Joakim Soderberg
Hi, I hear that using named models are best practice. But I can't find any examples in the new Jena tutorials. Would it be to recommendable to keep a reference to the data set and then create a named model using: Dataset ds = TDBFactory.createDataset(datase/t); Model model =

Re: Sparql To SQL

2014-03-30 Thread Claus Stadler
There is also Sparqlify[1], which we use for exposing OpenStreetMap as LinkedData in the LinkedGeoData project[2] (and dumpig the RDF for downloads)[3]. Unfortunately, R2RML support not yet totally stable; we wrote our mappings[4] in what we refer to as Sparqlification Mapping Language (SML)

Re: Sparql To SQL

2014-03-30 Thread Juan Sequeda
If you want a commercial tool, please take a look at our tool, Ultrawrap: http://capsenta.com/ultrawrap/ Juan Sequeda +1-575-SEQ-UEDA www.juansequeda.com On Sun, Mar 30, 2014 at 3:10 PM, Kamalraj Jairam kjai...@semanticsoftware.com.au wrote: Hello All, This is what i’m trying to do.