首页    期刊浏览 2025年07月15日 星期二
登录注册

文章基本信息

  • 标题:Columnar Storage in SQL Server 2012
  • 本地全文:下载
  • 作者:Per-Ake Larson palarson@microsoft.com Eric N. Hanson ehans@microsoft.com Susan L. Price susanp@microsoft.com
  • 期刊名称:Bulletin of the Technical Committee on Data Engineering
  • 出版年度:2012
  • 卷号:35
  • 期号:01
  • 出版社:IEEE Computer Society
  • 摘要:SQL Server 2012 introduces a new index type called a column store index and new query operators that efficiently process batches of rows at a time. These two features together greatly improve the performance of typical data warehouse queries, in some cases by two orders of magnitude. This paper outlines the design of column store indexes and batch-mode processing and summarizes the key benefits this technology provides to customers. It also highlights some early customer experiences and feedback and briefly discusses future enhancements for column store indexes.
国家哲学社会科学文献中心版权所有