Efficient execution of user-defined functions in SQL queries
Y Foufoulas, A Simitsis - Proceedings of the VLDB Endowment, 2023 - dl.acm.org
User-defined functions (UDFs) have been widely used to overcome the expressivity
limitations of SQL and complement its declarative nature with functional capabilities. UDFs …
limitations of SQL and complement its declarative nature with functional capabilities. UDFs …
YeSQL: " you extend SQL" with rich and highly performant user-defined functions in relational databases
Y Foufoulas, A Simitsis, L Stamatogiannakis… - Proceedings of the …, 2022 - dl.acm.org
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 …
extension of the relational paradigm with syntactic and semantic support for User-Defined …
Optimizing tensor programs on flexible storage
Tensor programs often need to process large tensors (vectors, matrices, or higher order
tensors) that require a specialized storage format for their memory layout. Several such …
tensors) that require a specialized storage format for their memory layout. Several such …
User-defined functions in modern data engines
Y Foufoulas, A Simitsis - 2023 IEEE 39th International …, 2023 - ieeexplore.ieee.org
Modern data management applications involve complex processing tasks over large
volumes of data. Although this falls naturally within the scope of relational databases, many …
volumes of data. Although this falls naturally within the scope of relational databases, many …
Efficient and portable einstein summation in SQL
Computational problems ranging from artificial intelligence to physics require efficient
computations of large tensor expressions. These tensor expressions can often be …
computations of large tensor expressions. These tensor expressions can often be …
Pushing ML Predictions Into DBMSs
M Paganelli, P Sottovia, K Park… - … on Knowledge and …, 2023 - ieeexplore.ieee.org
In the past decade, many approaches have been suggested to execute ML workloads on a
DBMS. However, most of them have looked at in-DBMS ML from a training perspective …
DBMS. However, most of them have looked at in-DBMS ML from a training perspective …
[PDF][PDF] PyFroid: Scaling Data Analysis on a Commodity Workstation.
Almost every organization today is promoting data-driven decision making leveraging
advances in data science. According to various surveys, data scientists spend up to 80% of …
advances in data science. According to various surveys, data scientists spend up to 80% of …
Sharing Queries with Nonequivalent User-defined Aggregate Functions
This article presents Sharing User-Defined Aggregate Function (SUDAF), a declarative
framework that allows users to write User-defined Aggregate Functions (UDAFs) as …
framework that allows users to write User-defined Aggregate Functions (UDAFs) as …
The Duck's Brain: Training and Inference of Neural Networks in Modern Database Engines
Although database systems perform well in data access and manipulation, their relational
model hinders data scientists from formulating machine learning algorithms in SQL …
model hinders data scientists from formulating machine learning algorithms in SQL …