报告题目：YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases
论文出处：VLDB 2022
作者：Yannis Foufoulas U.，Alkis Simitsis，Lefteris Stamatogiannakis，Yannis Ioannidis U.
单位：Athena R.C.，Athena Research Center，University of Athens，Athens, Athena R.C.
报告人：雷亚松
报告时间：2022年12月06日 下午 1:00
报告地点：贵州大学北校区博学楼623室
报告内容摘要：The diversity and complexity of modern data management applications have led to the extension of the relational paradigm with syntactic and semantic support for User-Defined Functions (UDFs). Although well-established in traditional DBMS settings, UDFs have become central in many application contexts as well, such as data science, data analytics, and edge computing. Still, a critical limitation of UDFs is the impedance mismatch between their evaluation and relational processing. In this paper, we present YeSQL, an SQL extension with rich UDF support along with a pluggable architecture to easily integrate it with either server-based or embedded database engines. YeSQL currently supports Python UDFs fully integrated with relational queries as scalar, aggregator, or table functions. Key novel characteristics of YeSQL include easy implementation of complex algorithms and several performance enhancements, including tracing JIT compilation of Python UDFs, parallelism and fusion of UDFs, stateful UDFs, and seamless integration with a database engine. Our experimental analysis showcases the usability and expressiveness of YeSQL and demonstrates that our techniques of minimizing context switching between the relational engine and the Python VM are very effective and achieve significant speedups up to 68x in common, practical use cases compared to earlier approaches and alternative implementation choices. PVLDB Reference Format: Yannis Foufoulas, Alkis Simitsis, Lefteris Stamatogiannakis, and Yannis Ioannidis. YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases. PVLDB, 15(10): 2270 2283, 2022. doi:10.14778/3547305.3547328 PVLDB Artifact Availability: The source code, data, and/or other artifacts have been made available at https://github.com/athenarc/yesql.
