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
4703
Venue
SIGMOD
Year
2013
Pagerank
0.00013081205
Overall Rank
940 | 93.56%
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
165 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027693424
241 Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age 2014 SIGMOD 0.00023654664
649 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015320656
710 Trill: A High-Performance Incremental Query Processor for Diverse Analytics 2015 VLDB 0.00014715033
1,135 Qd-tree: Learning Data Layouts for Big Data Analytics 2020 SIGMOD 0.00012032847
1,367 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00011014419
1,692 Real-Time Analytical Processing with SQL Server 2015 VLDB 9.9979924e-05
2,156 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 9.0635624e-05
2,788 BtrBlocks: Efficient Columnar Compression for Data Lakes 2023 SIGMOD 8.1205155e-05
2,866 Optimal Column Layout for Hybrid Workloads 2019 VLDB 8.0175489e-05
2,890 Interleaving with Coroutines: A Practical Approach for Robust Index Joins 2018 VLDB 7.9880033e-05
3,035 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 7.8297746e-05
3,555 Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing 2019 SIGMOD 7.3115321e-05
4,001 Scaling Up Concurrent Main-Memory Column-Store Scans: Towards Adaptive NUMA-aware Data and Task Placement 2015 VLDB 6.9663191e-05
4,607 Adaptive NUMA-aware data placement and task scheduling for analytical workloads in main-memory column-stores 2017 VLDB 6.6088324e-05
4,637 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.592197e-05
5,010 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.4023732e-05
5,357 Joins on Encoded and Partitioned Data 2014 VLDB 6.2497031e-05
5,693 Exploiting Ordered Dictionaries to Efficiently Construct Histograms with Q-Error Guarantees in SAP HANA 2014 SIGMOD 6.1189424e-05
6,042 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.9970052e-05
6,138 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.9640712e-05
6,480 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.8669819e-05
8,194 Resumable Online Index Rebuild in SQL Server 2017 VLDB 5.469529e-05
8,682 Columnar Formats for Schemaless LSM-based Document Stores 2022 VLDB 5.3857524e-05
10,306 Workload-Aware Incremental Reclustering in Cloud Data Warehouses 2026 SIGMOD 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,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 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.00069513174
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.0006312782
115 A Decomposition Storage Model 1985 SIGMOD 0.00032338948
630 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015591796
1,629 Positional Update Handling in Column Stores 2010 SIGMOD 0.00010184131
1,747 SQL Server Column Store Indexes 2011 SIGMOD 9.8494706e-05
Previous Page 1 / 1 Next

Semantically Similar Papers