公开(公告)号：US20160267129A1

公开(公告)日：2016-09-15

申请号：US15164432

申请日：2016-05-25

Applicant: SAP SE

Inventor： Sebastian Schroetel ,  Stefan Dipper ,  Michael Wilking ,  Christof Mueller

IPC: G06F17/30

Abstract: In one embodiment, a method receives a query for analyzing data in a database. The query includes a first level calculation that is performed before a second level calculation. When an operator associated with the first level calculation is present in the query, the method performs: calculating the first level calculation by removing group by information for a reference characteristic for the first level calculation to determine a first level calculation result and calculating the second level calculation using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result, wherein the group by in the second level calculation combines groups of rows in a database table of the database that have the same content in their specified columns.

Abstract translation: 在一个实施例中，方法接收用于分析数据库中的数据的查询。 该查询包括在第二级计算之前执行的第一级计算。 当在查询中存在与第一级计算相关联的操作者时，该方法执行：通过移除用于第一级计算的参考特征的信息组来计算第一级计算，以确定第一级计算结果并计算第二级 使用第一级计算结果使用用于参考特征的信息组进行计算，以确定第二级计算结果，其中第二级计算中的组合计算将数据库中具有相同内容的数据库表中的行组合 他们指定的列。

公开(公告)号：US10303726B2

公开(公告)日：2019-05-28

申请号：US14540781

申请日：2014-11-13

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Joerg Schad ,  Stefan Dipper

IPC: G06F16/9535 ,  G06F16/2453 ,  G06F16/901

Abstract: According to an aspect, a system for moving a filter in a query model to ensure query semantics includes a query engine configured to obtain a query model for a query to be executed on a database. The query engine includes a query optimizer configured to instantiate the query model by merging the query with the query model. The query optimizer includes a filter mover configured to move a filter to a point within the instantiated query model such that semantics for the query within the instantiated query model is ensured.