Thank you all for your replies. I am indeed talking about working with
multiple back ends (oracle, mysql, or any valid DBI module) in the same
query.
I'll post any follow-up questions to the dev list.
Andrew
On 06/26/2013 08:26 AM, Andrew Snyder wrote:
I want to write a query like:
select clients.client.client_id, columnar.sales.total_sales,
web.page_hits from clients, columnar, web
where clients.client_id = columnar.client_id
and clients.client_id = web.client_id
in a system where 'clients' is actually one or more relational
databases, 'columnar' is one or columnar databases, and 'web' is the
Apache logs on one or more web servers. The dbi driver would be
configured to connect to the correct databases and filter web hits
based on 'client_id'.
Has somebody written that already?
Thanks,
Andrew