Sure will do, thanks a lot for pointers and help. Best, Ravion
On Thu, Sep 8, 2016 at 8:08 AM, A. Soroka <aj...@virginia.edu> wrote: > 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 (रविशंकर नायर) < > ravishankar.n...@gmail.com> 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 (रविशंकर नायर) < > > 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 > >>>>> > >>> > >>> > >