All, Just saw this from a google search : www.d2rq.org. Quoting below the headings from site:
The D2RQ Platform is a system for accessing relational databases as virtual, read-only RDF graphs. It offers RDF-based access to the content of relational databases without having to replicate it into an RDF store. Using D2RQ you can: - query a non-RDF database using SPARQL <http://www.w3.org/TR/sparql11-query/> - access the content of the database as Linked Data <http://en.wikipedia.org/wiki/Linked_Data> over the Web - create custom dumps of the database in RDF formats for loading into an RDF store - access information in a non-RDF database using the Apache Jena API <http://incubator.apache.org/jena/> D2RQ is Open Source software and published under the Apache license <http://www.apache.org/licenses/LICENSE-2.0.html>. The source code is available on GitHub <http://github.com/d2rq/d2rq>. You can contact the dev team through the issue tracker <http://github.com/d2rq/d2rq/issues>. Kindly advise whether this would suffice my need for finding the relationships for autojoin between multiple tables in single RDBMS or multiple instances of RDBMS. Best regards, Ravion On Wed, Sep 7, 2016 at 6:16 PM, ☼ R Nair (रविशंकर नायर) < ravishankar.n...@gmail.com> wrote: > Do you have it inn GITHUB, can it be shared? > > Best, Ravion > > On Sep 7, 2016 3:19 PM, "Paul Tyson" <phty...@sbcglobal.net> wrote: > >> I wrote my own R2RML converter using Jena lib. It seemed cheapest and >> easiest at the time (a few years ago). I have not surveyed current >> offerings in this space. >> >> Best, >> --Paul >> >> > On Sep 7, 2016, at 14:13, Martynas Jusevičius <marty...@graphity.org> >> wrote: >> > >> > Paul, >> > >> > What are you using for R2RML? >> > >> > Ontop looks promising: http://ontop.inf.unibz.it/ >> > >> >> On Wed, Sep 7, 2016 at 9:11 PM, Paul Tyson <phty...@sbcglobal.net> >> wrote: >> >> Yes, I am using R2RML to convert 4 big PLM DBs into RDF, load in Jena >> TDB and serve via fuseki for data mashups and inconsistency reports. Works >> very well. >> >> >> >> Best, >> >> --Paul >> >> >> >>> On Sep 7, 2016, at 13:39, Martynas Jusevičius <marty...@graphity.org> >> wrote: >> >>> >> >>> I think R2RML and GRDDL could be of interest to you: >> >>> https://www.w3.org/TR/r2rml/ >> >>> https://www.w3.org/TR/grddl/ >> >>> >> >>> On Wed, Sep 7, 2016 at 8:00 PM, ☼ R Nair (रविशंकर नायर) >> >>> <ravishankar.n...@gmail.com> wrote: >> >>>> Agree, the question is whether an RDF can be created out of the data >> from >> >>>> multiple data sources and use it for semantic correlation. That >> would turn >> >>>> the world round. In my organization, there are at least a PB of >> data lying >> >>>> in disparate sources, untapped because , they are legacy and none >> knows the >> >>>> relationships until explored manually. If Jean is not, any >> suggestions to >> >>>> manage this? Thanks >> >>>> >> >>>> Best, Ravion >> >>>> >> >>>> On Sep 7, 2016 1:55 PM, "A. Soroka" <aj...@virginia.edu> wrote: >> >>>> >> >>>> Jena is an RDF framework-- it's not really designed to integrate SQL >> >>>> databases. Are you sure you are using the right product? Does your >> use case >> >>>> involve a good deal of RDF processing? >> >>>> >> >>>> --- >> >>>> A. Soroka >> >>>> The University of Virginia Library >> >>>> >> >>>>>> On Sep 7, 2016, at 1:43 PM, ☼ R Nair (रविशंकर नायर) < >> >>>>> ravishankar.n...@gmail.com> wrote: >> >>>>> >> >>>>> All, >> >>>>> >> >>>>> I am new to Jena. I would like to query two databases, mysql and >> Oracle. >> >>>>> Assume that there are similar columns in both. For example MYSQL >> contains >> >>>> a >> >>>>> table EMP with ENAME column. Oracle contains, say, DEPT table with >> >>>>> EMPLOYEENAME column. What are the steps if I want Jena to find out >> ENAME >> >>>> of >> >>>>> MYSQL is same as EMPLOYEENAME column of Oracle, ( and so can be >> joined). >> >>>> Is >> >>>>> this possible, at least to get an output saying both columns are >> similar? >> >>>>> If so, how, thanks and appreciate your help. >> >>>>> >> >>>>> Best, Ravion >> >> >> >>
