Alternatives to D2RQ to map relational databases content in RDF

[Jean-Baptiste Pressac <Je...@univ-brest.fr>]

Hello,

Besides D2RQ, another interresting tools to expose a relational database 
content in RDF : Ontop <http://ontop.inf.unibz.it/> (University of 
Bolzen, Italy) and DataLift <http://datalift.org/>.

Jean-Baptiste Pressac

Traitement et analyse de bases de donn�es
Production et diffusion de corpus num�riques

Centre de Recherche Bretonne et Celtique
Unit� mixte de service (UMS) 3554
20 rue Duquesne
CS 93837
29238 Brest cedex 3

tel : +33 (0)2 98 01 68 95
fax : +33 (0)2 98 01 63 93

Le 01/06/2016 � 21:46, Andy Seaborne a �crit :
> On 31/05/16 18:32, Fid�l Jiomekong wrote:
>> Hi,
>>
>> i want to subscribe to Jena mailing list.
>>
>> Hi,
>>
>> I'm Jiomekong, phd student at university of Yaounde 1 and i also teach
>> computer science at University of Yaounde 1. I'm JAVA EE developer.
>>
>> I'm working on using ontology to provide better information to users
>> of epidemiological platform.
>>
>> The ontology is constructed and i want to access postges database 
>> using jena.
>>
>> Is it possible ?
>>
>> Best regards
>>
>>
>
> If you mean, you have existing data in a PostgreSQL database and want 
> to view it as RDF via your ontology, you'll need a tool like D2RQ as 
> well. This maps between RDF and views of the database.
>
> If you want to store RDF in PostgreSQL, then jena-sdb will work for 
> moderate sized data.
>
>     Andy
>
>

Re: Alternatives to D2RQ to map relational databases content in RDF

["John A. Fereira" <ja...@cornell.edu>]

Another tool with might be worth looking at is Karma (http://usc-isi-i2.github.io/karma/).  It’s read data from several different formats, including a relational database.   Then one loads in one or more ontologies and it provides a graphical ui to map source data to the ontology.

I am also the project maintainer for a project called VIVO-Harvester (https://github.com/vivo-project/VIVO-Harvester).  It is a suite of tools for ingesting data from a variety of sources into an instance of VIVO (http://vivoweb.org/) , a semantic web application.   The data fetcher, transformation, and transfer tools could be used to create RDF from a variety of sources and does not necessarily have to be used for ingesting data into VIVO.

From: Jean-Baptiste Pressac <Je...@univ-brest.fr>>
Reply-To: "users@jena.apache.org<ma...@jena.apache.org>" <us...@jena.apache.org>>
Date: Thursday, June 2, 2016 at 10:01 AM
To: "users@jena.apache.org<ma...@jena.apache.org>" <us...@jena.apache.org>>
Subject: Alternatives to D2RQ to map relational databases content in RDF


Hello,

Besides D2RQ, another interresting tools to expose a relational database content in RDF : Ontop<http://ontop.inf.unibz.it/> (University of Bolzen, Italy) and DataLift<http://datalift.org/>.

Jean-Baptiste Pressac

Traitement et analyse de bases de données
Production et diffusion de corpus numériques

Centre de Recherche Bretonne et Celtique
Unité mixte de service (UMS) 3554
20 rue Duquesne
CS 93837
29238 Brest cedex 3

tel : +33 (0)2 98 01 68 95
fax : +33 (0)2 98 01 63 93

Le 01/06/2016 à 21:46, Andy Seaborne a écrit :
On 31/05/16 18:32, Fidèl Jiomekong wrote:
Hi,

i want to subscribe to Jena mailing list.

Hi,

I'm Jiomekong, phd student at university of Yaounde 1 and i also teach
computer science at University of Yaounde 1. I'm JAVA EE developer.

I'm working on using ontology to provide better information to users
of epidemiological platform.

The ontology is constructed and i want to access postges database using jena.

Is it possible ?

Best regards



If you mean, you have existing data in a PostgreSQL database and want to view it as RDF via your ontology, you'll need a tool like D2RQ as well. This maps between RDF and views of the database.

If you want to store RDF in PostgreSQL, then jena-sdb will work for moderate sized data.

    Andy