ROLAP with Column Store – Deep Dive
The Column Store Index is an
exciting new technology in SQL Server 2012. Using column stores, you can
unlock new levels of performance for data warehouses – often gaining an order
of magnitude speedup on queries. In this session, we will talk about the
design patterns you must apply to take advantage of this functionality.
We will use a real, high end
customer solution as a case study. As we dig deep into the workload, we will
show you examples of Column Store DW query plans and walk you through the
design decisions we made along the way. The ride will not be smooth, but we
hope you will learn from the challenges we faced, and the methods we used to
overcome them.
As bonus feature, we will also
look at how column stores in ROLAP cubes compare with MOLAP cubes.
Alexei Khalyako
Alexei has been
with Microsoft since 10+ years. He has started with SQL Server collecting
globalization requirements from European countries during the version SQL
Server 2005 development. Since about 2 years a member of European part of the
SQL Customer Advisory team. He is focusing on large scale Data Warehouses such
as well-known European Telecommunication Organizations, on architecture
principles which are well reflected in the Fast Track reference Architecture
guide. Has published articles on different database topics. Alexei has
graduated from Moscow Engineering Physics Institute