公开(公告)号：US11360977B2

公开(公告)日：2022-06-14

申请号：US16371276

申请日：2019-04-01

Applicant: SAP SE

Inventor： Johannes Merx ,  Taehyung Lee ,  Sung Heun Wi ,  Jin Uk Bae ,  Ki Hong Kim ,  Stefan Baeuerle ,  Florian Scheid

IPC: G06F16/00 ,  G06F16/2453

Abstract: Implementations of the present disclosure include receiving, by a query processing server, a first query, the first query including a syntax indicating that precision loss is allowed, processing, by the query processing server, the first query to provide a first QEP, optimization of which would result in precision loss in a generated query result, determining that the syntax is provided, and in response, optimizing the first QEP to provide an optimized QEP, executing the optimized QEP to generate a query result that includes data stored within a database system, the query result having reduced accuracy relative to a query result that would be generated based on the first QEP, and providing the query result as output from the database system.

公开(公告)号：US11360972B2

公开(公告)日：2022-06-14

申请号：US16365903

申请日：2019-03-27

Applicant: SAP SE

Inventor： Taehun Kim ,  Taehyung Lee ,  Stephan Kessler ,  Kaweh Amoi-Taleghani ,  Thomas Seufert ,  Jens Hoff ,  Kai Morich ,  Jin Uk Bae ,  Chuho Chang

IPC: G06F16/00 ,  G06F16/242 ,  G06F21/62 ,  G06F16/248 ,  G06F16/2453

Abstract: Implementations of the present disclosure include receiving a view command for creating a view to display anonymized data in response to one or more queries, the view command including a view name, a table, a set of columns of the table, an anonymization type, a set of static parameters, and, for a sub-set of columns of the table, one or more sets of column-specific parameters, each set of column-specific parameters being specific to anonymization of data of a respective column of the table included in the sub-set of columns, storing the view command within the database system, and receiving a query referencing the view, and in response, providing a data set including data from each column in the sub-set of columns, receiving an anonymized data set including anonymized data that is generated from the data set using the anonymization type, the static parameters, and the sets of column-specific parameters.

公开(公告)号：US20180293276A1

公开(公告)日：2018-10-11

申请号：US15483690

申请日：2017-04-10

Applicant: SAP SE

Inventor： Jin Uk Bae ,  Stefan Baeuerle ,  Christian Bensberg ,  Steffen Geissinger ,  Ki Hong Kim ,  Taehyung Lee ,  Jaeyun Noh ,  Di Wu ,  Long Zhang

IPC: G06F17/30

Abstract: A method can include: generating a query execution plan for a query including a plurality of operations that operate on data from a relational database and data from a non-structured query language (NoSQL) database, the generating comprising optimizing the query by: identifying a first operation that operate on data from the relational database and an intermediate result output by a second operation, the second operation outputting the intermediate result by operating on the data from the NoSQL database; and determining a fixed datatype for the intermediate result, an indication of the fixed datatype being included in the query execution plan; and executing, based on the query execution plan, the query, the executing of the query comprising converting the intermediate result to the fixed datatype, the converting enabling the first operation to operate on the intermediate result output by the second operation along with the data from the relational database.

公开(公告)号：US20170147645A1

公开(公告)日：2017-05-25

申请号：US14947927

申请日：2015-11-20

Applicant: SAP SE

Inventor： Sang Il Song ,  Junhee Woo ,  Taehyung Lee ,  Sung Heun Wi ,  Ki Hong Kim ,  Yongsik Yoon

IPC: G06F17/30

CPC classification number: G06F16/24544

Abstract: Methods and apparatus, including computer program products, are provided for a case join. In one aspect, there is provided method, which may include receiving a query for a predefined view that is configured to inhibit modification; detecting whether the predefined view includes a database table extended to include an additional column; and generating, in response to the query, a view based on a case join, when the predefined view includes the database table extended to include the additional column. Related apparatus, systems, methods, and articles are also described.