Query over severall databases

[wimmie]

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

[Nikolai Chuvakhin]

Re: Query over severall databases

"wimmie" <w.palm1@chello .nl> wrote in message
news:<M5P3b.278 64$Rk.1575602@a msnews03.chello .com>...[color=blue]
>
> 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.[/color]

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

[Kevin Robinson]

Re: Query over severall databases

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:32d7a63c.0 308301234.785a4 08d@posting.goo gle.com...[color=blue]
> "wimmie" <w.palm1@chello .nl> wrote in message
> news:<M5P3b.278 64$Rk.1575602@a msnews03.chello .com>...[color=green]
> >
> > 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[/color][/color]
the[color=blue][color=green]
> > data to a user. There are 2 Oracle databases in diffrent city's and 5[/color][/color]
Basis+[color=blue][color=green]
> > databases allso in diffrent city's. Now we have to logon to each[/color][/color]
database[color=blue][color=green]
> > and can ask a question. My goal is now that on one question all[/color][/color]
databases[color=blue][color=green]
> > give, when present, all its data.
> >
> > Is that possible and how do I do that.[/color]
>
> 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[/color]