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
5769
Venue
SIGMOD
Year
2019
Pagerank
5.1391202e-05
Overall Rank
6,245 | 56.56%
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,237 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.2212748e-05
4,648 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.0247446e-05
6,692 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 4.9599916e-05
9,160 ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA 2020 SIGMOD 4.3849295e-05
10,416 Scalable Execution of Application Logic within Everest BusinessStore 2025 SIGMOD 4.1945683e-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
60 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.00064439773
87 Hekaton: SQL Server’s Memory-Optimized OLTP Engine 2013 SIGMOD 0.00052389723
639 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.00018791492
704 Building Efficient Query Engines in a High-Level Language 2014 VLDB 0.00017900583
1,108 Froid: Optimization of Imperative Programs in a Relational Database 2018 VLDB 0.00013984276
1,456 Rewriting Procedures for Batched Bindings 2008 VLDB 0.00011899772
1,750 Weld: A Common Runtime for High Performance Data Analytics 2017 CIDR 0.00010683647
2,264 S-Store: Streaming Meets Transaction Processing 2015 VLDB 9.1575142e-05
2,383 How to Architect a Query Compiler 2016 SIGMOD 8.9294108e-05
2,632 A Transformation-Based Approach to Optimizing Loops in Database Programming Languages 1992 SIGMOD 8.4074026e-05
3,296 Extracting Equivalent SQL from Imperative Code in Database Applications 2016 SIGMOD 7.2596583e-05
4,166 Sloth: Being Lazy is a Virtue (When Issuing Database Queries) 2014 SIGMOD 6.391976e-05
7,294 Optimization for iterative queries on MapReduce 2014 VLDB 4.773119e-05
8,483 Optimization of Common Table Expressions in MPP Database Systems 2015 VLDB 4.5008949e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
3,577 Translating Aggregate Queries into Iterative Programs 1986 VLDB 6.9504079e-05
9,957 How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches 2025 VLDB 4.2373024e-05
4,284 HTAP Databases: What is New and What is Next 2022 SIGMOD 6.2914924e-05
6,060 OLTPShare: The Case for Sharing in OLTP Workloads 2018 VLDB 5.2305257e-05
6,554 Rule-Based Translation of Relational Queries into Iterative Programs 1986 SIGMOD 5.0155947e-05
5,727 Enabling Incremental Query Re-Optimization 2016 SIGMOD 5.3510544e-05
11,624 Towards Multi-way Join Aware Optimizer in SAP HANA 2020 VLDB 4.1945683e-05
9,937 Rethink Query Optimization in HTAP Databases 2023 SIGMOD 4.2482599e-05
858 Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth 2012 SIGMOD 0.000158756
9,186 Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs 2025 SIGMOD 4.3791424e-05