User-Defined Functions in Relational Databases - Challenges and Promising Solutions Based on YeSQL

Explore a keynote talk from SEBD 2023 that delves into the challenges and solutions of User-Defined Functions (UDFs) in relational databases, with a specific focus on YeSQL implementation. Learn about the evolution of UDFs in modern data management applications, including their crucial role in data science, analytics, and edge computing. Discover how YeSQL extends SQL with comprehensive UDF support, offering a pluggable architecture that integrates with both server-based and embedded database engines. Understand key innovations including Python UDF integration, tracing JIT compilation, parallelism, function fusion, stateful UDFs, and seamless database engine integration. Examine experimental results demonstrating up to 68x performance improvements compared to traditional approaches. Delivered by ACM President and University of Athens Professor Yannis Ioannidis, this presentation combines theoretical foundations with practical implementations, making it valuable for database professionals, researchers, and anyone interested in advanced data management solutions.