首页> 外国专利> Increasing performance of in-memory databases using re-ordered query execution plans

Increasing performance of in-memory databases using re-ordered query execution plans

机译:使用重新订购的查询执行计划提高内存数据库的性能

摘要

Implementations of the present disclosure include methods, systems, and computer-readable storage mediums for receiving a query from an application, determining that the query has been received before, and in response, retrieving statistics for the query from a metadata table, providing a query execution plan (QEP) associated with the query, the QEP including a plurality of operators executed to provide a query result, one or more operators of the plurality of operators requiring input from computer-readable memory, fragmenting at least one operator of the plurality of operators into multiple fragment operators to provide a fragmented QEP (fQEP), the multiple operators being executed to each provide a portion of a result of the at least one operator, and storing the fQEP in computer-readable memory.
机译:本公开的实现包括用于从应用程序接收查询的方法,系统和计算机可读存储介质,确定在从元数据表中检索查询的统计数据,从而确定已经接收到查询,从而从元数据表中检索查询的统计信息,提供查询执行程序(QEP)与查询相关联,包括执行多个运算符以提供查询结果,多个操作员的一个或多个需要从计算机可读存储器输入的操作员,将多个操作员分段运营商进入多个片段运算符以提供分段的QEP(FQEP),多个运算符被执行为每个运算符提供至少一个操作员的结果,并将FQEP存储在计算机可读存储器中。

著录项

  • 公开/公告号US11010379B2

    专利类型

  • 公开/公告日2021-05-18

    原文格式PDF

  • 申请/专利权人 SAP SE;

    申请/专利号US201715677700

  • 发明设计人 AHMAD HASSAN;

    申请日2017-08-15

  • 分类号G06F16/2453;G06F16/2458;G06F17/18;

  • 国家 US

  • 入库时间 2022-08-24 18:43:17

相似文献

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

客服邮箱:kefu@zhangqiaokeyan.com

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

  • 服务号