I think you will want to start discussion of your question with the people who actually support that product. It's not a part of Jena.
--- A. Soroka The University of Virginia Library > On Sep 7, 2016, at 6:28 PM, ☼ R Nair (रविशंकर नायर) > <[email protected]> wrote: > > 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 (रविशंकर नायर) < > [email protected]> wrote: > >> Do you have it inn GITHUB, can it be shared? >> >> Best, Ravion >> >> On Sep 7, 2016 3:19 PM, "Paul Tyson" <[email protected]> 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 <[email protected]> >>> 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 <[email protected]> >>> 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 <[email protected]> >>> 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 (रविशंकर नायर) >>>>>> <[email protected]> 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" <[email protected]> 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 (रविशंकर नायर) < >>>>>>>> [email protected]> 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 >>>>> >>> >>>
