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

公开(公告)号：US10565200B2

公开(公告)日：2020-02-18

申请号：US14949372

申请日：2015-11-23

Applicant: SAP SE

Inventor： Taehyung Lee ,  Wolfgang Stephan ,  Felix Knittel ,  Chuho Chang

IPC: G06F16/24 ,  G06F16/2453

Abstract: Disclosed herein are system, method, and computer tangible medium embodiments for generating a relational database model from a model view that provides an estimate for generating query plan for a query on the model view, according to an embodiment. A join model of a model view set on one or more database tables is received. At least one index conversion of the join model is performed, where the index conversion converts at least one index in the join model into at least one leaf node in a relational model tree. At least one join conversion of the join model is performed where the at least one join conversion generates a node in the relational model tree that joins a first and second leaf nodes in the relational model tree. A requested parameter conversion is performed, where the requested parameter conversion includes an attribute or key figure requested by a query.

公开(公告)号：US11681702B2

公开(公告)日：2023-06-20

申请号：US16743680

申请日：2020-01-15

Applicant: SAP SE

Inventor： Taehyung Lee ,  Wolfgang Stephan ,  Felix Knittel ,  Chuho Chang

IPC: G06F16/24 ,  G06F16/2453

CPC classification number: G06F16/24544

Abstract: Disclosed herein are system, method, and computer tangible medium embodiments for generating a relational database model from a model view that provides an estimate for generating query plan for a query on the model view, according to an embodiment. A join model of a model view set on one or more database tables is received. At least one index conversion of the join model is performed, where the index conversion converts at least one index in the join model into at least one leaf node in a relational model tree. At least one join conversion of the join model is performed where the at least one join conversion generates a node in the relational model tree that joins a first and second leaf nodes in the relational model tree. A requested parameter conversion is performed, where the requested parameter conversion includes an attribute or key figure requested by a query.

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

公开(公告)号：US20200151180A1

公开(公告)日：2020-05-14

申请号：US16743680

申请日：2020-01-15

Applicant: SAP SE

Inventor： Taehyung Lee ,  Wolfgang Stephan ,  Felix Knittel ,  Chuho Chang

IPC: G06F16/2453

Abstract: Disclosed herein are system, method, and computer tangible medium embodiments for generating a relational database model from a model view that provides an estimate for generating query plan for a query on the model view, according to an embodiment. A join model of a model view set on one or more database tables is received. At least one index conversion of the join model is performed, where the index conversion converts at least one index in the join model into at least one leaf node in a relational model tree. At least one join conversion of the join model is performed where the at least one join conversion generates a node in the relational model tree that joins a first and second leaf nodes in the relational model tree. A requested parameter conversion is performed, where the requested parameter conversion includes an attribute or key figure requested by a query.

公开(公告)号：US20170147646A1

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

申请号：US14949372

申请日：2015-11-23

Applicant: SAP SE

Inventor： Taehyung Lee ,  Wolfgang Stephan ,  Felix Knittel ,  Chuho Chang

IPC: G06F17/30

Abstract: Disclosed herein are system, method, and computer tangible medium embodiments for generating a relational database model from a model view that provides an estimate for generating query plan for a query on the model view, according to an embodiment. A join model of a model view set on one or more database tables is received. At least one index conversion of the join model is performed, where the index conversion converts at least one index in the join model into at least one leaf node in a relational model tree. At least one join conversion of the join model is performed where the at least one join conversion generates a node in the relational model tree that joins a first and second leaf nodes in the relational model tree. A requested parameter conversion is perfonned, where the requested parameter conversion includes an attribute or key figure requested by a query.