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.1791475e-05
Overall Rank
9,335 | 37.43%
DOI
10.1145/3626750
PDF
Download (CC BY-NC 4.0)

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.0023948467
53 Eddies: Continuously Adaptive Query Processing 2000 SIGMOD 0.00040739114
149 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00028910892
161 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027629724
232 TiDB: A Raft-based HTAP Database 2020 VLDB 0.00023776373
332 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00020739447
838 Proactive Re-Optimization 2005 SIGMOD 0.00013528646
1,327 Hybrid Transactional/Analytical Processing: A Survey 2017 SIGMOD 0.00011014905
1,659 Real-Time Analytical Processing with SQL Server 2015 VLDB 9.9440956e-05
1,783 Greenplum: A Hybrid Database for Transactional and Analytical Workloads 2021 SIGMOD 9.6536753e-05
1,987 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 9.2323722e-05
2,796 Lethe: A Tunable Delete-Aware LSM Engine 2020 SIGMOD 7.9849253e-05
2,888 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.8895201e-05
2,895 Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads 2017 VLDB 7.8856044e-05
2,959 F1 Lightning: HTAP as a Service 2020 VLDB 7.7990674e-05
3,082 TitAnt: Online Real-time Transaction Fraud Detection in Ant Financial 2019 VLDB 7.6507218e-05
3,606 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? 2017 SIGMOD 7.1528863e-05
3,783 HTAP Databases: What is New and What is Next 2022 SIGMOD 7.0016354e-05
4,141 On Performance Stability in LSM-based Storage Systems 2020 VLDB 6.7690985e-05
4,339 Adaptive HTAP through Elastic Resource Scheduling 2020 SIGMOD 6.641183e-05
4,701 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.44638e-05
4,713 On Parallel Execution Of Multiple Pipelined Hash Joins 1994 SIGMOD 6.4397959e-05
5,157 ByteHTAP: ByteDance’s HTAP System with High Data Freshness and Strong Data Consistency 2022 VLDB 6.2362793e-05
5,192 PolarDB-IMCI: A Cloud-Native HTAP Database System at Alibaba 2023 SIGMOD 6.2209024e-05
5,605 How Good is My HTAP System? 2022 SIGMOD 6.0511725e-05
6,408 Replication at the Speed of Change - a Fast, Scalable Replication Solution for Near Real-Time HTAP Processing 2020 VLDB 5.7786603e-05
6,429 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.7691021e-05
7,094 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 5.5863735e-05
Previous Page 1 / 1 Next

Semantically Similar Papers