"It is not the strongest of the species that survives, nor the most intelligent that survives. It is the one that is most adaptable to change." Charles Darwin
It's that time of year again… winding down 2012, ramping up 2013. What changes can we expect next year?
I see a significant shift in Data Warehousing to do more and more reporting out of OLTP systems and less reliance on OLAP systems. I don't see EDWs going away quickly, but over time they will evolve into something less OLAPish and more closely tide to real time source data and systems of record.
I've always advocated not moving data from the systems of record to reporting environments, or if necessary move it as little as possible.
Data is like perishable fruit, the more you move it the less valuable it becomes. Latency causes it to spoil and become stale.
Performance characteristics on OLTP systems are now starting to allow for OLAP on the same platform – or at least closer to the system of record, and in near real time.
There's my prediction for the future.