Technical Perspective: PRISM and the Case for Strategic Opacity in UDF Optimization
ACM SIGMOD Record · 23.04.2026 · 55 (1) · 73-73
DOI: 10.1145/3810900.3810913 ↗Kurz gefasst
Fachartikel in der Zeitschrift ACM SIGMOD Record, online erschienen am 23.04.2026. Verfasst von Alkis Simitsis. Die Arbeit nennt 4 Literaturangaben.
Abstract (Originalsprache)
The history of UDF optimization in relational databases reads as a story of increasing transparency [2]. Compilation makes UDFs faster but leaves them opaque to the optimizer. Batching and fusion amortize invocation costs but still treat UDFs as black boxes. Inlining, most notably demonstrated by Microsoft's FROID system [3], aspires to the ultimate transparency by converting UDFs entirely into SQL, hence letting the optimizer reason about their contents. The trajectory seems inevitable: the path to better performance runs through making everything visible.
Zitieren
APA
Simitsis, A. (2026). Technical Perspective: PRISM and the Case for Strategic Opacity in UDF Optimization. ACM SIGMOD Record, 55(1), 73-73. https://doi.org/10.1145/3810900.3810913
Vancouver
Simitsis A. Technical Perspective: PRISM and the Case for Strategic Opacity in UDF Optimization. ACM SIGMOD Record. 2026;55(1):73-73. doi:10.1145/3810900.3810913
BibTeX
@article{Simitsis2026,
author = {Simitsis, Alkis},
title = {Technical Perspective: PRISM and the Case for Strategic Opacity in UDF Optimization},
journal = {ACM SIGMOD Record},
year = {2026},
volume = {55},
number = {1},
pages = {73--73},
doi = {10.1145/3810900.3810913}
}
EUVIMED