公开(公告)号：US09842137B2

公开(公告)日：2017-12-12

申请号：US14590769

申请日：2015-01-06

Applicant: SAP SE

Inventor： Franz Faerber ,  Daniel Baeumges ,  Tobias Mindnich ,  Christoph Weyerhaeuser

IPC: G06F17/30

CPC classification number: G06F17/30463 ,  G06F17/30315 ,  G06F17/30404 ,  G06F17/30433 ,  G06F17/30471

Abstract: The present invention includes a database with a semantic layer for performing standard SQL and complex operations custom to one or more application. In one embodiment the present invention includes receiving a data request from an application in a database, the data request specifying standard SQL operations and custom application operations to be performed for said application. The data request is processed in a semantic layer of the database. The semantic layer processes the standard SQL operations and the custom application operations and generates a logical execution plan comprising the standard SQL operations and the custom application operations. The logical execution plan is converted into a physical execution plan, which is executed by the database to generate a data result. The data result may be sent back to the application.

公开(公告)号：US09672250B2

公开(公告)日：2017-06-06

申请号：US15094708

申请日：2016-04-08

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Daniel Baeumges ,  Tobias Mindnich ,  Thomas Legler

IPC: G06F17/30 ,  G06F7/00

CPC classification number: G06F17/30471 ,  G06F17/30463 ,  G06F17/30466 ,  G06F17/30867

Abstract: A select query or a data referencing a calculation scenario is received by a database server from a remote application server. The specified calculation scenario is one of a plurality of calculation scenarios and it defines a data flow model that includes one or more calculation nodes. Each calculation node defines one or more operations to execute on the database server. Thereafter, the database server instantiates the specified calculation scenario and executes the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set. This data set is then provided by the database server to the application server. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20170024457A1

公开(公告)日：2017-01-26

申请号：US15286445

申请日：2016-10-05

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Daniel Baeumges ,  Gerrit Simon Kazmaier

IPC: G06F17/30

CPC classification number: G06F16/285 ,  G06F16/221 ,  G06F16/24578 ,  G06F16/29

Abstract: A range k-nearest neighbor search query of a database is processed by first defining an inner rectangle bounded within a circle around a center point specified by the range k-nearest neighbor search query. Thereafter, a distance to the center point is calculated for each point within the inner rectangle. Query results are returned if k or more points are within the inner rectangle. Otherwise, at least one additional query is executed. Related apparatus, systems, techniques and articles are also described.

Abstract translation: 通过首先定义围绕由范围k-最近邻搜索查询指定的中心点的圆圈内界限的内部矩形来处理数据库的范围k-最近邻搜索查询。 此后，针对内部矩形内的每个点计算到中心点的距离。 如果k个或更多个点在内部矩形内，则返回查询结果。 否则，至少执行一个附加查询。 还描述了相关设备，系统，技术和物品。

公开(公告)号：US09128969B2

公开(公告)日：2015-09-08

申请号：US14248099

申请日：2014-04-08

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Daniel Baeumges ,  Gerrit Simon Kazmaier

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30321 ,  G06F17/30241 ,  G06F17/30315 ,  G06F17/30445 ,  G06F17/30486

Abstract: A database query of point data among two or more axes of a database is received. The database stores point data in distinct integer vectors with a shared dictionary. Thereafter, the dictionary is scanned to determine boundaries for each axis specified by the query. In response, results characterizing data responsive to the query within the determined boundaries for each axis are returned. Related apparatus, systems, techniques and articles are also described.

Abstract translation: 接收到数据库的两个或多个轴之间的点数据的数据库查询。 数据库使用共享字典将点数据存储在不同的整数向量中。 此后，扫描字典以确定查询指定的每个轴的边界。 作为响应，返回表征响应于针对每个轴的确定的边界内的查询的数据的结果。 还描述了相关设备，系统，技术和物品。

公开(公告)号：US10482110B2

公开(公告)日：2019-11-19

申请号：US15286445

申请日：2016-10-05

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Daniel Baeumges ,  Gerrit Simon Kazmaier

IPC: G06F16/28 ,  G06F16/29 ,  G06F16/22 ,  G06F16/2457

Abstract: A range k-nearest neighbor search query of a database is processed by first defining an inner rectangle bounded within a circle around a center point specified by the range k-nearest neighbor search query. Thereafter, a distance to the center point is calculated for each point within the inner rectangle. Query results are returned if k or more points are within the inner rectangle. Otherwise, at least one additional query is executed. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20160224628A1

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

申请号：US15094708

申请日：2016-04-08

Applicant: SAP SE

Inventor： Christoph Weyerhaeuser ,  Daniel Baeumges ,  Tobias Mindnich ,  Thomas Legler

IPC: G06F17/30

CPC classification number: G06F17/30471 ,  G06F17/30463 ,  G06F17/30466 ,  G06F17/30867

Abstract: A select query or a data referencing a calculation scenario is received by a database server from a remote application server. The specified calculation scenario is one of a plurality of calculation scenarios and it defines a data flow model that includes one or more calculation nodes. Each calculation node defines one or more operations to execute on the database server. Thereafter, the database server instantiates the specified calculation scenario and executes the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set. This data set is then provided by the database server to the application server. Related apparatus, systems, techniques and articles are also described.

Abstract translation: 数据库服务器从远程应用程序服务器接收到选择查询或引用计算方案的数据。 指定的计算场景是多个计算场景之一，并且其定义包括一个或多个计算节点的数据流模型。 每个计算节点定义在数据库服务器上执行的一个或多个操作。 此后，数据库服务器实例化指定的计算方案，并执行由实例化计算方案的计算节点定义的操作，以生成响应数据集。 然后，该数据集由数据库服务器提供给应用服务器。 还描述了相关设备，系统，技术和物品。