Re: cross database queries?

On 26.06.13 14:26, 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?

As far as I understood: yes.

The professional solution is available from 
http://www.easysoft.com/index.html

When you're willing to write some pieces of code, SQL::Statement
and DBI::DBD::SqlEngine will help. But in that case - all data
is fetched into a Perl based SQL engine and I can confirm that
it's highly unoptimized regarding mass data ...

Cheers
-- 
Jens Rehsack