...
【24h】

Consolidation of Queries with User-Defined Functions

机译:合并具有用户定义功能的查询

获取原文
获取原文并翻译 | 示例
   

获取外文期刊封面封底 >>

       

摘要

Motivated by streaming and data analytics scenarios where many queries operate on the same data and perform similar computations, we propose program consolidation for merging multiple user-defined functions (UDFs) that operate on the same input. Program consolidation exploits common computations between UDFs to generate an equivalent optimized function whose execution cost is often much smaller (and never greater) than the sum of the costs of executing each function individually.We present a sound consolidation calculus and an effective algorithm for consolidating multiple UDFs. Our approach is purely static and uses symbolic SMTbased techniques to identify shared or redundant computations. We have implemented the proposed technique on top of the Naiad data processing system. Our experiments show that our algorithm dramatically improves overall job completion time when executing user-defined filters that operate on the same data and perform similar computations.
机译:受流和数据分析方案的激励,在该方案中,许多查询对同一数据进行操作并执行相似的计算,因此,我们提出了程序合并,以合并对同一输入进行操作的多个用户定义函数(UDF)。程序合并利用UDF之间的通用计算来生成等效的优化函数,其执行成本通常比单独执行每个函数的成本之和小得多(而且永远不会更大)。我们提出了一种合理的合并演算和一种有效的合并多个函数的算法UDF。我们的方法是纯静态的,并使用基于符号SMT的技术来识别共享或冗余计算。我们已经在Naiad数据处理系统的顶部实施了建议的技术。我们的实验表明,当执行对相同数据进行操作并执行相似计算的用户定义的过滤器时,我们的算法极大地缩短了整体作业完成时间。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号