On 25 Nov 2010, at 20:32, Diogo FC Patrao wrote: > Murphy's law #1: just after you bother someone, the answer pops up! > > map:minha_translation_table a d2rq:TranslationTable; > d2rq:javaClass "meuteste.teste2". > > it worked !
Great to hear that! Best, Richard > > > > Diogo F.C. Patrão > Manager of Medical Informatics > Biotechnology Laboratory > Hospital A.C. Camargo > http://www.accamargo.org.br/ > > > On Thu, Nov 25, 2010 at 5:53 PM, Diogo FC Patrao <[email protected] > >wrote: > >> Hello all >> >> I'm building a data integration system for three patient databases: >> one in >> Oracle, other in Interbase, other in MySQL. >> >> Each one identifies the same patient by a somewhat different ID, so >> we >> wrote a Java function that maps all IDs to a new, unified, code >> (let's call >> it the unified id, and the others the local ids). >> >> The perfect situation would be to get the unified id directly from >> the >> database, so I would unify all patient data with it. However >> >> - The function is pretty extensive and I would like to avoid to >> reimplement >> it on the different dialects of SQL above; >> >> - I don't control 2 of the 3 databases, so I can't easily add some >> library >> that allows the database to access the Java function (and I don't >> even know >> if there is such thing! for mysql, afaik*, is no picnic); >> >> >> Alternative 1) So, is there a way I can refer to this function in the >> mapping file, like: >> >> map_xunfa:Conversor a d2rq:ClassMap; >> d2rq:dataStorage map_xunfa:database; >> d2rq:uriPattern "Patient/@@br.accamargo.my_function( >> PACIENTE.LOCAL_ID )@@"; >> d2rq:class vocab:Patient; >> . >> >> >> Alternative 2) I would map the results of the function into a class. >> Imagine that I produce a table with static contents produced by the >> function: >> >> Unique_id local_id_1 local_id_2 local_id_3 >> 99999999 9 2828123 42341235 >> ... >> >> when in fact my_function_1(local_id_1 ) = >> my_function_2(local_id_2 ) = >> my_function_3(local_id_3 ) = unique_id. >> >> Then I could map each patient to the same class *Patient*, but >> would rely >> on SPARQL to integrate information, like >> >> SELECT * WHERE >> { >> ?patient a vocab:Patient. >> ?unique_id vocab:mapsToLocalId ?local_id. >> FILTER ( >> ?unique_id = 9999999 >> ) >> >> } >> >> Or something. >> >> I could create a table with all possible values, but then I would >> have to >> keep it up-to-date, as the databases are live. So it's possible to >> perform >> such a mapping from a function, instead of a database table? >> >> >> Thanks! >> >> dfcp >> >> >> >> >> *http://planet.mysql.com/entry/?id=13420 >> >> Diogo F.C. Patrão >> Manager of Medical Informatics >> Biotechnology Laboratory >> Hospital A.C. Camargo >> http://www.accamargo.org.br/ >> > ------------------------------------------------------------------------------ > 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 ------------------------------------------------------------------------------ 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
