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
h5d2c9c4ac88e83e2
Venue
SIGMOD
Year
2011
Pagerank
9.6955121e-05
Overall Rank
1,766 | 88.13%
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
605 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015647561
906 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013160654
944 Enhancements to SQL Server Column Stores 2013 SIGMOD 0.00012939697
971 Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes 2016 SIGMOD 0.00012766019
1,614 Compressed Linear Algebra for Large-Scale Machine Learning 2016 VLDB 0.00010071891
1,675 Real-Time Analytical Processing with SQL Server 2015 VLDB 9.9181121e-05
2,314 BtrBlocks: Efficient Columnar Compression for Data Lakes 2023 SIGMOD 8.6533171e-05
2,925 Interleaving with Coroutines: A Practical Approach for Robust Index Joins 2018 VLDB 7.8482706e-05
4,635 A Deep Dive into Common Open Formats for Analytical DBMSs 2023 VLDB 6.4932705e-05
4,690 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.4687131e-05
5,288 PolarDB-IMCI: A Cloud-Native HTAP Database System at Alibaba 2023 SIGMOD 6.1944376e-05
5,817 VectorH: Taking SQL-on-Hadoop to the Next Level 2016 SIGMOD 5.9840356e-05
6,241 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.8381762e-05
7,312 Bubble Execution: Resource-aware Reliable Analytics at Cloud Scale 2018 VLDB 5.5555613e-05
8,050 Micro-architectural Analysis of OLAP: Limitations and Opportunities 2020 VLDB 5.3993433e-05
8,493 SPRINTER: A Fast n-ary Join Query Processing Method for Complex OLAP Queries 2020 SIGMOD 5.3310013e-05
8,840 Columnar Formats for Schemaless LSM-based Document Stores 2022 VLDB 5.2665183e-05
9,588 The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining 2025 VLDB 5.156809e-05
10,266 Shared Load(ing): Efficient Bulk Loading into Optimized Storage 2020 CIDR 5.0493495e-05
10,356 I Can't Believe It's Not Yannakakis: Pragmatic Bitmap Filters in Microsoft SQL Server 2026 CIDR 4.9793485e-05
11,381 Freely Moving Between the OLTP and OLAP Worlds: Hermes – an High-Performance OLAP Accelerator for MySQL 2025 VLDB 4.9793485e-05
12,518 How Achaeans Would Construct Columns in Troy 2013 CIDR 4.9793485e-05
12,552 Microsoft SQL Server's Integrated Database Approach for Modern Applications and Hardware 2013 VLDB 4.9793485e-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.00068998927
61 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.000392237
114 A Decomposition Storage Model 1985 SIGMOD 0.00031928929
331 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.0002077683
634 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015373122
Previous Page 1 / 1 Next

Semantically Similar Papers