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
6819
Venue
SIGMOD
Year
2023
Pagerank
5.158939e-05
Overall Rank
10,081 | 30.84%
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 3 of 3 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.0024089429
53 Eddies: Continuously Adaptive Query Processing 2000 SIGMOD 0.00041071971
151 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00029161879
165 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027693424
271 TiDB: A Raft-based HTAP Database 2020 VLDB 0.00022703024
345 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00020656723
829 Proactive Re-Optimization 2005 SIGMOD 0.00013769838
1,312 Hybrid Transactional/Analytical Processing: A Survey 2017 SIGMOD 0.00011193166
1,692 Real-Time Analytical Processing with SQL Server 2015 VLDB 9.9979924e-05
1,948 Greenplum: A Hybrid Database for Transactional and Analytical Workloads 2021 SIGMOD 9.432395e-05
1,987 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 9.3517129e-05
2,755 Lethe: A Tunable Delete-Aware LSM Engine 2020 SIGMOD 8.163097e-05
2,922 Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads 2017 VLDB 7.9593579e-05
2,944 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9335187e-05
2,972 F1 Lightning: HTAP as a Service 2020 VLDB 7.9114157e-05
3,203 TitAnt: Online Real-time Transaction Fraud Detection in Ant Financial 2019 VLDB 7.6402128e-05
3,598 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? 2017 SIGMOD 7.2718988e-05
3,762 HTAP Databases: What is New and What is Next 2022 SIGMOD 7.1449267e-05
4,262 On Performance Stability in LSM-based Storage Systems 2020 VLDB 6.7965035e-05
4,335 Adaptive HTAP through Elastic Resource Scheduling 2020 SIGMOD 6.7556868e-05
4,637 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.592197e-05
4,652 On Parallel Execution Of Multiple Pipelined Hash Joins 1994 SIGMOD 6.5851924e-05
5,155 ByteHTAP: ByteDance’s HTAP System with High Data Freshness and Strong Data Consistency 2022 VLDB 6.3420293e-05
5,477 PolarDB-IMCI: A Cloud-Native HTAP Database System at Alibaba 2023 SIGMOD 6.2051869e-05
5,602 How Good is My HTAP System? 2022 SIGMOD 6.1538237e-05
6,447 Replication at the Speed of Change - a Fast, Scalable Replication Solution for Near Real-Time HTAP Processing 2020 VLDB 5.8761879e-05
6,480 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.8669819e-05
7,655 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 5.5741093e-05
Previous Page 1 / 1 Next

Semantically Similar Papers