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
