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...??)?