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.

uudf.pdf - Accepted Version

Download (251kB) | Preview


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:
IITH CreatorsORCiD
Item Type: Conference or Workshop Item (Paper)
Uncontrolled Keywords: Queries containing user-defined functions, Decorrelation,
Subjects: Computer science > Big Data Analytics
Divisions: Department of Computer Science & Engineering
Depositing User: Library Staff
Date Deposited: 20 May 2016 06:01
Last Modified: 20 May 2016 06:01
Publisher URL:
Related URLs:

Actions (login required)

View Item View Item
Statistics for RAIITH ePrint 2382 Statistics for this ePrint Item