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,649 | One WITH RECURSIVE is Worth Many GOTOs | 2021 | SIGMOD | 6.8764882e-05 |
| 5,573 | iTurboGraph: Scaling and Automating Incremental Graph Analytics | 2021 | SIGMOD | 5.4268881e-05 |
| 6,646 | Functional-Style SQL UDFs With a Capital 'F' | 2020 | SIGMOD | 4.9734285e-05 |
| 8,162 | MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates | 2020 | SIGMOD | 4.5686903e-05 |
| 9,160 | ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA | 2020 | SIGMOD | 4.380727e-05 |
| 9,764 | QURE: AI-Assisted and Automatically Verified UDF Inlining | 2025 | SIGMOD | 4.2815042e-05 |
| 9,883 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB | 4.2594931e-05 |
| 11,072 | Hardware-Efficient Data Imputation through DBMS Extensibility | 2024 | VLDB | 4.1905499e-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 |
|---|---|---|---|---|
| 640 | Orthogonal Optimization of Subqueries and Aggregation | 2001 | SIGMOD | 0.00018780632 |
| 1,107 | Froid: Optimization of Imperative Programs in a Relational Database | 2018 | VLDB | 0.0001397627 |
| 1,581 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00011262795 |
Previous
Page 1 / 1
Next