Hi guys,

I want to automatically analyse two MySQL databases. Users can modify or delete parts of database. But I want to analyse the incoming data set with history, e.g. simple task: ranking of user's acquisition.

First question: Which is the best way? How would you implement it? Ideas?

My idea is a "data warehouse":
I will store a summarized data set in separate database and analyse it there.

Second question: good open source ETL or BI tools?
I want it to automatically execution (each 5min or real-time or...??)?

Please can you help me?! Thx.