Database Paper Browser

Back to papers

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)

Paper ID
11052
Venue
VLDB
Year
2015
Pagerank
9.0530853e-05
Overall Rank
2,312 | 83.92%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 35 of 35 citing papers.

Rank Citing Paper Year Venue Pagerank
488 TiDB: A Raft-based HTAP Database 2020 VLDB 0.000220409
1,507 BatchDB: Efficient Isolated Execution of Hybrid OLTP+OLAP Workloads for Interactive Applications 2017 SIGMOD 0.00011617967
3,416 LeCo: Lightweight Compression via Learning Serial Correlations 2024 SIGMOD 7.1196234e-05
3,488 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.0479329e-05
3,905 Native Store Extension for SAP HANA 2019 VLDB 6.6408563e-05
4,284 HTAP Databases: What is New and What is Next 2022 SIGMOD 6.2914924e-05
4,688 Alibaba Hologres: A Cloud-Native Service for Hybrid Serving/Analytical Processing 2020 VLDB 5.9980609e-05
5,005 Adaptive HTAP through Elastic Resource Scheduling 2020 SIGMOD 5.7641797e-05
5,113 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 5.687445e-05
5,678 Cloud-Native Transactions and Analytics in SingleStore 2022 SIGMOD 5.3746593e-05
5,865 ByteHTAP: ByteDance’s HTAP System with High Data Freshness and Strong Data Consistency 2022 VLDB 5.296893e-05
5,923 HyBench: A New Benchmark for HTAP Databases 2024 VLDB 5.2721765e-05
6,170 PolarDB-IMCI: A Cloud-Native HTAP Database System at Alibaba 2023 SIGMOD 5.171601e-05
6,302 Diva: Making MVCC Systems HTAP-Friendly 2022 SIGMOD 5.1215989e-05
6,404 ColumnML: Column-Store Machine Learning with On-The-Fly Data Transformation 2019 VLDB 5.0786954e-05
6,501 How Good is My HTAP System? 2022 SIGMOD 5.0374293e-05
7,492 Krypton: Real-time Serving and Analytical SQL Engine at ByteDance 2023 VLDB 4.7180617e-05
7,688 Near-Data Processing in Database Systems on Native Computational Storage under HTAP Workloads 2022 VLDB 4.6772837e-05
7,741 Modern Main-Memory Database Systems 2016 VLDB 4.6632535e-05
7,876 Two Birds With One Stone: Designing a Hybrid Cloud Storage Engine for HTAP 2024 VLDB 4.6298182e-05
8,432 SPRINTER: A Fast n-ary Join Query Processing Method for Complex OLAP Queries 2020 SIGMOD 4.5153924e-05
9,620 Deploying Computational Storage for HTAP DBMSs Takes More Than Just Computation Offloading 2023 VLDB 4.3169852e-05
9,671 BIPie: Fast Selection and Aggregation on Encoded Data using Operator Specialization 2018 SIGMOD 4.306318e-05
9,904 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 4.258022e-05
9,937 Rethink Query Optimization in HTAP Databases 2023 SIGMOD 4.2482599e-05
10,030 Perseus: Achieving Strong Consistency and High Data Freshness for Scalable Geo-distributed HTAP 2026 SIGMOD 4.1945683e-05
10,063 Counting Is All You Need for Instant Tuple Discovery: Enabling Real-Time HTAP in Standalone DBMSs 2026 SIGMOD 4.1945683e-05
10,230 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.1945683e-05
10,251 Pisco: An Isolation Bug Case Reduction and Deduplication Framework 2026 VLDB 4.1945683e-05
10,265 AQD: Online Adaptive Query Dispatcher for HTAP Databases 2026 VLDB 4.1945683e-05
10,293 Vodka: Rethink Benchmarking Philosophy in HTAP Systems 2026 VLDB 4.1945683e-05
10,389 Rapid Data Ingestion through DB-OS Co-design 2025 SIGMOD 4.1945683e-05
10,607 Hermes: Off-the-Shelf Real-Time Transactional Analytics 2025 VLDB 4.1945683e-05
10,668 Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems 2025 VLDB 4.1945683e-05
10,772 veDB-HTAP: a Highly Integrated, Efficient and Adaptive HTAP System 2025 VLDB 4.1945683e-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
87 Hekaton: SQL Server’s Memory-Optimized OLTP Engine 2013 SIGMOD 0.00052389723
241 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00031420034
289 High-Performance Concurrency Control Mechanisms for Main-Memory Databases 2012 VLDB 0.00028938503
1,223 Enhancements to SQL Server Column Stores 2013 SIGMOD 0.00013207641
2,258 SQL Server Column Store Indexes 2011 SIGMOD 9.1678883e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
7,786 Relational Support for Flexible Schema Scenarios 2008 VLDB 4.6513838e-05
4,445 The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates 2014 VLDB 6.1808093e-05
3,388 Analytics in Motion: High Performance Event-Processing AND Real-Time Analytics in the Same Database 2015 SIGMOD 7.1571148e-05
5,113 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 5.687445e-05
5,376 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 5.5417421e-05
1,053 A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database 2009 SIGMOD 0.00014429683
4,386 Indexing on Modern Hardware: Hekaton and Beyond 2014 SIGMOD 6.2320098e-05
87 Hekaton: SQL Server’s Memory-Optimized OLTP Engine 2013 SIGMOD 0.00052389723
2,258 SQL Server Column Store Indexes 2011 SIGMOD 9.1678883e-05
1,223 Enhancements to SQL Server Column Stores 2013 SIGMOD 0.00013207641