公开(公告)号：US09424313B2

公开(公告)日：2016-08-23

申请号：US14566953

申请日：2014-12-11

Applicant: SAP SE

Inventor： Jonathan Dees ,  Peter Sanders ,  Franz Faerber ,  Jochen Seidel

IPC: G06F17/30

CPC classification number: G06F17/30466 ,  G06F17/30463

Abstract: A pattern can be identified in at least part of a query whose definition is received in a query request. The identified pattern can be matched with a set of pre-defined patterns, each of which has associated therewith at least one pre-compiled query execution sub-component of a plurality of pre-compiled query execution sub-components retained in a library. A plan for executing the query can be generated, for example by incorporating the pre-compiled query execution sub-component associated with the matched pattern into the plan based on a pseudo code representation of the plan derived from the definition.

Abstract translation: 可以在查询的至少一部分中识别模式，该查询的定义在查询请求中被接收。 所识别的模式可以与一组预先定义的模式相匹配，每一模式都与保存在库中的多个预编译查询执行子组件的至少一个预编译查询执行子组件相关联。 可以生成用于执行查询的计划，例如通过基于从定义导出的计划的伪代码表示将与匹配模式相关联的预编译查询执行子组件合并到计划中。

公开(公告)号：US20160357816A1

公开(公告)日：2016-12-08

申请号：US15240432

申请日：2016-08-18

Applicant: SAP SE

Inventor： Jonathan Dees ,  Peter Sanders ,  Franz Faerber ,  Jochen Seidel

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/24542

Abstract: A pattern can be identified in at least part of a query whose definition is received in a query request. The identified pattern can be matched with a set of pre-defined patterns, each of which has associated therewith at least one pre-compiled query execution sub-component of a plurality of pre-compiled query execution sub-components retained in a library. A plan for executing the query can be generated, for example by incorporating the pre-compiled query execution sub-component associated with the matched pattern into the plan based on a pseudo code representation of the plan derived from the definition.