Re: Relationship between similar columns from multiple databases

[रविशंकर नायर]

Sure will do, thanks a lot for pointers and help.

Best, Ravion

On Thu, Sep 8, 2016 at 8:08 AM, A. Soroka  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
> >   
> >   - access the content of the database as 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
> >   
> >
> > D2RQ is Open Source software and published under the Apache license
> > . The source code is
> available
> > on GitHub . You can contact the dev team
> > through the issue tracker .
> >
> > 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"  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 
> >>> 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 
> >>> 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 (रविशंकर नायर)
> >>  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"  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
> >
> >>>
> >>>
>
>

Re: Relationship between similar columns from multiple databases

[A. Soroka]

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 (रविशंकर नायर) 
>  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
>   
>   - access the content of the database as 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
>   
> 
> D2RQ is Open Source software and published under the Apache license
> . The source code is 
> available
> on GitHub . You can contact the dev team
> through the issue tracker .
> 
> 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"  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 
>>> 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 
>>> 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 
>>> 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 (रविशंकर नायर)
>>  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"  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
> 
>>> 
>>> 

Re: Relationship between similar columns from multiple databases

[A. Soroka]

Other systems of interest, if you are chiefly concerned with batch processing 
(and not continually updated data) are:

Web Karma:

https://usc-isi-i2.github.io/karma/

Open Refine with RDF extension:

http://openrefine.org/
https://github.com/OpenRefine/grefine-rdf-extension

You may also consider ETL tools like Talend4SW: 
https://fbelleau.github.io/talend4sw/

---
A. Soroka
The University of Virginia Library

> On Sep 7, 2016, at 3:11 PM, Paul Tyson  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  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 (रविशंकर नायर)
>>  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"  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
> 

Re: Relationship between similar columns from multiple databases

[रविशंकर नायर]

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
   
   - access the content of the database as 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
   

D2RQ is Open Source software and published under the Apache license
. The source code is available
on GitHub . You can contact the dev team
through the issue tracker .

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"  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 
>> 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 
>> 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 
>> 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 (रविशंकर नायर)
>> >>>  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"  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
>> >>
>>
>>

Re: Relationship between similar columns from multiple databases

[रविशंकर नायर]

Do you have it inn GITHUB, can it be shared?

Best,  Ravion

On Sep 7, 2016 3:19 PM, "Paul Tyson"  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 
> 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 
> 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 
> 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 (रविशंकर नायर)
> >>>  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"  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
> >>
>
>

Re: Relationship between similar columns from multiple databases

[Paul Tyson]

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  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  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  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 (रविशंकर नायर)
>>>  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"  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
>> 

Re: Relationship between similar columns from multiple databases

[Martynas Jusevičius]

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  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  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 (रविशंकर नायर)
>>  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"  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
>

Re: Relationship between similar columns from multiple databases

[Paul Tyson]

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  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 (रविशंकर नायर)
>  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"  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

Re: Relationship between similar columns from multiple databases

[Adrian Walker]

Hi,

You wrote:



*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). *
That's knowledge that you need to specify to the system.  (Even if the
column names are the same, their meanings could be different).

You can specify, and then run, the correct correspondence in executable
English, see executable-english.com .

HTH,  -- Adrian

Adrian Walker
Reengineering LLC
San Jose, CA, USA

On Wed, Sep 7, 2016 at 10:43 AM, ☼ 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
>

Re: Relationship between similar columns from multiple databases

[Phillip Rhodes]

You could certainly use Jena to keep a repository of those kinds of
metadata mappings and use it to help drive queries into either of the
source databases (or to merge that data into a new database, which might or
might not be RDF based).   But what Jena doesn't give you is any specific
tooling for doing the discovery process, as far as saying "EMP in DB1 is
most likely the same thing as EMPLOYEE in DB2".  That could be done, but it
is orthogonal to whether or not you use Jena.

How you'd go about doing the that discovery (leaving aside the idea of
doing it all by hand) is probably going to be non-deterministic and is
probably close to an open research problem in the AI / Machine Learning
realm.


Phil


This message optimized for indexing by NSA PRISM

On Wed, Sep 7, 2016 at 2:57 PM, John A. Fereira  wrote:

>
> I am not exactly clear what Ravion is trying to do but wondered if D2R Map
> might help
>
> https://sourceforge.net/projects/d2r-map/
>
>
> It would require setting up two D2R config files that each mapped one of
> the database into a common RDF model
>
>
>
>
> On 9/7/16, 2:39 PM, "Martynas Jusevičius"  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 (रविशंकर नायर)
> > 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"  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
>

Re: Relationship between similar columns from multiple databases

[John A. Fereira]

I am not exactly clear what Ravion is trying to do but wondered if D2R Map 
might help

https://sourceforge.net/projects/d2r-map/


It would require setting up two D2R config files that each mapped one of the 
database into a common RDF model




On 9/7/16, 2:39 PM, "Martynas Jusevičius"  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 (रविशंकर नायर)
> 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"  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

Re: Relationship between similar columns from multiple databases

[Martynas Jusevičius]

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 (रविशंकर नायर)
 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"  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

Re: Relationship between similar columns from multiple databases

[रविशंकर नायर]

Thanks, noted

Best, Ravion

On Sep 7, 2016 2:15 PM, "Benson Margulies"  wrote:

> 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 (रविशंकर नायर)
>  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"  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
>

Re: Relationship between similar columns from multiple databases

[Benson Margulies]

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 (रविशंकर नायर)
 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"  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

Re: Relationship between similar columns from multiple databases

[रविशंकर नायर]

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"  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

Re: Relationship between similar columns from multiple databases

[A. Soroka]

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 (रविशंकर नायर) 
>  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

Relationship between similar columns from multiple databases

[रविशंकर नायर]

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