Database Paper Browser

Back to papers

Rethink Query Optimization in HTAP Databases

Summary: HTAP DBs with dual copies (row for OLTP, column for OLAP) enable cross-format hybrid plans and isolated execution. Metis, an HTAP-aware optimizer, preserves freshness and isolation while exploiting these plans, delivering up to 11x speedups and robustness to workload shifts. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
6758
Venue
SIGMOD
Year
2023
Pagerank
4.2470891e-05
Overall Rank
9,929 | 31.00%
DOI
10.1145/3626750

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank Citing Paper Year Venue Pagerank
10,030 Perseus: Achieving Strong Consistency and High Data Freshness for Scalable Geo-distributed HTAP 2026 SIGMOD 4.1905499e-05
10,230 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.1905499e-05
10,265 AQD: Online Adaptive Query Dispatcher for HTAP Databases 2026 VLDB 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 28 of 28 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0040465394
116 Eddies: Continuously Adaptive Query Processing 2000 SIGMOD 0.00046191288
221 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00033182072
241 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00031314629
486 TiDB: A Raft-based HTAP Database 2020 VLDB 0.00022039625
496 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00021705611
1,268 Proactive Re-Optimization 2005 SIGMOD 0.00012914584
1,786 Hybrid Transactional/Analytical Processing: A Survey 2017 SIGMOD 0.00010543881
2,419 Real-Time Analytical Processing with SQL Server 2015 VLDB 8.8485055e-05
2,632 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 8.4153283e-05
2,693 Greenplum: A Hybrid Database for Transactional and Analytical Workloads 2021 SIGMOD 8.2845883e-05
2,858 TitAnt: Online Real-time Transaction Fraud Detection in Ant Financial 2019 VLDB 8.0063362e-05
3,363 Lethe: A Tunable Delete-Aware LSM Engine 2020 SIGMOD 7.1680649e-05
3,402 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.134261e-05
3,459 Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads 2017 VLDB 7.0729792e-05
3,764 F1 Lightning: HTAP as a Service 2020 VLDB 6.7762323e-05
4,160 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? 2017 SIGMOD 6.3886736e-05
4,382 HTAP Databases: What is New and What is Next 2022 SIGMOD 6.2318984e-05
4,784 On Parallel Execution Of Multiple Pipelined Hash Joins 1994 SIGMOD 5.9205964e-05
4,920 On Performance Stability in LSM-based Storage Systems 2020 VLDB 5.8262404e-05
5,020 Adaptive HTAP through Elastic Resource Scheduling 2020 SIGMOD 5.7482116e-05
5,114 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 5.6813929e-05
5,853 ByteHTAP: ByteDance’s HTAP System with High Data Freshness and Strong Data Consistency 2022 VLDB 5.2982336e-05
6,154 PolarDB-IMCI: A Cloud-Native HTAP Database System at Alibaba 2023 SIGMOD 5.1795738e-05
6,518 How Good is My HTAP System? 2022 SIGMOD 5.0250374e-05
6,772 Replication at the Speed of Change – a Fast, Scalable Replication Solution for Near Real-Time HTAP Processing 2020 VLDB 4.9260148e-05
6,788 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 4.9207259e-05
7,776 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 4.6493147e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
4,774 The Case For Heterogeneous HTAP 2017 CIDR 5.9279395e-05
1,503 BatchDB: Efficient Isolated Execution of Hybrid OLTP+OLAP Workloads for Interactive Applications 2017 SIGMOD 0.0001161148
6,245 Iterative Query Processing based on Unified Optimization Techniques 2019 SIGMOD 5.1341887e-05
6,399 HyBench: A New Benchmark for HTAP Databases 2024 VLDB 5.0740852e-05
9,956 How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches 2025 VLDB 4.2332427e-05
6,518 How Good is My HTAP System? 2022 SIGMOD 5.0250374e-05
3,150 The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database 2016 VLDB 7.4765759e-05
7,689 Near-Data Processing in Database Systems on Native Computational Storage under HTAP Workloads 2022 VLDB 4.6727982e-05
4,382 HTAP Databases: What is New and What is Next 2022 SIGMOD 6.2318984e-05
5,020 Adaptive HTAP through Elastic Resource Scheduling 2020 SIGMOD 5.7482116e-05