Real-Time Analytical Processing with SQL Server
Summary: Real-time analytics on one system by extending SQL Server's OLTP/OLAP with column store and in-memory engines. Four enhancements: column store indexes on in-memory tables; updatable secondary column store indexes on disk; B-tree indexes on primary column store indexes; faster column store scan operator. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Per-Åke Larson (Microsoft)
- 2. Adrian Birka (Microsoft)
- 3. Eric N. Hanson (Microsoft)
- 4. Weiyun Huang (Microsoft)
- 5. Michal Nowakiewicz (Microsoft)
- 6. Vassilis Papadimos (Microsoft)
BibTeX Citation
@article{larson_vldb15,
title = {{Real-Time Analytical Processing with SQL Server}},
author = {Larson, Per-Åke and Birka, Adrian and Hanson, Eric N. and Huang, Weiyun and Nowakiewicz, Michal and Papadimos, Vassilis},
journal = {PVLDB},
series = {{VLDB} '15},
volume = {8},
number = {12},
pages = {1740--1751},
doi = {10.14778/2824032.2824058},
url = {https://doi.org/10.14778/2824032.2824058},
year = {2015}
}Incoming Citations (Sorted by Pagerank)
Showing 36 of 36 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 |
|---|---|---|---|---|
| 38 | Hekaton: SQL Server’s Memory-Optimized OLTP Engine | 2013 | SIGMOD | 0.00047648573 |
| 165 | DB2 with BLU Acceleration: So Much More than Just a Column Store | 2013 | VLDB | 0.00027693424 |
| 172 | High-Performance Concurrency Control Mechanisms for Main-Memory Databases | 2012 | VLDB | 0.00027281663 |
| 940 | Enhancements to SQL Server Column Stores | 2013 | SIGMOD | 0.00013081205 |
| 1,747 | SQL Server Column Store Indexes | 2011 | SIGMOD | 9.8494706e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 8,109 | Relational Support for Flexible Schema Scenarios | 2008 | VLDB |
| 2 | 3,902 | The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates | 2014 | VLDB |
| 3 | 3,082 | Analytics in Motion: High Performance Event-Processing AND Real-Time Analytics in the Same Database | 2015 | SIGMOD |
| 4 | 4,637 | Columnstore and B+ tree – Are Hybrid Physical Designs Important? | 2018 | SIGMOD |
| 5 | 5,039 | Holistic Indexing in Main-memory Column-stores | 2015 | SIGMOD |
| 6 | 966 | A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database | 2009 | SIGMOD |
| 7 | 4,030 | Indexing on Modern Hardware: Hekaton and Beyond | 2014 | SIGMOD |
| 8 | 38 | Hekaton: SQL Server’s Memory-Optimized OLTP Engine | 2013 | SIGMOD |
| 9 | 1,747 | SQL Server Column Store Indexes | 2011 | SIGMOD |
| 10 | 940 | Enhancements to SQL Server Column Stores | 2013 | SIGMOD |