Self-tuning cost modeling of user-defined functions in an object-relational DBMS

@article{He2005SelftuningCM,
  title={Self-tuning cost modeling of user-defined functions in an object-relational DBMS},
  author={Zhen He and Byung Suk Lee and Robert R. Snapp},
  journal={ACM Trans. Database Syst.},
  year={2005},
  volume={30},
  pages={812-853}
}
Query optimizers in object-relational database management systems typically require users to provide the execution cost models of user-defined functions (UDFs). Despite this need, however, there has been little work done to provide such a model. The existing approaches are static in that they require users to train the model a priori with pregenerated UDF execution cost data. Static approaches can not adapt to changing UDF execution patterns and thus degrade in accuracy when the UDF executions… CONTINUE READING