SQL server column store indexes

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2011, Pages 1177-1184

  Larson, Per Åke ^a   Clinciu, Cipri ^a   Hanson, Eric N ^a   Oks, Artem ^a   Price, Susan L ^a   Rangarajan, Srikumar ^a   Surna, Aleksandras ^a   Zhou, Qingqing ^a  

^a MICROSOFT   (United States)

Author keywords

column store; columnar index; data warehousing; olap

Indexed keywords

DECISION SUPPORT SYSTEMS; QUERY LANGUAGES; QUERY PROCESSING;

COLUMNAR INDEX; COLUMNSTORES; DATA WAREHOUSE QUERIES; DECISION SUPPORT QUERY; FEATURE-BASED; FULLY INTEGRATED; OLAP; QUERY OPERATORS; QUERY PERFORMANCE; SQL SERVERS;

DATA WAREHOUSES;

EID: 79959984115     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1989323.1989448     Document Type: Conference Paper

References (20)

1. Abadi, D.J., Madden, S.R., and Ferreira, M.: Integrating compression and execution in column-oriented database systems. SIGMOD, 2006, 671-682.
2. Abadi, D.J., Myers, D.S., DeWitt, D.J., and Madden, S.R.: Materialization strategies in a column-oriented DBMS. ICDE, 2007, 466-475. (Pubitemid 47422050)
3. Abadi, D.J., Madden, S.R., and Hachem, N.: Column-stores vs. row-stores: how different are they really? SIGMOD, 2008, 981-992.
4. Batory, D. S.: On searching transposed files. ACM Trans. Database Syst. 4, 4 (1979), 531-544.
5. Copeland, G.P., Khoshafian, S.N.: A Decomposition Storage Model. In Proc. SIGMOD, 1985, 268-279.
6. Harizopoulos, S., Liang, V., Abadi, D.J., and Madden, S.: Performance tradeoffs in read-optimized databases. VLDB, 2006, 487-498.
7. Jeffrey A. Hoffer, Dennis G. Severance: The Use of Cluster Analysis in Physical Data Base Design. VLDB 1975: 69-86
8. S. Padmanabhan, T. Malkemus, R. Agarwal, and A. Jhingran. Block oriented processing of relational database operations in modern computer architectures. ICDE, 2001, 567-574. (Pubitemid 32457160)
9. M. Stonebraker et al. C-Store: A Column-oriented DBMS. VLDB, 2005, 553-564. (Pubitemid 43991033)
10. TPC Benchmark DS (Decision Support), Draft Specification, Version 32, available at http://tpc.org/tpcds.
11. Aster Data, http://www.asterdata.com
12. ExaSolution, http://www.exasol.com
13. Greenplum Database, http://www.greenplum.com
14. InfoBright, http://www.infobright.com
15. Ingres VectorWise, http://www.ingres.com/products/vectorwise
16. MonetDB, http://monetdb.cwi.nl
17. ParAccel Analytic Database, http://paraccel.com
18. SAND CDBMS, http://www.sand.com
19. Sybase IQ Columnar database, http://www.sybase.com/products/ datawarehousing/sybaseiq
20. Vertica, http://www.vertica.com