公开(公告)号：US20220391391A1

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

申请号：US17338452

申请日：2021-06-03

Applicant: SAP SE

Inventor： Dan Bi Park ,  Jin Uk Bae ,  Jane Jung Lee ,  Yoseob Kim

IPC: G06F16/2453 ,  G06F16/248

Abstract: Technologies are described for managing multiple cache specifications for a single view in a database environment. For example, a plurality of caches can be crated for the single view. Each of the plurality of caches can have a different cache specification. A query can then be received that operates on the single view. One of the plurality of caches can be selected for processing the query based at least in part on the cache specifications. The query can be processed using the selected cache. Results of processing the query can be output.

公开(公告)号：US20200311081A1

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

申请号：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/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.

公开(公告)号：US20200311296A1

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

申请号：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: G06F21/62 ,  G06F16/2453 ,  G06F16/248 ,  G06F16/242

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.

公开(公告)号：US11514042B1

公开(公告)日：2022-11-29

申请号：US17338452

申请日：2021-06-03

Applicant: SAP SE

Inventor： Dan Bi Park ,  Jin Uk Bae ,  Jane Jung Lee ,  Yoseob Kim

IPC: G06F16/2453 ,  G06F16/248

Abstract: Technologies are described for managing multiple cache specifications for a single view in a database environment. For example, a plurality of caches can be crated for the single view. Each of the plurality of caches can have a different cache specification. A query can then be received that operates on the single view. One of the plurality of caches can be selected for processing the query based at least in part on the cache specifications. The query can be processed using the selected cache. Results of processing the query can be output.

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