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
6757
Venue
SIGMOD
Year
2023
Pagerank
4.2482599e-05
Overall Rank
9,937 | 30.88%
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.1945683e-05
10,230 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.1945683e-05
10,265 AQD: Online Adaptive Query Dispatcher for HTAP Databases 2026 VLDB 4.1945683e-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.0040449103
115 Eddies: Continuously Adaptive Query Processing 2000 SIGMOD 0.00046221215
220 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00033194808
241 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00031420034
488 TiDB: A Raft-based HTAP Database 2020 VLDB 0.000220409
497 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00021716559
1,272 Proactive Re-Optimization 2005 SIGMOD 0.00012920076
1,792 Hybrid Transactional/Analytical Processing: A Survey 2017 SIGMOD 0.00010537893
2,312 Real-Time Analytical Processing with SQL Server 2015 VLDB 9.0530853e-05
2,631 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 8.4101843e-05
2,691 Greenplum: A Hybrid Database for Transactional and Analytical Workloads 2021 SIGMOD 8.2909126e-05
2,873 TitAnt: Online Real-time Transaction Fraud Detection in Ant Financial 2019 VLDB 7.9754477e-05
3,386 Lethe: A Tunable Delete-Aware LSM Engine 2020 SIGMOD 7.1577103e-05
3,408 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.1288167e-05
3,471 Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads 2017 VLDB 7.0639872e-05
3,768 F1 Lightning: HTAP as a Service 2020 VLDB 6.7782774e-05
4,161 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? 2017 SIGMOD 6.3938006e-05
4,284 HTAP Databases: What is New and What is Next 2022 SIGMOD 6.2914924e-05
4,781 On Parallel Execution Of Multiple Pipelined Hash Joins 1994 SIGMOD 5.9261504e-05
4,914 On Performance Stability in LSM-based Storage Systems 2020 VLDB 5.8315684e-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,865 ByteHTAP: ByteDance’s HTAP System with High Data Freshness and Strong Data Consistency 2022 VLDB 5.296893e-05
6,170 PolarDB-IMCI: A Cloud-Native HTAP Database System at Alibaba 2023 SIGMOD 5.171601e-05
6,501 How Good is My HTAP System? 2022 SIGMOD 5.0374293e-05
6,773 Replication at the Speed of Change – a Fast, Scalable Replication Solution for Near Real-Time HTAP Processing 2020 VLDB 4.9303548e-05
6,803 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 4.9224958e-05
7,776 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 4.6537231e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
4,770 The Case For Heterogeneous HTAP 2017 CIDR 5.9338845e-05
1,507 BatchDB: Efficient Isolated Execution of Hybrid OLTP+OLAP Workloads for Interactive Applications 2017 SIGMOD 0.00011617967
6,245 Iterative Query Processing based on Unified Optimization Techniques 2019 SIGMOD 5.1391202e-05
5,923 HyBench: A New Benchmark for HTAP Databases 2024 VLDB 5.2721765e-05
9,957 How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches 2025 VLDB 4.2373024e-05
6,501 How Good is My HTAP System? 2022 SIGMOD 5.0374293e-05
3,154 The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database 2016 VLDB 7.4686089e-05
7,688 Near-Data Processing in Database Systems on Native Computational Storage under HTAP Workloads 2022 VLDB 4.6772837e-05
4,284 HTAP Databases: What is New and What is Next 2022 SIGMOD 6.2914924e-05
5,005 Adaptive HTAP through Elastic Resource Scheduling 2020 SIGMOD 5.7641797e-05