Enhancements to SQL server column stores

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2013, Pages 1159-1168

  Larson, Per Åke ^a   Clinciu, Cipri ^a   Fraser, Campbell ^a   Hanson, Eric N ^a   Mokhtar, Mostafa ^a   Nowakiewicz, Michal ^a   Papadimos, Vassilis ^a   Price, Susan L ^a   Rangarajan, Srikumar ^a   Rusanu, Remus ^a   Saubhasik, Mayukh ^a  

^a MICROSOFT   (United States)

Author keywords

Column store; Columnar storage; Data warehousing; Index; OLAP

Indexed keywords

BATCH MODES; COLUMN-STORE; DATA WAREHOUSE QUERIES; IMPROVE PERFORMANCE; INDEX; OLAP; QUERY OPTIMIZATION; SQL SERVERS;

BATCH DATA PROCESSING;

DATA WAREHOUSES;

EID: 84880566488     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/2463676.2463708     Document Type: Conference Paper

References (23)

1. Batory, D. S.: On searching transposed files. ACM Trans. Database Syst. 4, 4 (1979), 531-544.
2. P. A. Boncz, M. Zukowski, and N. Nes, MonetDB/X100: Hyper-pipelining query execution. CIDR, 2005, 225-237.
3. G. P. Copeland and S. Khoshafian, A de composition storage model. SIGMOD, 1985, 268-279.
4. Harizopoulos, S., Liang, V., Abadi, D.J., and Madden, S.: Performance tradeoffs in read-optimized databases. VLDB, 2006, 487-498.
5. Sándor Héman, Marcin Zukowski, Niels J. Nes, Lefteris Sidirourgos, Peter A. Boncz: Positional update handling in column stores. SIGMOD, 2010: 543-554.
6. J. A. Hoffer and D. G. Severance, The use of cluster analysis in physical data base design, VLDB, 1975, 69-86.
7. M. Holsheimer and M. L. Kersten, Architectural support for data mining, KDD, 1994, 217-228.
8. D. Inkster, M. Zukowski, and P. A. Boncz, Integration of VectorWise with Ingres, SIGMOD Record, 40(3):45-53, 2011.
9. 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.
10. Microsoft, Column store Indexes in Books Online for SQL Server 2012, available at http://msdn.microsoft.com/en-us/library/gg492088.aspx.
11. Microsoft, SQL Server Column store Index FAQ, http://social.technet. microsoft.com/wiki/contents/articles/3540.sql-server-columnstore-index-faq-en- us.aspx.
12. M. Stonebraker et al. C-Store: A Column-oriented DBMS. VLDB, 2005, 553-564.
13. TPC Benchmark DS (Decision Support), Draft Specification, Version 32, http://tpc.org/tpcds.
14. ExaSolution, http://www.exasol.com
15. Greenplum Database, http://www.greenplum.com
16. InfoBright, http://www.infobright.com
17. Actian VectorWise, http://www.actian.com/products/vectorwise.
18. MonetDB, http://monetdb.cwi.nl
19. ParAccel Analytic Database, http://paraccel.com
20. SAND CDBMS, http://www.sand.com
21. Sybase IQ Columnar database, http://www.sybase.com/products/ datawarehousing/sybaseiq
22. Teradata Columnar, http://www.teradata.com/products-and-services/ database/teradata-14
23. Vertica, http://www.vertica.com