Analysis - exploratory ad-hoc queries

> (OLAP|Analytic)

1 - About

Also known as speed-of-thought analysis means that analyst can pose queries and get an immediate responses.

When an analyst is running exploratory ad-hoc queries against a data warehouse of historical data, it doesn’t make much sense to use materialized views — for those kinds of queries it’s better to just keep all the raw events, and to build databases which can scan over them very quickly. Modern column stores have become very good at that.


3 - Documentation / Reference