arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 1909.03291cs.DBcs.PL
收藏

正在编译PL/SQL

Compiling PL/SQL Away

Christian Duta, Denis Hirn, Torsten Grust

摘要:

“PL/SQL函数很慢”,这是开发人员的普遍看法,源于面向集合的SQL计算和逐语句的PL/SQL解释之间的矛盾。我们追求编译PL/SQL的激进方法,将解释函数转换为常规子查询,然后可以与它们的拥抱SQL查询一起有效地评估,避免任何PL/SQL到SQL上下文切换。输入PL/SQL函数可以显示任意控制流。特别是,迭代被编译成SQL级别的递归。全面的RDBMS通过显著的运行时间节省来奖励这种编译工作,这使得已建立的开发人员知识受到质疑。

英文摘要:

"PL/SQL functions are slow," is common developer wisdom that derives from the tension between set-oriented SQL evaluation and statement-by-statement PL/SQL interpretation. We pursue the radical approach of compiling PL/SQL away, turning interpreted functions into regular subqueries that can then be efficiently evaluated together with their embracing SQL query, avoiding any PL/SQL to SQL context switches. Input PL/SQL functions may exhibit arbitrary control flow. Iteration, in particular, is compiled into SQL-level recursion. RDBMSs across the board reward this compilation effort with significant run time savings that render established developer lore questionable.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑