ABSTRACT
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.
- Batory, D. S.: On searching transposed files. ACM Trans. Database Syst. 4, 4 (1979), 531--544. Google ScholarDigital Library
- P. A. Boncz, M. Zukowski, and N.Nes, MonetDB/X100: Hyper-pipelining query execution. CIDR, 2005, 225--237.Google Scholar
- G. P. Copeland and S. Khoshafian, A decomposition storage model. SIGMOD, 1985, 268--279. Google ScholarDigital Library
- Harizopoulos, S., Liang, V., Abadi, D.J., and Madden, S.: Performance tradeoffs in read-optimized databases. VLDB, 2006, 487--498. Google ScholarDigital Library
- Sándor Héman, Marcin Zukowski, Niels J. Nes, Lefteris Sidirourgos, Peter A. Boncz: Positional update handling in column stores. SIGMOD, 2010: 543--554. Google ScholarDigital Library
- J. A. Hoffer and D. G. Severance, The use of cluster analysis in physical data base design, VLDB, 1975, 69--86. Google ScholarDigital Library
- M. Holsheimer and M. L. Kersten, Architectural support for data mining, KDD, 1994, 217--228.Google Scholar
- D. Inkster, M. Zukowski, and P. A. Boncz, Integration of VectorWise with Ingres, SIGMOD Record, 40(3):45--53, 2011. Google ScholarDigital Library
- P.-Å. Larson, C. Clinciu, E. N. Hanson, A. Oks, S. L. Price, S. Rangarajan, A. Surna, and Q. Zhou, Sql Server column store indexes, SIGMOD, 2011, 1177--1184. Google ScholarDigital Library
- Microsoft, Column store Indexes in Books Online for SQL Server 2012, available at http://msdn.microsoft.com/en-us/library/gg492088.aspx.Google Scholar
- Microsoft, SQL Server Column store Index FAQ, http://social.technet.microsoft.com/wiki/contents/articles/3540.sql-server-column store-index-faq-en-us.aspx.Google Scholar
- M. Stonebraker et al. C-Store: A Column-oriented DBMS. VLDB, 2005, 553--564. Google ScholarDigital Library
- TPC Benchmark DS (Decision Support), Draft Specification, Version 32, http://tpc.org/tpcds.Google Scholar
- ExaSolution, http://www.exasol.comGoogle Scholar
- Greenplum Database, http://www.greenplum.comGoogle Scholar
- InfoBright, http://www.infobright.comGoogle Scholar
- Actian VectorWise, http://www.actian.com/products/vectorwise.Google Scholar
- MonetDB, http://monetdb.cwi.nlGoogle Scholar
- ParAccel Analytic Database, http://paraccel.comGoogle Scholar
- SAND CDBMS, http://www.sand.comGoogle Scholar
- Sybase IQ Columnar database, http://www.sybase.com/products/datawarehousing/sybaseiqGoogle Scholar
- Teradata Columnar, http://www.teradata.com/products-and-services/database/teradata-14Google Scholar
- Vertica, http://www.vertica.comGoogle Scholar
Index Terms
- Enhancements to SQL server column stores
Recommendations
SQL server column store indexes
SIGMOD '11: Proceedings of the 2011 ACM SIGMOD International Conference on Management of dataThe SQL Server 11 release (code named "Denali") introduces a new data warehouse query acceleration feature based on a new index type called a column store index. The new index type combined with new query operators processing batches of rows greatly ...
Real-time analytical processing with SQL server
Proceedings of the 41st International Conference on Very Large Data Bases, Kohala Coast, HawaiiOver the last two releases SQL Server has integrated two specialized engines into the core system: the Apollo column store engine for analytical workloads and the Hekaton in-memory engine for high-performance OLTP workloads. There is an increasing ...
Column-stores vs. row-stores: how different are they really?
SIGMOD '08: Proceedings of the 2008 ACM SIGMOD international conference on Management of dataThere has been a significant amount of excitement and recent work on column-oriented database systems ("column-stores"). These database systems have been shown to perform more than an order of magnitude better than traditional row-oriented database ...
Comments