User-defined functions (UDFs) are an integral part of performing indatabase analytics. Executing data analysis inside a database provides significant improvements over traditional methods, such as close-to-the-data execution, low conversion overhead and automatic parallelization. However, UDFs have poor support for debugging. Since they are executed from within the database process, traditional debugging tools such as Integrated Development Environments (IDEs) and Read-Eval-Print Loops (REPLs) cannot be used during development. As a result, writing functional UDFs is challenging. In this paper, we present an extension to the open-source database system MonetDB that allows developers to debug their UDFs using modern debugging techniques.

32nd Brazilian Symposium on Databases, SBBD 2017
Database Architectures

Holanda, P., Raasveldt, M., & Kersten, M. (2017). Don’t keep my UDFs hostage - Exporting UDFs for debugging purposes. In Proceedings Brazilian Symposium on Databases (pp. 246–251).