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)
Incoming Non-self Citations Over Time
Authors
- 1. Per-Åke Larson (Microsoft)
- 2. Cipri Clinciu (Microsoft)
- 3. Eric N. Hanson (Microsoft)
- 4. Artem Oks (Microsoft)
- 5. Susan L. Price (Microsoft)
- 6. Srikumar Rangarajan (Microsoft)
- 7. Aleksandras Surna (Microsoft)
- 8. Qingqing Zhou (Microsoft)
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.
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
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,507 | Column Imprints: A Secondary Index Structure | 2013 | SIGMOD |
| 2 | 1,811 | Merging What's Cracked, Cracking What's Merged: Adaptive Indexing in Main-Memory Column-Stores | 2011 | VLDB |
| 3 | 104 | Improved Query Performance with Variant Indexes | 1997 | SIGMOD |
| 4 | 1,395 | Column-oriented Database Systems | 2009 | VLDB |
| 5 | 156 | An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server | 1997 | VLDB |
| 6 | 5,039 | Holistic Indexing in Main-memory Column-stores | 2015 | SIGMOD |
| 7 | 11,768 | Workload-Aware Column Imprints | 2020 | SIGMOD |
| 8 | 345 | Column-Stores vs. Row-Stores: How Different Are They Really? | 2008 | SIGMOD |
| 9 | 1,692 | Real-Time Analytical Processing with SQL Server | 2015 | VLDB |
| 10 | 940 | Enhancements to SQL Server Column Stores | 2013 | SIGMOD |