Decorrelation of User Defined Function Invocations in Queries

Simhadri, V and Ramachandra, K and Chaitanya, A and Guravannavar, R and et al, . (2014) Decorrelation of User Defined Function Invocations in Queries. In: IEEE 30th International Conference on Data Engineering (ICDE), 31 Mar- 04 Apr, 2014, Chicago, IL.

Preview

Text
uudf.pdf - Accepted Version
Download (251kB) | Preview

Abstract

Queries containing user-defined functions (UDFs) are widely used, since they allow queries to be written using a mix of imperative language constructs and SQL, thereby increasing the expressive power of SQL; further, they encourage modularity, and make queries easier to understand. However, not much attention has been paid to their optimization, except for simple UDFs without imperative constructs. Queries invoking UDFs with imperative constructs are executed using iterative invocation of the UDFs, leading to poor performance, especially if the UDF contains queries. Such poor execution has been a major deterrent to the wider usage of complex UDFs.

[error in script]

IITH Creators: