Avatar billede Naffe Nybegynder
14. april 2011 - 17:12 Der er 1 kommentar og
1 løsning

FK to a different database

Hey guys. Sorry for writing in English, but I need my boss to be able to read it as well.

Im working in a company where we are trying to create an online community for pregnant women of Colombia. Women will, the majority of times, have a doctor, so we need a foreign key from the mothers table to the doctors to avoid redundancy. However. The doctors will not allow us to copy their table and put it into ours, which would be the best solution, and we cant put our data inside their database because we are expecting some serious activity.
Since we are expecting a lot of calls requesting data from their base, it would be silly to call across databases, though it probably could be done with a trigger.

What would you suggest?

Can it even be done without a trigger?(at this point the language is not a problem)

What exactly are the backside of using a trigger?

Thanks in advance
Jakob
Avatar billede arne_v Ekspert
15. april 2011 - 00:06 #1
Given the restrictions then my suggestion would be to:
- put the FK logic in the app
- do aggressive caching in memory of the doctor data
Avatar billede arne_v Ekspert
22. maj 2011 - 21:52 #2
OK?
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester



IT-JOB