公开(公告)号：US20200034480A1

公开(公告)日：2020-01-30

申请号：US16048863

申请日：2018-07-30

Applicant: SAP SE

Inventor： Gerrit Simon Kazmaier ,  Bare Said ,  Tobias Hoehmann ,  Jan Teichmann

IPC: G06F17/30

Abstract: A computer-implemented method for defining queries based on agile semantic objects (ASOs) is provided. Data definitions defining data structures are acquired from a plurality of data sources. The data definitions include information for fields, semantics, and data relationships and semantics for use in analytical environments. Using the data definitions, metadata is defined for ASOs representing data objects in the data definitions. The metadata and the ASOs are stored in an ASO repository. A request for creating a query is received. Metadata representing the ASOs is provided in response to the request for use in a query designer interface. A query based on selected ones of the ASOs is received from the query designer interface. The query is stored in a query repository. A runtime object for executing the query is provided.

公开(公告)号：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.

公开(公告)号：US20170293662A1

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

申请号：US15635004

申请日：2017-06-27

Applicant: SAP SE

Inventor： Edward-Robert Tyercha ,  Gerrit Simon Kazmaier ,  Hinnerk Gildhoff ,  Isil Pekel ,  Lars Volker ,  Tim Grouisborm

IPC: G06F17/30

CPC classification number: G06F16/2458 ,  G06F16/221 ,  G06F16/2237 ,  G06F16/29 ,  G06F16/86 ,  G06F16/9537

Abstract: A query of spatial data is received by a database comprising a columnar data store storing data in a column-oriented structure. Thereafter, a minimal bounding rectangle associated with the query is identified using a grid order scanning technique. The spatial data set corresponding to the received query is then mapped to physical storage in the database using the identified minimal bounding rectangle so that the spatial data set can be retrieved. Related apparatus, systems, techniques and articles are also described.