Jena is a library for storing, processing, and querying RDF, not a device (magical or otherwise) for deriving triples from other data sources. Using fuzzy matching to resolve items in a database to named things-in-the-world is not a job for an RDF library. There are things that do that; I happen to work at a place that has a commercial offering for this, and there are many others.
On Wed, Sep 7, 2016 at 2: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