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

Writing Jena Model to CSV

[lookman sanni]

Hi all,

I am trying in vain to write a Jena model to a text file using
RDFDataMgr.write(outputstream, dataset2, lang).

This works well for Lang such as RDFXML, TRIG, TURTLE, NQUADS. However for
Lang.CSV, it is firing a RiotException of which I have no idea:


*Exception in thread "main" org.apache.jena.riot.RiotException: No graph
writer for null*
* at
org.apache.jena.riot.RDFDataMgr.createGraphWriter$(RDFDataMgr.java:1199)*
* at org.apache.jena.riot.RDFDataMgr.write$(RDFDataMgr.java:1211)*
* at org.apache.jena.riot.RDFDataMgr.write(RDFDataMgr.java:1004)*
* at org.apache.jena.riot.RDFDataMgr.write(RDFDataMgr.java:995)*
* at org.apache.jena.riot.RDFDataMgr.write(RDFDataMgr.java:936)*
* at *

Has anyone come across this in the past and has some hints on its why/how
to solve it ?

Thanks, Lookman

-- 
Best Regards

Lookman SANNI

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

Re: extending an existing dataset

[Sandor Kopacsi]

Dear Andy,

Thank you for your answer.

Not quite sure of the setup you have - the "ttl file of the dataset" 
suggest default graph? 

I mean the SKOS content in a data file in Turtle format by that.
I do not use the default graph, I use individual URIs as graph names for 
the individual data files that I am going to store in the TDB.


I am not sure, but I am afraid that the suggested s-put scrip is not 
appropriate to upload new data files in my case, since I have already 
several other data files in the dataset that I want to keep intact. I 
only would like to replace a certain datafile with a new one under the 
same graph name or extend it with some additional triplets. As far as I 
know  s-put will clean the entire dataset first before it uploads the 
new datafile. But I might use s-post, that - according to may knowledge 
- can add new datafile without cleaning the existing data files from the 
TDB. Am I right?


Another the question is, how can I delete first a dedicated graph from 
the dataset. The utility s-delete might help, or do I completely 
misunderstand the work of s-post and s-put?


I don't have too much experience in UNIX or Linux, but what should I do 
directly with wget or curl, that you suggested to see?


SPARQL update can be also useful. Could you send me more information or 
a link about the usage in my case?


Thank you very much and best regards,
Sandor


Am 05.09.2016 um 22:47 schrieb Andy Seaborne:



On 05/09/16 11:40, Sandor Kopacsi wrote:

Dear Andy,

(I try to start a new thread by writing a new mail, is it the right 
way?)


You are right, update was not enabled in the config.ttl, that I used for
that session by excluding the lines

# fuseki:serviceUpdate"update" ;
# fuseki:serviceUpload"upload" ;

(Sorry for the silly mistake.)

I used the port 3030:/sparql.tpl when I tried to upload the dataset.

But anyway, I used an URI for the graph name, that has been already used
(http://www.statistik.at/2012). I wanted to replace a previously
uploaded dataset, where some information was missing. I added the
missing information to the the ttl file of the dataset, and wanted
*upload again the corrected dataset under the same graph name. Is it a
right way to extend an existing dataset*?


Not quite sure of the setup you have - the "ttl file of the dataset" 
suggest default graph?


You can remove and reload the data or modify it in place.

1/ Remove-replace:

An HTTP request of "PUT http://localhost:3030/dataset"; with 
Content-type text/turtle and the file will do. See "wget" or "curl".


There is an "s-put" script in the Fuseki distribution for a single graph.

s-put http://localhost:3030/dataset default NewFile.ttl


2/ Use SPARQL Update to find and change the data.

For Quads you can PUT TriG,N-Quads to the http://localhost:3030/dataset

Andy



Thanks,
Sandor



Am 02.09.2016 um 20:38 schrieb Andy Seaborne:

Please start a new thread for a new question.

--

There is not enough information here to answer the question.

What URL are you uploading to?
Is update enabled?

Andy



On 02/09/16 16:09, Sandor Kopacsi wrote:

Dear List Members,

I have the following problem:

I have started Fuseki from its base folder (/var/www/fuseki/) without
any problem, but when I want to upload a previously successfully
uploaded file to a named graph or to the default graph I got the error
message:

"Error 404: Not Found

Fuseki - version 1.4.0 (Build date: 2016-05-10T11:59:39+)"

Strange is, that Fuseki doesn't send any reaction to the Upload 
request.

Last message appeared when I started Fuseki:
"17:00:15 INFO  Started 2016/09/02 17:00:15 CEST on port 3030"

I have set the FUSEKI_BASE variable, but it did not help either.

What can be wrong?

Thanks in advance,
Sandor





--
Dr. Sandor Kopacsi
IT Software Designer

Vienna University Computer Center
Universitätsstraße 7 (NIG)
A-1010 Vienna

Phone:  +43-1-4277-14176
Mobile: +43-664-60277-14176

Re: rdfs:comment

[Sidra shah]

Cant we access it through a Resource? If I include comment with every
instance of Question (Question is class name) like: What is capital of
Spain? here I include rdfs:comment of Madrid.
Which country has more population? here I include rdfs:comment of China.

So later I set condition like if user did not answer the question
correctly, display rdfs:comment of that question.
if(Question.get(i).answer not correct) then Question.get(i).addcomment();

addcomment() is a method of type Literal in Jena.

On Wed, Sep 7, 2016 at 2:59 AM, Lorenz Buehmann <
buehm...@informatik.uni-leipzig.de> wrote:

> How many students of you are doing the same homework assignment?
>
>
> Write a SPARQL query to get the rdfs:comment from the DBpedia endpoint.
>
> On 06.09.2016 14:17, Sidra shah wrote:
> > I have a question class in my ontolgy which have instance: What is
> capital
> > city of Spain? I have then Answer class having instance Madrid along with
> > two other options London, Berlin. This is my owl file.
> >
> > Now in Jena/Java code, I want if user selects wrong option (not Madrid),
> it
> > means user does not know about Madrid so I want to display him about
> Madrid
> > a short details in shape of rdfs:comment Madrid.
> >
> > On Tue, Sep 6, 2016 at 3:53 AM, Lorenz Buehmann <
> > buehm...@informatik.uni-leipzig.de> wrote:
> >
> >> I don't understand what you are after.
> >>
> >>
> >> 1) This is not a Protege mailing list
> >> 2) http://dbpedia.org/Madrid is not a valid DBpedia URI
> >> 3) rdfs:comment could be retrieved by
> >> 3)a) SPARQL query
> >> 3)b) Load all triples about a particular resource, load those triples
> >> into Jena, use Jena RDF layer interface to get the information
> >> 4) I can't see the image, probably attachments are not allowed here
> >>
> >> Lorenz
> >>
> >> On 06.09.2016 12:43, Sidra shah wrote:
> >>> Hi
> >>>
> >>> How can we get the rdfs:comment of certain resource in dbpedia? I give
> >>> the address of resource in protege, but when I close it and open
> >>> again, the address changes again to my ontology address and under
> >>> comment Annotation only the address appears like
> >>> http://dbpedia.org/Madrid instead of the comments about Madrid city.?.
> >>>
> >>> And how can we use this rdfs:comment in the jena code? Is it possible
> >>> to import the rdfs:comment details in our ontology and then access it
> >>> using Jena code?
> >>>
> >>> Inline image 1
> >>
>
>

Re: rdfs:comment

[Lorenz Buehmann]

How many students of you are doing the same homework assignment?


Write a SPARQL query to get the rdfs:comment from the DBpedia endpoint.

On 06.09.2016 14:17, Sidra shah wrote:
> I have a question class in my ontolgy which have instance: What is capital
> city of Spain? I have then Answer class having instance Madrid along with
> two other options London, Berlin. This is my owl file.
>
> Now in Jena/Java code, I want if user selects wrong option (not Madrid), it
> means user does not know about Madrid so I want to display him about Madrid
> a short details in shape of rdfs:comment Madrid.
>
> On Tue, Sep 6, 2016 at 3:53 AM, Lorenz Buehmann <
> buehm...@informatik.uni-leipzig.de> wrote:
>
>> I don't understand what you are after.
>>
>>
>> 1) This is not a Protege mailing list
>> 2) http://dbpedia.org/Madrid is not a valid DBpedia URI
>> 3) rdfs:comment could be retrieved by
>> 3)a) SPARQL query
>> 3)b) Load all triples about a particular resource, load those triples
>> into Jena, use Jena RDF layer interface to get the information
>> 4) I can't see the image, probably attachments are not allowed here
>>
>> Lorenz
>>
>> On 06.09.2016 12:43, Sidra shah wrote:
>>> Hi
>>>
>>> How can we get the rdfs:comment of certain resource in dbpedia? I give
>>> the address of resource in protege, but when I close it and open
>>> again, the address changes again to my ontology address and under
>>> comment Annotation only the address appears like
>>> http://dbpedia.org/Madrid instead of the comments about Madrid city.?.
>>>
>>> And how can we use this rdfs:comment in the jena code? Is it possible
>>> to import the rdfs:comment details in our ontology and then access it
>>> using Jena code?
>>>
>>> Inline image 1
>>

Re: Jena rules to assign individuals to subclasses

[javed khan]

Thanks Soroka for your help.

On Tue, Sep 6, 2016 at 12:46 PM, A. Soroka  wrote:

> [ exstu: (?stu rdf:type Student), (?stu marks ?m), greaterThan(?m, 60) ->
> (?stu rdf:type ExcellentStudents) ]
>
> is one way to do this. Please look at the examples on that same page.
>
> ---
> A. Soroka
> The University of Virginia Library
>
> > On Sep 6, 2016, at 3:30 PM, javed khan  wrote:
> >
> > Thanks Soroka.
> >
> > I do not know how to use* greaterThan(?x, ?y) here in my case? How can I
> > compare the marks data property with this?*
> >
> > On Tue, Sep 6, 2016 at 12:09 PM, A. Soroka  wrote:
> >
> >> https://jena.apache.org/documentation/inference/index.html#RULEbuiltins
> >>
> >> ---
> >> A. Soroka
> >> The University of Virginia Library
> >>
> >>> On Sep 6, 2016, at 3:05 PM, javed khan  wrote:
> >>>
> >>> I have *Student* class, having *ExcellentStudents* and *PoorStudents*
> as
> >>> subclasses.
> >>> My ontology contains Student *marks* (*marks is data property*) and
> based
> >>> on marks students can be assigned to ExcellentStudents and
> PoorStudents.
> >>>
> >>> My requirements is to achieve it using Jena rules. I need some help in
> >>> getting to this.  I want something like :
> >>>
> >>> If Student X marks>60, assign Student X to ExcellentStudent class else
> >>> assign to PoorStudents class. I have attempted the following but could
> >> not
> >>> succeeded.
> >>>
> >>>
> >>> String rule = "[rule1:"(?x
> >>> http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> >>> http://www.owlontologies.com/Student.owl#*Student*)+
> >>>
> >>> (?x http://www.owl-ontologies.com/Student.owl#marks  *>60*)" +
> >>>
> >>>
> >>>"->(?x http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> >>> http://www.owlontologies.com/Student.owl#*ExcellentStudent*)]";
> >>>
> >>>
> >>> I think the problem will be in marks>60 because I do not know how to
> >>> compare things inside Jena rules.
> >>
> >>
>
>