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
