DBScholar

Back to papers

Iterative Query Processing based on Unified Optimization Techniques

Summary: Unified optimization for iterative HTAP query processing that spans procedural control flow and declarative SQL. Introduces query motion to move SQL in/out of loops and a cross-layer cost model for iteration-aware plan evaluation, delivering up to an order-of-magnitude gain over loop-invariant code motion. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
5831
Venue
SIGMOD
Year
2019
Pagerank
6.0171458e-05
Overall Rank
5,991 | 58.90%
DOI
10.1145/3299869.3324960

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{park_sigmod19,
        title = {{Iterative Query Processing based on Unified Optimization Techniques}},
        author = {Park, Kisung and Seo, Hojin and Rasel, Mostofa Kamal and Lee, Young-Koo and Jeong, Chanho and Lee, Sung Yeol and Lee, Chungmin and Lee, Dong-Hun},
        series = {{SIGMOD} '19},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3299869.3324960},
        url = {https://dl.acm.org/doi/10.1145/3299869.3324960},
        year = {2019}
}

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank Citing Paper Year Venue Pagerank
1,892 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.5277793e-05
3,992 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.9695338e-05
6,475 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 5.8687157e-05
9,315 ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA 2020 SIGMOD 5.289545e-05
10,699 Scalable Execution of Application Logic within Everest BusinessStore 2025 SIGMOD 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank Cited Paper Year Venue Pagerank
23 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.00054886415
38 Hekaton: SQL Server’s Memory-Optimized OLTP Engine 2013 SIGMOD 0.00047648573
534 Building Efficient Query Engines in a High-Level Language 2014 VLDB 0.00017046514
543 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.0001682612
894 Froid: Optimization of Imperative Programs in a Relational Database 2018 VLDB 0.00013367658
1,229 Weld: A Common Runtime for High Performance Data Analytics 2017 CIDR 0.00011578425
1,261 Rewriting Procedures for Batched Bindings 2008 VLDB 0.0001143305
1,797 How to Architect a Query Compiler 2016 SIGMOD 9.7368925e-05
1,915 S-Store: Streaming Meets Transaction Processing 2015 VLDB 9.4884706e-05
2,505 A Transformation-Based Approach to Optimizing Loops in Database Programming Languages 1992 SIGMOD 8.4960641e-05
2,939 Extracting Equivalent SQL from Imperative Code in Database Applications 2016 SIGMOD 7.9395908e-05
3,900 Sloth: Being Lazy is a Virtue (When Issuing Database Queries) 2014 SIGMOD 7.0361352e-05
7,168 Optimization for iterative queries on MapReduce 2014 VLDB 5.6841364e-05
8,483 Optimization of Common Table Expressions in MPP Database Systems 2015 VLDB 5.4157148e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,574 Translating Aggregate Queries into Iterative Programs 1986 VLDB
2 10,106 How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches 2025 VLDB
3 3,762 HTAP Databases: What is New and What is Next 2022 SIGMOD
4 5,686 OLTPShare: The Case for Sharing in OLTP Workloads 2018 VLDB
5 7,137 Rule-Based Translation of Relational Queries into Iterative Programs 1986 SIGMOD
6 5,552 Enabling Incremental Query Re-Optimization 2016 SIGMOD
7 11,819 Towards Multi-way Join Aware Optimizer in SAP HANA 2020 VLDB
8 10,081 Rethink Query Optimization in HTAP Databases 2023 SIGMOD
9 575 Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth 2012 SIGMOD
10 9,350 Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs 2025 SIGMOD