Database Paper Browser

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
5770
Venue
SIGMOD
Year
2019
Pagerank
5.1341887e-05
Overall Rank
6,245 | 56.60%
DOI
10.1145/3299869.3324960

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank Citing Paper Year Venue Pagerank
2,242 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.2124242e-05
4,645 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.0190618e-05
6,694 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 4.9552327e-05
9,160 ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA 2020 SIGMOD 4.380727e-05
10,426 Scalable Execution of Application Logic within Everest BusinessStore 2025 SIGMOD 4.1905499e-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
59 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.0006445664
87 Hekaton: SQL Server’s Memory-Optimized OLTP Engine 2013 SIGMOD 0.00052844656
640 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.00018780632
701 Building Efficient Query Engines in a High-Level Language 2014 VLDB 0.00017893039
1,107 Froid: Optimization of Imperative Programs in a Relational Database 2018 VLDB 0.0001397627
1,457 Rewriting Procedures for Batched Bindings 2008 VLDB 0.00011891025
1,751 Weld: A Common Runtime for High Performance Data Analytics 2017 CIDR 0.00010673874
2,270 S-Store: Streaming Meets Transaction Processing 2015 VLDB 9.149662e-05
2,383 How to Architect a Query Compiler 2016 SIGMOD 8.9198524e-05
2,637 A Transformation-Based Approach to Optimizing Loops in Database Programming Languages 1992 SIGMOD 8.399844e-05
3,298 Extracting Equivalent SQL from Imperative Code in Database Applications 2016 SIGMOD 7.2527707e-05
4,164 Sloth: Being Lazy is a Virtue (When Issuing Database Queries) 2014 SIGMOD 6.3859482e-05
7,293 Optimization for iterative queries on MapReduce 2014 VLDB 4.7668182e-05
8,482 Optimization of Common Table Expressions in MPP Database Systems 2015 VLDB 4.4965793e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
3,581 Translating Aggregate Queries into Iterative Programs 1986 VLDB 6.9455822e-05
9,956 How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches 2025 VLDB 4.2332427e-05
4,382 HTAP Databases: What is New and What is Next 2022 SIGMOD 6.2318984e-05
6,062 OLTPShare: The Case for Sharing in OLTP Workloads 2018 VLDB 5.2267464e-05
6,550 Rule-Based Translation of Relational Queries into Iterative Programs 1986 SIGMOD 5.0113524e-05
5,737 Enabling Incremental Query Re-Optimization 2016 SIGMOD 5.3459609e-05
11,628 Towards Multi-way Join Aware Optimizer in SAP HANA 2020 VLDB 4.1905499e-05
9,929 Rethink Query Optimization in HTAP Databases 2023 SIGMOD 4.2470891e-05
857 Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth 2012 SIGMOD 0.00015840492
9,190 Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs 2025 SIGMOD 4.3749452e-05