Hello, Richard,
1)
On Wed, Dec 1, 2010 at 8:54 AM, Diogo FC Patrao <[email protected]>wrote:
> I thought of using oracle-xe and dblinks to federate the RDBS. does d2rq
> allows a table to be called, say, "ext_db.ext_ta...@my_link"?
It doesn't. I just checked it. Solved by creating a view that access the
links.
I suggest that d2rq enable this kind of naming. Yes, it is totally
oracle-specific, but it is very handy to join different databases without
ETL-ing.
2) Doing the above, I was trying to map three tables from three different
databases containing patient data into a single class, vocab:Patient.
The patient IDs are slightly different, so I'm using translateWith to get
each different ID and transform into a UID (I think I said this before =] ).
So, in system 1, i got ID_1 and in system 2, ID_2. Both map to the same UID,
and then they map back to the local IDs specifying the UID and system.
I wrote three distinct classMaps, using translateWith to use a function to
map each local ID to UID.
Then, I mapped three properties from each different table, so I would know
when a patient has data in system 1, 2, or 3. Lets say the properties are
called vocab:prop1, vocab:prop2 and vocab:prop3.
If I try to get all patients with data in all three systems, I would write,
in SPARQL:
SELECT DISTINCT * WHERE {
?paciente vocab:prop1 ?anything1.
?paciente vocab:prop2 ?anything2.
?paciente vocab:prop3 ?anything3.
}
But it yields a query that JOINs all three tables using the local IDs.
So I guess that translateWith is being ignored in this particular case. Is
d2rq supposed to do it? Or am I (again) going beyond it?
thanks,
dfcp
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
d2rq-map-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
