Last week, I posted my thoughts on how new technology enables a simpler and faster database to support your DSR applications. Next Generations DSRs (data handling) Here's a highlight from his post Thoughts on AWS Redshift :
if you can add nodes and scale out to improve query response then why not throw hardware at performance problems rather than build a fragile infrastructure of aggregate tables, cubes, pre-joined/de-normalized marts, materialized views, indexes, etc. Each of these performance workarounds are both expensive to build and expensive to operate.
He goes on to talk about why scale-out has not been generally adopted and how Amazon Redshift changes the game by making it easy to acquire and release processing power on demand.
The answer does not have to be Redshift, perhaps it's Impala or Hekaton or... whatever. Bottom line for me is that new technology enables DSR's that are simpler and faster and that creates a fundamental shift in system capability.
FYI - I have done some DSR-scale testing with Redshift and the results were very impressive. More on that soon.