DBScholar

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
hf90196b75f9c28e1
Venue
SIGMOD
Year
2023
Pagerank
5.1987909e-05
Overall Rank
9,301 | 37.47%
DOI
10.1145/3626750

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{song_sigmod23,
        title = {{Rethink Query Optimization in HTAP Databases}},
        author = {Song, Haoze and Zhou, Wenchao and Li, Feifei and Peng, Xiang and Cui, Heming},
        series = {{SIGMOD} '23},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3626750},
        url = {https://dl.acm.org/doi/10.1145/3626750},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

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.0023947656
53 Eddies: Continuously Adaptive Query Processing 2000 SIGMOD 0.00040860054
149 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00028981723
163 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.0002749118
234 TiDB: A Raft-based HTAP Database 2020 VLDB 0.00023765806
331 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.0002077683
836 Proactive Re-Optimization 2005 SIGMOD 0.00013557047
1,321 Hybrid Transactional/Analytical Processing: A Survey 2017 SIGMOD 0.00011040617
1,675 Real-Time Analytical Processing with SQL Server 2015 VLDB 9.9181121e-05
1,791 Greenplum: A Hybrid Database for Transactional and Analytical Workloads 2021 SIGMOD 9.6259014e-05
1,987 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 9.250242e-05
2,788 Lethe: A Tunable Delete-Aware LSM Engine 2020 SIGMOD 8.0133966e-05
2,891 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9021718e-05
2,922 Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads 2017 VLDB 7.8519075e-05
2,997 F1 Lightning: HTAP as a Service 2020 VLDB 7.7689996e-05
3,119 TitAnt: Online Real-time Transaction Fraud Detection in Ant Financial 2019 VLDB 7.6303377e-05
3,599 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? 2017 SIGMOD 7.1773938e-05
3,777 HTAP Databases: What is New and What is Next 2022 SIGMOD 7.0268163e-05
4,121 On Performance Stability in LSM-based Storage Systems 2020 VLDB 6.7946812e-05
4,399 Adaptive HTAP through Elastic Resource Scheduling 2020 SIGMOD 6.6152806e-05
4,690 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.4687131e-05
4,710 On Parallel Execution Of Multiple Pipelined Hash Joins 1994 SIGMOD 6.4574114e-05
5,253 ByteHTAP: ByteDance’s HTAP System with High Data Freshness and Strong Data Consistency 2022 VLDB 6.2080572e-05
5,288 PolarDB-IMCI: A Cloud-Native HTAP Database System at Alibaba 2023 SIGMOD 6.1944376e-05
5,711 How Good is My HTAP System? 2022 SIGMOD 6.0221783e-05
6,558 Replication at the Speed of Change - a Fast, Scalable Replication Solution for Near Real-Time HTAP Processing 2020 VLDB 5.7497828e-05
6,598 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.7405915e-05
7,072 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 5.6074688e-05
Previous Page 1 / 1 Next

Semantically Similar Papers