Froid: Optimization of Imperative Programs in a Relational Database
Summary: Automatically rewrites UDFs into relational algebra expressions embedded in SQL, enabling cost-based optimization of imperative code. Froid is extensible, brings compiler-style optimizations to UDFs, and yields set-oriented, parallel plans with orders-of-magnitude speedups. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Karthik Ramachandra (Microsoft)
- 2. Kwanghyun Park (Microsoft)
- 3. K. Venkatesh Emani (Indian Institute of Technology Mumbai)
- 4. Alan Halverson (Microsoft)
- 5. César Galindo-Legaria (Microsoft)
- 6. Conor Cunningham (Microsoft)
BibTeX Citation
@article{ramachandra_vldb18,
title = {{Froid: Optimization of Imperative Programs in a Relational Database}},
author = {Ramachandra, Karthik and Park, Kwanghyun and Emani, K. Venkatesh and Halverson, Alan and Galindo-Legaria, César and Cunningham, Conor},
journal = {PVLDB},
series = {{VLDB} '18},
volume = {11},
number = {4},
pages = {432--444},
doi = {10.1145/3164135.3164140},
url = {https://doi.org/10.1145/3164135.3164140},
year = {2018}
}Incoming Citations (Sorted by Pagerank)
Showing 47 of 47 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 8 of 8 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 35 | Hekaton: SQL Server’s Memory-Optimized OLTP Engine | 2013 | SIGMOD | 0.00047937476 |
| 99 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00034024478 |
| 133 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.0003015194 |
| 554 | Orthogonal Optimization of Subqueries and Aggregation | 2001 | SIGMOD | 0.00016487919 |
| 1,381 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00010832197 |
| 2,992 | StatusQuo: Making Familiar Abstractions Perform Using Program Analysis | 2013 | CIDR | 7.7605188e-05 |
| 3,002 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD | 7.7473824e-05 |
| 7,454 | DBridge: Translating Imperative Code to SQL | 2017 | SIGMOD | 5.5095611e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,000 | Exploiting Correlations for Expensive Predicate Evaluation | 2015 | SIGMOD |
| 2 | 11,236 | UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines | 2025 | SIGMOD |
| 3 | 7,282 | Rule-Based Translation of Relational Queries into Iterative Programs | 1986 | SIGMOD |
| 4 | 8,002 | Efficient Execution of User-Defined Functions in SQL Queries | 2023 | VLDB |
| 5 | 2,521 | Optimization of Queries with User-defined Predicates | 1996 | VLDB |
| 6 | 9,729 | The UDFBench Benchmark for General-purpose UDF Queries | 2025 | VLDB |
| 7 | 6,413 | Functional-Style SQL UDFs With a Capital 'F' | 2020 | SIGMOD |
| 8 | 10,260 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB |
| 9 | 3,002 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD |
| 10 | 4,271 | BlackMagic: Automatic Inlining of Scalar UDFs into SQL Queries with Froid | 2019 | VLDB |