Tuesday, November 9, 2010

Speed up your reports!

I've found an interesting post at Goodman on BI. It explains how to use a dedicated datawarehouse database (DynamoDB) to load partial data just for the required report or reports.
The idea is extract the data from the MySql OLTP and load it into de datawarehouse database.

So ... can this approach used to do real time reporting? I guess. Using an in-memory database and selecting just the requeried data, some reports could be runned with enough spped and accuracy.
I must need find some free hours to try this approach.

No comments: