BlackMagic: Automatic Inlining of Scalar UDFs into SQL Queries with Froid
Summary: BlackMagic inlines scalar UDFs by translating UDFs into a single relational expression via Froid, exposing them to the optimizer. Enables set-based, parallel plans via nested-subquery optimization, yielding strong gains; SQL Server 2019 Scalar UDF Inlining. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,648 | One WITH RECURSIVE is Worth Many GOTOs | 2021 | SIGMOD | 6.8831123e-05 |
| 5,570 | iTurboGraph: Scaling and Automating Incremental Graph Analytics | 2021 | SIGMOD | 5.4284968e-05 |
| 6,645 | Functional-Style SQL UDFs With a Capital 'F' | 2020 | SIGMOD | 4.978205e-05 |
| 8,158 | MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates | 2020 | SIGMOD | 4.5730772e-05 |
| 9,160 | ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA | 2020 | SIGMOD | 4.3849295e-05 |
| 9,762 | QURE: AI-Assisted and Automatically Verified UDF Inlining | 2025 | SIGMOD | 4.2856106e-05 |
| 9,884 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB | 4.2635782e-05 |
| 11,069 | Hardware-Efficient Data Imputation through DBMS Extensibility | 2024 | VLDB | 4.1945683e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 3 of 3 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 639 | Orthogonal Optimization of Subqueries and Aggregation | 2001 | SIGMOD | 0.00018791492 |
| 1,108 | Froid: Optimization of Imperative Programs in a Relational Database | 2018 | VLDB | 0.00013984276 |
| 1,582 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00011265079 |
Previous
Page 1 / 1
Next