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