Thank you for your reply, much appreciated.
Ahmad Flaifel
________________________________
From: Diogo FC Patrao <[email protected]>
To: Richard Cyganiak <[email protected]>
Cc: ahmad flaifel <[email protected]>; [email protected]
Sent: Sun, May 22, 2011 9:19:29 PM
Subject: Re: [d2rq-dev] Using D2R Server :: Please help
Hello,
I have some suggestions:
- use oracle xe (free version) and dblinks to create a federation.
Then modify your mapping to use different tables within the same
database. However, d2rq didn´t work too well mapping two tables into
the same class.
- replicate these dbs into one single db (I reccomend pentaho).
- setup two d2r servers and query them using ARQ 1.1 SPARQL extension
clause SERVICE.
however, live mapping is very inneficient at the present time. I´m
much more inclined to create RDFs periodically then query it instead
of the D2R server endpoint.
--
diogo patrão
On Sun, May 22, 2011 at 1:25 PM, Richard Cyganiak <[email protected]> wrote:
D2R does not support querying across multiple databases.
>
>I would recommend one of the following approaches:
>
>- load all data into a single database
>- export RDF from both databases using dump-rdf and load it into a triple store
>- consider another tool
>
>Best,
>Richard
>
>
>
>
>On 21 May 2011, at 10:08, ahmad flaifel wrote:
>
>> Dear all,
>>
>> I am using the D2R server tool to help my friend to do his PhD thesis but I
>> am
>>wondering if such a case is supported or not:
>> I have mapping file for 2 databases as follow:
>>
>> database1 contains student table that contains major Id column
>> database2 contains major table with major id and name columns
>>
>> I want to map major id property of student table from database1 to matching
>>major record from database2. Is that possible or should I have to write some
>>code to make tool support this such case.
>>
>> Thanks in advance
>>
>> Ahmad Flaifel
>>
------------------------------------------------------------------------------
>> What Every C/C++ and Fortran developer Should Know!
>> Read this article and learn how Intel has extended the reach of its
>> next-generation tools to help Windows* and Linux* C/C++ and Fortran
>> developers boost performance applications - including clusters.
>>http://p.sf.net/sfu/intel-dev2devmay_______________________________________________
>>_
>> d2rq-map-devel mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
>
>
>------------------------------------------------------------------------------
>What Every C/C++ and Fortran developer Should Know!
>Read this article and learn how Intel has extended the reach of its
>next-generation tools to help Windows* and Linux* C/C++ and Fortran
>developers boost performance applications - including clusters.
>http://p.sf.net/sfu/intel-dev2devmay
>_______________________________________________
>d2rq-map-devel mailing list
>[email protected]
>https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
>
------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
_______________________________________________
d2rq-map-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
