DBScholar

Back to papers

SQL Server Column Store Indexes

Summary: Introduces SQL Server Denali's column store index for data warehousing, enabling batch-processing to accelerate analytic queries. Describes its design, integration with the optimizer and execution engine, and shows large gains on DSS workloads. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
4529
Venue
SIGMOD
Year
2011
Pagerank
9.8494706e-05
Overall Rank
1,747 | 88.02%
DOI
10.1145/1989323.1989448

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{larson_sigmod11,
        title = {{SQL Server Column Store Indexes}},
        author = {Larson, Per-Åke and Clinciu, Cipri and Hanson, Eric N. and Oks, Artem and Price, Susan L. and Rangarajan, Srikumar and Surna, Aleksandras and Zhou, Qingqing},
        series = {{SIGMOD} '11},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1989323.1989448},
        url = {https://dl.acm.org/doi/10.1145/1989323.1989448},
        year = {2011}
}

Incoming Citations (Sorted by Pagerank)

Showing 23 of 23 citing papers.

Rank Citing Paper Year Venue Pagerank
649 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015320656
940 Enhancements to SQL Server Column Stores 2013 SIGMOD 0.00013081205
941 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013078348
964 Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes 2016 SIGMOD 0.00012934147
1,644 Compressed Linear Algebra for Large-Scale Machine Learning 2016 VLDB 0.00010132912
1,692 Real-Time Analytical Processing with SQL Server 2015 VLDB 9.9979924e-05
2,788 BtrBlocks: Efficient Columnar Compression for Data Lakes 2023 SIGMOD 8.1205155e-05
2,890 Interleaving with Coroutines: A Practical Approach for Robust Index Joins 2018 VLDB 7.9880033e-05
4,637 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.592197e-05
5,037 A Deep Dive into Common Open Formats for Analytical DBMSs 2023 VLDB 6.3914026e-05
5,477 PolarDB-IMCI: A Cloud-Native HTAP Database System at Alibaba 2023 SIGMOD 6.2051869e-05
6,103 VectorH: Taking SQL-on-Hadoop to the Next Level 2016 SIGMOD 5.9755412e-05
6,138 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.9640712e-05
7,182 Bubble Execution: Resource-aware Reliable Analytics at Cloud Scale 2018 VLDB 5.6793679e-05
7,991 Micro-architectural Analysis of OLAP: Limitations and Opportunities 2020 VLDB 5.5107319e-05
8,374 SPRINTER: A Fast n-ary Join Query Processing Method for Complex OLAP Queries 2020 SIGMOD 5.4399097e-05
8,682 Columnar Formats for Schemaless LSM-based Document Stores 2022 VLDB 5.3857524e-05
9,415 The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining 2025 VLDB 5.2742285e-05
10,067 Shared Load(ing): Efficient Bulk Loading into Optimized Storage 2020 CIDR 5.1643809e-05
10,135 I Can't Believe It's Not Yannakakis: Pragmatic Bitmap Filters in Microsoft SQL Server 2026 CIDR 5.093636e-05
11,015 Freely Moving Between the OLTP and OLAP Worlds: Hermes – an High-Performance OLAP Accelerator for MySQL 2025 VLDB 5.093636e-05
12,227 How Achaeans Would Construct Columns in Troy 2013 CIDR 5.093636e-05
12,261 Microsoft SQL Server's Integrated Database Approach for Modern Applications and Hardware 2013 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
12 C-Store: A Column-oriented DBMS 2005 VLDB 0.00069513174
60 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.0003955489
115 A Decomposition Storage Model 1985 SIGMOD 0.00032338948
345 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00020656723
630 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015591796
Previous Page 1 / 1 Next

Semantically Similar Papers