DBScholar

Back to papers

Enhancements to SQL Server Column Stores

Summary: Column store indexes are updatable and usable as base table storage, enabling data warehouses to exploit columnar layout. Batch processing gains broadened with new operators and a strengthened optimizer in the upcoming release to address initial limitations. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hfb63d5a7ca724410
Venue
SIGMOD
Year
2013
Pagerank
0.00012934104
Overall Rank
944 | 93.66%
DOI
10.1145/2463676.2463708

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{larson_sigmod13,
        title = {{Enhancements to SQL Server Column Stores}},
        author = {Larson, Per-Åke and Clinciu, Cipri and Fraser, Campbell and Hanson, Eric N. and Mokhtar, Mostafa and Nowakiewicz, Michal and Papadimos, Vassilis and Price, Susan L. and Rangarajan, Srikumar and Rusanu, Remus and Saubhasik, Mayukh},
        series = {{SIGMOD} '13},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2463676.2463708},
        url = {https://dl.acm.org/doi/10.1145/2463676.2463708},
        year = {2013}
}

Incoming Citations (Sorted by Pagerank)

Showing 27 of 27 citing papers.

Rank Citing Paper Year Venue Pagerank
163 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027480091
215 Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age 2014 SIGMOD 0.00024589307
605 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015640305
685 Trill: A High-Performance Incremental Query Processor for Diverse Analytics 2015 VLDB 0.00014778299
1,128 Qd-tree: Learning Data Layouts for Big Data Analytics 2020 SIGMOD 0.00011901941
1,380 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010858313
1,675 Real-Time Analytical Processing with SQL Server 2015 VLDB 9.9136747e-05
2,139 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 8.9735524e-05
2,317 BtrBlocks: Efficient Columnar Compression for Data Lakes 2023 SIGMOD 8.6492924e-05
2,765 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 8.0401855e-05
2,880 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.9118308e-05
2,926 Interleaving with Coroutines: A Practical Approach for Robust Index Joins 2018 VLDB 7.8446029e-05
3,446 Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing 2019 SIGMOD 7.2908619e-05
4,056 Scaling Up Concurrent Main-Memory Column-Store Scans: Towards Adaptive NUMA-aware Data and Task Placement 2015 VLDB 6.8239192e-05
4,692 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.4656516e-05
4,704 Adaptive NUMA-aware data placement and task scheduling for analytical workloads in main-memory column-stores 2017 VLDB 6.4600076e-05
5,020 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.3096708e-05
5,427 Joins on Encoded and Partitioned Data 2014 VLDB 6.133151e-05
5,816 Exploiting Ordered Dictionaries to Efficiently Construct Histograms with Q-Error Guarantees in SAP HANA 2014 SIGMOD 5.9817821e-05
5,842 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.971167e-05
6,243 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.8357659e-05
6,600 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.737874e-05
8,358 Resumable Online Index Rebuild in SQL Server 2017 VLDB 5.3459276e-05
8,423 Workload-Aware Incremental Reclustering in Cloud Data Warehouses 2026 SIGMOD 5.3324907e-05
8,849 Columnar Formats for Schemaless LSM-based Document Stores 2022 VLDB 5.2640252e-05
11,387 Freely Moving Between the OLTP and OLAP Worlds: Hermes – an High-Performance OLAP Accelerator for MySQL 2025 VLDB 4.9769913e-05
12,558 Microsoft SQL Server's Integrated Database Approach for Modern Applications and Hardware 2013 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 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.0006897844
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00064013679
114 A Decomposition Storage Model 1985 SIGMOD 0.00031916625
634 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015367822
1,631 Positional Update Handling in Column Stores 2010 SIGMOD 0.00010019069
1,765 SQL Server Column Store Indexes 2011 SIGMOD 9.6934008e-05
Previous Page 1 / 1 Next

Semantically Similar Papers