Saw an interesting presentation on Google Video about data mining in the TV world at Rentrak.
They talk about how they mine lots of data and get real-time reports from them. Basically it comes down to using a patched/extended PostgreSQL plus a simplified query language that they convert to SQL.
In that context it might be interesting to check out
Bizgres, though it was not mentioned in the
presentation. The Bizgres web site says:
bq. The Bizgres Project aims to make PostgreSQL the world’s most robust
open source database for Business Intelligence.