Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Looking for architectural suggestions
Hello
We have a star-schema holding General Ledger data extracted from our Oracle GL application. Let's say this star-schema is in an Oracle database called GLDB. We are in the process of developing another "client" application (let's call it QRYDB) which, at a certain time during the month, needs to query GLDB. QRYDB will be in a separate database. The queries sent from QRYDB can be broken down into a set of parameters that could be sent to a GLDB procedure which in turn would return 1 numeric value (an amount) to the calling program.
We are currently considering 2 options of getting the data out of GLDB.
Option 1
Option 2
How do you handle inter-database queries ?
Would also appreciate any thoughts on avoiding inter-database queries altogether and managing this interaction using UNIX based messaging using some programming language.
Thank you. Received on Sat Sep 15 2001 - 15:10:45 CDT