By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,664 Members | 1,612 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,664 IT Pros & Developers. It's quick & easy.

Query over severall databases

P: n/a
Hello to all,

I have a 'small' problem. I have made a application in php that connect
trough ODBC to a Oracle RDB (VMS) or Basis+ database (VMS) and present the
data to a user. There are 2 Oracle databases in diffrent city's and 5 Basis+
databases allso in diffrent city's. Now we have to logon to each database
and can ask a question. My goal is now that on one question all databases
give, when present, all its data.

Is that possible and how do I do that. Is there someone who has the answer?

Willem
Jul 16 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"wimmie" <w.*****@chello.nl> wrote in message
news:<M5********************@amsnews03.chello.com> ...

I have a 'small' problem. I have made a application in php that connect
trough ODBC to a Oracle RDB (VMS) or Basis+ database (VMS) and present the
data to a user. There are 2 Oracle databases in diffrent city's and 5 Basis+
databases allso in diffrent city's. Now we have to logon to each database
and can ask a question. My goal is now that on one question all databases
give, when present, all its data.

Is that possible and how do I do that.


It's possible, but expensive. You need to replicate all source databases
in a central location and then query that central location. Read a couple
of books on data warehousing, it should give you an idea of what you're
up against...

Cheers,
NC
Jul 16 '05 #2

P: n/a
It does depend on what you want to do,

If you simply want to query al the databases as long as you can get a
connection path to them all you can use PHP (either directly or an ODBC
connection). You don't say what you want to do to anlyise, you could for
example extract all the data into an result set and insert them all into a
large local table, or if you have access to Oracle or SQLServer you can
assing local names to remote tables which can them take part in a single
query. To svae time you could use PHP to issue 5 jobs which query the tables
in parralel and thing bring it all back together. This is a bit fiddly and
does depend on what level of response you are after.

One final point of you are doing so much work on a single PHP page you might
want to up the page time out figure (can't remembr off hand wat it is
though)

If this is not clear post another message explaining what you want to do.

regrards

Kevin

"Nikolai Chuvakhin" <nc@iname.com> wrote in message
news:32**************************@posting.google.c om...
"wimmie" <w.*****@chello.nl> wrote in message
news:<M5********************@amsnews03.chello.com> ...

I have a 'small' problem. I have made a application in php that connect
trough ODBC to a Oracle RDB (VMS) or Basis+ database (VMS) and present the data to a user. There are 2 Oracle databases in diffrent city's and 5 Basis+ databases allso in diffrent city's. Now we have to logon to each database and can ask a question. My goal is now that on one question all databases give, when present, all its data.

Is that possible and how do I do that.


It's possible, but expensive. You need to replicate all source databases
in a central location and then query that central location. Read a couple
of books on data warehousing, it should give you an idea of what you're
up against...

Cheers,
NC

Jul 16 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.