Enhancements to SQL server column stores
Enhancements to SQL server column stores
复制标题
SQL Server 列存储的增强
DOI：
10.1145/2463676.2463708
复制
发表时间：
2013
期刊：
影响因子：
--
通讯作者：
Mayukh Saubhasik
中科院分区：
文献类型：
--
作者：
P. Larson;C. Clinciu;Campbell Fraser;E. Hanson;Mostafa Mokhtar;Michal Nowakiewicz;Vassilis Papadimos;Susan Price;Srikumar Rangarajan;Remus Rusanu;Mayukh Saubhasik
SQL Server 2012 引入了两项针对数据仓库工作负载的创新：列存储索引和批处理（矢量化）处理模式。它们共同极大地提高了典型数据仓库查询的性能，通常提高 10 倍，在某些情况下提高 100 倍或更多。初始版本的主要限制将在即将发布的版本中得到解决。列存储索引是可更新的，并且可以用作表的基本存储。批处理模式运算符的功能得到了扩展，现有运算符得到了改进，查询优化也得到了增强。本文概述了 SQL Server 的列存储和批处理，特别是即将发布的版本中引入的增强功能。
SQL Server 2012 introduced two innovations targeted for data warehousing workloads: column store indexes and batch (vectorized) processing mode. Together they greatly improve performance of typical data warehouse queries, routinely by 10X and in some cases by a 100X or more. The main limitations of the initial version are addressed in the upcoming release. Column store indexes are updatable and can be used as the base storage for a table. The repertoire of batch mode operators has been expanded, existing operators have been improved, and query optimization has been enhanced. This paper gives an overview of SQL Server's column stores and batch processing, in particular the enhancements introduced in the upcoming release.