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