471,306 Members | 850 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

Query over severall databases

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
2 1797
"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
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.

Similar topics

3 posts views Thread by G rumpy O ld D uffer | last post: by
1 post views Thread by David Sorber via AccessMonster.com | last post: by
9 posts views Thread by noor.rahman | last post: by
14 posts views Thread by gert | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.