编译数据库应用程序
Compiling Database Application Programs
摘要:
出于性能原因,数据管理软件有越来越专业化的趋势。在本文中,我们研究了数据库应用程序的自动专业化和优化-查询和更新序列,增加了控制流结构,因为它们出现在数据库脚本,UDF,事务工作负载和触发器的语言,如PL/SQL。我们展示了如何使用生成式编程和最先进的编译器技术为数据库应用程序构建一个优化编译器。我们评估了一个手动优化的低级别实现的TPC-C,并确定了关键的优化技术,占其良好的性能。我们的编译器完全自动化这些优化,并应用到这个基准测试,超过手动优化的基线的两倍。通过选择性地禁用编译器中的一些优化,我们获得了一种临床和精确的方式来深入了解它们各自的性能贡献。
英文摘要:
There is a trend towards increased specialization of data management software for performance reasons. In this paper, we study the automatic specialization and optimization of database application programs -- sequences of queries and updates, augmented with control flow constructs as they appear in database scripts, UDFs, transactional workloads and triggers in languages such as PL/SQL. We show how to build an optimizing compiler for database application programs using generative programming and state-of-the-art compiler technology. We evaluate a hand-optimized low-level implementation of TPC-C, and identify the key optimization techniques that account for its good performance. Our compiler fully automates these optimizations and, applied to this benchmark, outperforms the manually optimized baseline by a factor of two. By selectively disabling some of the optimizations in the compiler, we derive a clinical and precise way of obtaining insight into their individual performance contributions.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。